472,353 Members | 1,167 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,353 software developers and data experts.

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 1741

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: slash | last post by:
Hi , Im new to MySql and i have no idea how to convert a sql server user defined function to MySql. Can any one help me.. CREATE FUNCTION...
by: Ben | last post by:
Dear MySQL experts, I have a website that is using MS SQL Server 2000 with ASP scripting. I want to switch over to MySQL, but I'm just sticking...
by: baustin75 | last post by:
Posted: Mon Oct 03, 2005 1:41 pm Post subject: cannot mail() in ie only when debugging in php designer 2005 ...
by: Tony | last post by:
Can someone a little more clever than I (which means just about anyone on this list) tell me what the implications/benefits are of this are...
by: Jeff Marcum | last post by:
I need to write a query in Access that returns the results of a text field with the spaces replaced with underscores. So, if the data in the field...
by: John Wildes | last post by:
Hello all I'm going to try and be brief with my question, please tell me if I have the wrong group. We are querying transaction data from a...
by: Marty | last post by:
Is there an issue with stored procedure and mySQL v5.0.18 ? We are programming an application that need stored procedures and triggers and our...
by: bshumsky06 | last post by:
Hi, I am trying to create stored procedures in MySQL. Does anyone have a suggestion on a good IDE to use. I have been working with the MySQL...
by: Jennifer.Berube | last post by:
well I'm not sure how to go about making my SQL connection string... The code below is what I need to replace with my SQL connection...I just...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the...
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.