469,648 Members | 1,585 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,648 developers. It's quick & easy.

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

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
0 1635

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by slash | last post: by
8 posts views Thread by John Wildes | last post: by
3 posts views Thread by Marty | last post: by
13 posts views Thread by Jennifer.Berube | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.