No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
Hello SQL Gurus, This Query below is doing the job but it is horrible slow. Is there any way to make the query faster ? Perhaps a join .. inner outer, left ? I am looooost. Thanks for any help. SQLQuery1.SQL.Clear; SQLQuery1.SQL.Text:= 'SELECT * FROM orders_batch WHERE invoice_no=:elorder_no'; SQLQuery1.params.parambyname('elorder_no').Asstring := … |
|
Hello there, I need some help with a query .. Table gamedate cutofftime 2011-08-25 13:55 I want to list games that are today +7 days but today games where the cutoff time has passed should not be displayed. Can anyone help me with this query please. Thank you for any … |
|
Hello Gurus, I have a table that holds one date field and one time field. The formats are 2011-12-01 and the time field format is 22:55:01 I want to compare a string "2011-12-01 22:58:00" to the date and time field of the table, without having to take the string apart. … |
|
Hello folks, i need help for a query.. I have 2 tables .. user table: useridid city and another table, the reward table : userid reward points , I want to sum up the points according to the city and list them.. Any ideas ? I am loooooost .. Thank … |
|
Hello all, I am stuck here with a problem. I want to check if someone enters a negative score on a multiple form page. I want that the edit field is red color if the score is negative. I call htis function with the onblur event input name="pickscorehome" type="text" class="pickedits" … |
|
Hello Gurus, i have several forms on a page that get generated dynamicly form a database. Checking the fields etc requires an id for each form .. i have a problem with this code here. . elid is the id of the form .. the elid gets passed from the … |
|
Hello ! I have a database that shows about 5 to 10 recorrds on a page that contain forms for the user to fill out. The number of rows is unknown and depends on the user query. On the page there can be 2 or 10 records displayed ..each containing … |