[angela]

hi

i have a huge database...currently a few thousand records..and its still expanding...
because of that i can't update the table at one time...it either goes into infinite loop or something to do with database timeout... i was advice by my lecturer to update the records 50 at a time...

now i am retrieving 50 records...after editing the values...update the 50 records and loop thru retreive the next 50 records..update...retrieve next 50 till end of file...but.......after selecting the first 50 records....using this

SELECT Top 50 * From customer_info order by customer_id

i have no idea how to select the next 50........i need help please...


an example i saw while surfing the net

select * from customer_info limit 1,255

would possibly solve my problem but
it gave this error
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '1'.
hmm seems like the identifier limit is not recognise in the sql server

please help..thank u!!

[tHeVibe]

Hy!
Try to use SELECT * FROM ...... LIMIT $limit,50

I hope will work like this! Good luck.
tHeVibe
devessence-c o m

[af11kcc]

Check for Recordset paging either using ADO or Getrows

[angela]

Thanks for the help!!

my project is due and yes..i managed to submit it on time...

i tried using LIMIT..it can't work...
sql server don't recognise the identifier LIMIT

initially i wanted to use GetRow..but i have problem with that...so i chage my concept..

i did the a comparison between the smallest and largest record then slowly i manage to get it working...

nonetheless, THANKS for all the help! learn a lot from u guys! really appreciated!