By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,160 Members | 1,983 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,160 IT Pros & Developers. It's quick & easy.

Help Please: Substitute Text to replace Stored Procedures for use with MySQL

P: n/a
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable



I have purchased a package that uses ASP and SQL, my webhost provides MYSQL=20
and I have loaded my access database and all seems to be working fine.=20

Except the stored procedures (Queries) the webhost says MYSQL doesn't suppor=
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:=20

SQLQuery =3D "SELECT * FROM tblAPCategories"
Set RS =3D gsconnect.Execute(SQLQuery)
Do While Not RS.EOF
<%=3DRS("catID")%>, etc...=20

This works fine for dumping the contents of these fields to the screen, my=20
problem is that my ASP app calls stored procedures in the following way:=20

sSQL =3D "qdpAPGetMaxCatLevel" etc... the variable seems to be called=20
repeatedly after this, I'm assuming sSQL is the variable, the query for this=

SELECT Max(catLevel) AS calcMaxLevel
FROM tblAPCategories;=20

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 AS=
text to make the ASP function as intended, it just crashes out at the point=20
this is called, and believe me I have tried everything, except what works=20

I even tried creating a table with the same name and typing in the answer=20
just to see if I could further, it knew it was a table and stopped just the=20=

Can anyone help, if I can crack one I think I can crack the rest, although t=
be fair this appears to be one of the easier queries.=20

Thanks in advance for anyone's help.=20


Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.