Hi
I have purchased a package that uses ASP and SQL, my webhost provides MYSQL and I have loaded my access database and all seems to be working fine. Except the stored procedures (Queries) the webhost says MYSQL doesn't support stored procedures, as this site confirms (wait for v5.0) but the same effect can be achieved using ASP, an example of what they offer in help is below: SQLQuery = "SELECT * FROM tblAPCategories" Set RS = gsconnect.Execute(SQLQuery) Do While Not RS.EOF %> <%=RS("catID")%>, etc... This works fine for dumping the contents of these fields to the screen, my problem is that my ASP app calls stored procedures in the following way: sSQL = "qdpAPGetMaxCatLevel" etc... the variable seems to be called repeatedly after this, I'm assuming sSQL is the variable, the query for this is: SELECT Max(catLevel) AS calcMaxLevel FROM tblAPCategories; The answer is 3 which I can get to using the ASP text suggested, but I can't seem to work out how to replace the call to the stored procedure with the ASP text to make the ASP function as intended, it just crashes out at the point this is called, and believe me I have tried everything, except what works obviously. I even tried creating a table with the same name and typing in the answer just to see if I could further, it knew it was a table and stopped just the same. Can anyone help, if I can crack one I think I can crack the rest, although to be fair this appears to be one of the easier queries. Thanks in advance for anyone's help. Chris