Using MySQL with ASP - Tilted Forum Project Discussion Community

Stiltzkin · 08-02-2005, 06:28 PM

I don't need advice on how to set it up because I followed some tutorial on how to set it up and what not:
http://www.devarticles.com/c/a/ASP/U...abase-Via-ASP/
And I ran the sample code shown in the tutorial, and it works just fine. I just need to know how to do one really simple thing: how do I display records? In other words, I want to do something like this:

Code:

<%
'on error resume next

dim adoConn
dim adoRS
dim strQuery

set adoConn = Server.CreateObject("ADODB.Connection")
set adoRS = Server.CreateObject("ADODB.Recordset")
adoConn.Open "DSN=mysql_dsn"
strQuery = "select * from contacts"
adoConn.Execute strQuery
adoRS.ActiveConnection = adoConn

'do while not adoRS.EOF
   response.write adoRS.fields(0).value
   response.write("it did stuff")
   'adoRS.MoveNext
'loop
adoConn.Close
%>

But apparently this line:
response.write adoRS("contactId")

has something wrong with it. I tried variations like:
response.write adoRS.fields("contactId")
response.write adoRS.fields("contactId").value
response.write adoRS.fields(0).value

but none of them work. I don't know of I need to open the database or the connection in a different way just to be able to read it (which would be strange, because according to the samples on the tutorial I linked, you can add records and delete records without having to connect to the database in any special or particular way

)

And I've searched Google, but it just seems that no one is interested in using MySQL with ASP (since the popular choice is simply to access MySQL through PHP, but I'd rather not have to learn PHP unless it is completely necessary, since I already know ASP). I'm not saying I'll never learn PHP, but I first just want to expand my experience with working with databases. Once I'm comfortable with working with databases I'll move on to bigger and better things.

I'm also 100% positive that the database is not empty, 'cause I'd be getting an end-of-file error message before it gets to the erroneous line that I pointed out above, and I can see the recordset in SQLyog (cool frontend for MySQL which I'm sure most of you know about already) anyway, so I know it is there.

Anyone know how to accomplish this simple task in ASP?

EDIT: D'oh! I see a huge mistake I made. HUGE mistake. I shall fix it and repost in a few...

EDIT 2: Okay, I modified the code... but that same line is still giving me problems.

EDIT 3: Updated the code yet again, and now it just completely sits there. No error messages or anything, so I added a little debug line just to make sure it is alive, and sure enough there it is, the little message "it did stuff", but it still refuses to display any data from the database.

EDIT 4: Updated the code again. This nonsense is so infuriating; why can't they design these things more intuitively already? >_<

Stiltzkin · 08-02-2005, 09:45 PM

I gave up. I installed Apache and am in the process of making the switch to PHP. Why is it such a pain in the neck to do anything cool under Windows?

EDIT: Wow... I'm impressed with PHP so far. I just made a test script in PHP and it worked. Funny how something so simple can really make a person's day ('cause this sure as heck made my day). Doesn't look like I'll ever be turning back to ASP again...

Rawb · 08-03-2005, 02:27 PM

Welcome to the PHP fold, if there is anything you need, just feel free to bug me.

I've been programming PHP since the early 3.0 days, and doing CGI in C before that, so I know my way around a bit.

Here is some pretty generic and easy code to work with that should let you work a bit faster.

It's totally undocumented, but it should be pretty easy to figure out, overall, I really like it, and end up rewriting it everytime I work for a new company, so I finally rewrote it from scratch and BSD licenced it (so you can do whatever you want with it, I don't care).

Here it is: http://www.rawb.org/~rawb/phplibs.zip

For a fun first thing to try, after you have the libraries loaded, try:
maketable(dbread("SELECT something FROM somewhere"));

Stiltzkin · 08-04-2005, 12:28 AM

Cool, I appreciate this

Unfortunately I think the formatting got screwed up because all the carriage returns and line feeds are gone from all the files (blame winrar I suppose?). I'll be looking through this code to see what it does though.

Sorry if I sound a bit sheepish, just going through a sort of family crisis situation right now. I always appreciate sample code to learn from though.

Rawb · 08-05-2005, 05:22 PM

Ahh, actually, it came from a linux machine, which just uses LF, wheras windows needs CR/LF, so that probably ate all of the linefeeds.

Oh well, I guess you can stick it through an indenter so it can be formatted the way you want.

08-02-2005, 06:28 PM	#1 (permalink)
Stiltzkin Junkie	Using MySQL with ASP I don't need advice on how to set it up because I followed some tutorial on how to set it up and what not: http://www.devarticles.com/c/a/ASP/U...abase-Via-ASP/ And I ran the sample code shown in the tutorial, and it works just fine. I just need to know how to do one really simple thing: how do I display records? In other words, I want to do something like this: Code: <% 'on error resume next dim adoConn dim adoRS dim strQuery set adoConn = Server.CreateObject("ADODB.Connection") set adoRS = Server.CreateObject("ADODB.Recordset") adoConn.Open "DSN=mysql_dsn" strQuery = "select * from contacts" adoConn.Execute strQuery adoRS.ActiveConnection = adoConn 'do while not adoRS.EOF response.write adoRS.fields(0).value response.write("it did stuff") 'adoRS.MoveNext 'loop adoConn.Close %> But apparently this line: response.write adoRS("contactId") has something wrong with it. I tried variations like: response.write adoRS.fields("contactId") response.write adoRS.fields("contactId").value response.write adoRS.fields(0).value but none of them work. I don't know of I need to open the database or the connection in a different way just to be able to read it (which would be strange, because according to the samples on the tutorial I linked, you can add records and delete records without having to connect to the database in any special or particular way ) And I've searched Google, but it just seems that no one is interested in using MySQL with ASP (since the popular choice is simply to access MySQL through PHP, but I'd rather not have to learn PHP unless it is completely necessary, since I already know ASP). I'm not saying I'll never learn PHP, but I first just want to expand my experience with working with databases. Once I'm comfortable with working with databases I'll move on to bigger and better things. I'm also 100% positive that the database is not empty, 'cause I'd be getting an end-of-file error message before it gets to the erroneous line that I pointed out above, and I can see the recordset in SQLyog (cool frontend for MySQL which I'm sure most of you know about already) anyway, so I know it is there. Anyone know how to accomplish this simple task in ASP? EDIT: D'oh! I see a huge mistake I made. HUGE mistake. I shall fix it and repost in a few... EDIT 2: Okay, I modified the code... but that same line is still giving me problems. EDIT 3: Updated the code yet again, and now it just completely sits there. No error messages or anything, so I added a little debug line just to make sure it is alive, and sure enough there it is, the little message "it did stuff", but it still refuses to display any data from the database. EDIT 4: Updated the code again. This nonsense is so infuriating; why can't they design these things more intuitively already? >_< Last edited by Stiltzkin; 08-02-2005 at 06:52 PM..

08-02-2005, 09:45 PM	#2 (permalink)
Stiltzkin Junkie	I gave up. I installed Apache and am in the process of making the switch to PHP. Why is it such a pain in the neck to do anything cool under Windows? EDIT: Wow... I'm impressed with PHP so far. I just made a test script in PHP and it worked. Funny how something so simple can really make a person's day ('cause this sure as heck made my day). Doesn't look like I'll ever be turning back to ASP again... Last edited by Stiltzkin; 08-02-2005 at 09:55 PM..

08-04-2005, 12:28 AM	#4 (permalink)
Stiltzkin Junkie	Cool, I appreciate this Unfortunately I think the formatting got screwed up because all the carriage returns and line feeds are gone from all the files (blame winrar I suppose?). I'll be looking through this code to see what it does though. Sorry if I sound a bit sheepish, just going through a sort of family crisis situation right now. I always appreciate sample code to learn from though. Last edited by Stiltzkin; 08-04-2005 at 12:34 AM..

08-03-2005, 02:27 PM	#3 (permalink)
Rawb Crazy Location: Salt Town, UT	Welcome to the PHP fold, if there is anything you need, just feel free to bug me. I've been programming PHP since the early 3.0 days, and doing CGI in C before that, so I know my way around a bit. Here is some pretty generic and easy code to work with that should let you work a bit faster. It's totally undocumented, but it should be pretty easy to figure out, overall, I really like it, and end up rewriting it everytime I work for a new company, so I finally rewrote it from scratch and BSD licenced it (so you can do whatever you want with it, I don't care). Here it is: http://www.rawb.org/~rawb/phplibs.zip For a fun first thing to try, after you have the libraries loaded, try: maketable(dbread("SELECT something FROM somewhere"));

08-05-2005, 05:22 PM	#5 (permalink)
Rawb Crazy Location: Salt Town, UT	Ahh, actually, it came from a linux machine, which just uses LF, wheras windows needs CR/LF, so that probably ate all of the linefeeds. Oh well, I guess you can stick it through an indenter so it can be formatted the way you want.