i tried something like this but the id value is not changing, getting the value for first record and set the value for all rest...
insert into table1 (Id,b,c,d)
(select (select max(Id)+1 from table1),x,y,z from table2 where... )
I'm creating a sql based procedure which can
Accept a table
load the values one at a time
send the variables to a remote API
Record the response of the API
Write the response to a table for viewing later
I have successfully implemented 1,2, and 5. I am hoping there may be some way of choosing an address to contact and for SQL to listen too for a response. Please let me know if you have any suggestions!
Hello everyone,
I am working on one real estate website which is Using RETS service to get the data to my local server.
but I have one little bit problem here,I can fetch data from RETS which is having about 3lacks record in RETS Database but I didn't find the way,How can I fetch that all records in bunch of 50k at a time ?
I didn't find any 'LIMIT' keyword on RETS.so how can I fetch without 'LIMIT' 50k records at a time?
Please help me.
i will need to store 3 tables of data
instead of implementing an entire database backend, i just want to store the record for these tables in application.settings
has anyone done this before?
i dont care about security
is it advisable to do it with application settings? how else would you do it?
perhaps storing a matrix in application.settings would be OK?
When I look back my codes that written earlier time, I found something terribly bad.
Whenever I want to delete a record in the database, I did like this :
$.post("deleteAction.do",{recordId:10});
I cannot prevent a malicious user visit my database operation url directly :
deleteAction.do?recordId=10
What's the solution for this kind of problem ?
Is it better to write/record selenium tests in html format and run them directly in the server with "-htmlSuite" or to write the tests in java/C#/... and run them in the server using selenium-rc?
What is the recommended solution?
windows only record 1 user/pwd to a remote share dir,
and my program need to connect a dir,
but the user may login first, let my program failed to connect,
is there a method to disconnect it? i only know the IP.
I use wnetcancelconnection2(remotedir) first, but still cannot work,
and return 1219 error(credentials supplied conflict with an existing set of credentials)
Consider i have a registartion table and there is field prefLocationId and it contains value like this 1,2,3,2,1,4 and so many.... And i have a table prefLocation which looks like this
Id LocationName
1 Chennai
2 Mumbai
3 Kolkatta
4 Delhi
and i want to select record of users and show values like
Chennai,Mumbai,Kolkatta,Mumbai,Chennai,Delhi and so on...
In my page if the text of a Label has been Changed I need to fire some function using JQuery as .Change() is restricted to only <input> and <select> I use a function like
$("#ctl00_ContentPlaceHolder1_lblMsg").html("Duplicate record can't be saved.")
.trigger('labelchanged')
$("#ctl00_ContentPlaceHolder1_lblMsg").on('labelchanged', function () {
alert('changed!');
}
});
but the above function is not triggered when the text of the label has been changed kindly anyone point me what could be I am missing in the above function
I want to write a component that uses 2 webcams (1 integrated in my laptop , the other is a USB webcam)
What do I need to know (or have) to build a component to deal with the cameras (capture , record , movement recognition , and other image and video processing) ? and how ?
(with C++ or Delphi)
I just need to know the concepts and main techniques , any good resources or source codes would be great :)
Thank you .
I have a table with 42 million records. 32 million have a null value and I would like to generate a new guid for each one. Should I do this in batches?
Also, going forward, I would like a new guid added to the field on the insert of a new record. What is the best way to do this?
The field is not the primary key, which is an auto-incrementing integer.
Hi,
What is the best way to demo an iPhone app on a projector?
Preferably without jailbreaking and without using a separate camera to record the iPhone screen which might limit movement?
Thanks,
Tee
`*the midvile park maintains records containing info about players on it's soccer teams . each record contain a players first name,last name,and team number . the team are
team number team name
1 goal getters
2 the force
3 top gun
4 shooting stars
5 midfield monsters
design a proggram that accept player data and creates a report that lists each player along with his or her team number and team name
I have a simple problem, I think, but I have googled and can't find the solution. I have a cube that has MeasureA, MeasureB and MeasureC. Not all three measures have values for each record, sometimes they can be null, it's depending if it was applicable.
Now for my totals, I need to average but the average must not take nulls into account. Any help will be much appreciated. When I view the measures, the null values show as zeros.
I want to copy a record with all his relations.
I'm trying with:
$o = Doctrine::getTable('Table')->Find(x);
$copy = $object->copy();
$relations = $o->getRelations();
foreach ($relations as $name => $relation) {
$copy->$relation = $object->$relation->copy();
}
$copy->save();
This code doesn't works, but I think it's on the way.
When user opens a form to modify a record, but instead of changing information, he just clicks the Update button. Which causes the update() function to return 0. However, I consider this case a valid update task. How would I test it, so I can assign a success message?
Is update() returns -1 when SQL query failed or also 0?
Method: Zend_Db_Table_Abstract::update()
Any ideas?
Thanks
I keep finding myself in this situtation:
I have an ASP.NEt 2.0 app. I have to insert into 2 tables in SQL. There is a dependency between the tables. I insert a record the first using a transaction. Then I move onto the 2nd table. But, because the first isn't committed yet the second one throws a error.
I'm a Linux user looking to write a program which will pick up the phone, dial a number, play a recording and record what the person on the other end of the line says and save it to an audio file. I will want to use the modem that came with my computer if possible. What should I use to write this program?
Im using linq-sql .I have 3 tables. e.g
Project, People and a ProjectsPeople(fk's ProjectID and PeopleID) (junction) Table.
given a set of peopleIDArray (an array of ints as people ID's)
how can i get only Projects that have atleast one of the peopleId's associated with them?
i.e there will be atleast one (may be more) record in the ProjectsPeople table that will have a ProjectId and an id from the peopleIDArray )
thanks
Doesn't prepare() escape any quotes(') in a PDO statement? For some reason when I do this:
$sql = "INSERT INTO sessions (id, name) VALUES (1,'O'brian')";
$query = $this->connection->prepare($sql);
$query->execute();
I get this error:
Could not insert record SQLSTATE[42000]: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near 'brian'.
How could this be if I'm using prepare()?
I'm making a database program. I want the user to be able to define their own columns, as many as they want. How would I then define each record in its class file?(Since the properties would be different user to user)
EDIT:
It's part of a school assignment-it's going to hold different scores and the likes for the teacher for different students they can add, but they will also be able to add a new assignment, test(a column) .
I dont see any direct mention on using multiple slugs (or any behavior for that matter) for single model. Is there a way to use the sluggable behavior to generate two separate slugs for a model?
For example i need to generate two slugs for every record a product_id consisting of a slugified company name and sku and a distributor_id consisting of a different slugified company name.
Obviously i could write this myself fairly easily, im just wondering if this can be done quickly with Sluggable.
Hello.
I'm working on Flash ActionScript.
My Movie Load some data like photo, sounds and photo to the Movie Stage. Each of loaded MovieClip have own animation.
Is it possible to generate (record) FLV or other Movie file from ActionScript with ActionScript?
i have a datagrid. which display some values which is already inserted and that is fetched from database.but from the datagrid i need to insert the values to database. how to find in which row a new record get inserted and to pass all the values to database
any idea???