porting ASP/Access to ASP/mySQL

[MillsRJ]

ok, managed to get mySQL up and running, but keep getting errors from my config.asp.

1) why doesn't the "SELECT TOP * 1 FROM ..." work anymore?
2) also, had an array that was working fine but now I get a subscript out of range error.

ReDim MenuEntry(objRsConfig.RecordCount,2)
iRun = 1
Do While Not objRsConfig.EOF
MenuEntry(iRun,1) = objRsConfig("CategoryName&quot

it coughs on the last line above.

3) Lastly, (I thought this stuff was platform/db independant). I get a "current recordset does not support bookmarks" (it did with access)

objRs.AbsolutePage = 1

if I sound frustrated, it's only because I am

thanks in advance. Rob Mills
System Analyst
Correctional Services Canada
(all statements are my own and do not reflect on my employer)

 

[MillsRJ]

moving me up, please help Rob Mills
System Analyst
Correctional Services Canada
(all statements are my own and do not reflect on my employer)

 

[Tarwn]

Ok,
1), 2), and 3) make sure MySQL supports this functionality. Check with the documentation that came with your version to make sure that it supports the functionality you were using in Access. Soe version support it 100%, despite access not being up to spec for a SQL db, but some MySQL versions only support functionality for access where access was actually following the guideline for SQL and Relational Databases.
-Tarwn "Customer Support is an art not a service" - marketing saying
"So are most other forms of torture" - programmers response
(The Wiz Biz - Rick Cook)