joeisbatman
Programmer
QUESTION ONE:
Please bear with me- Lots of questions. This post is an old one that got lost in the forums, so I'm gonna repost it, hopefully Paul reads this ;-)
I'll sum up this problem: I want to close a connection after creating a recordset, using the client curosr location in an attempt to lessen the connections to my database. When I close the connection i get an error that everyone has told me means a field name doesn't match up with one in a database. I checked all the field names they are fine-- read on:
When I delete the "connectionToDatabase.close
set connectionToDatabase = nothing
at the top, it works. My code WAS after pauls suggestion:
frmID=Request.QueryString("ID"
Set connectionToDatabase=Server.CreateObject("ADODB.Connection"
connectionToDatabase.ConnectionTimeout=60
connectionToDatabase.Open "DSN=MyBuddyInfo1"
Set recordSet=Server.CreateObject("ADODB.RecordSet"
recordSet.cursorLocation = 2 'adUseClient
recordSet.cursorType = 3 'adOpenStatic
recordSet.lockType = 3 'adLockOptimistic
recordSet.Open "SELECT * FROM Users_Accounts_A WHERE ID=" &frmID, connectionToDatabase
connectionToDatabase.close
set connectionToDatabase = nothing%>
<html>
<body bgcolor="<% Response.Write(RecordSet("BGCOLOR") %>"
One of my friends thought that when we close the connection so early, the recordset object gets destroyed, which means it cannot find "BGCOLOR" in a recordset that is not there. Maybe I misunderstood the faq by paul about closing the connection so early...
QUESTION TWO i have a field where people can enter URLS. Sometimes people enter http:// and sometimes they just do www. I'm at a loss of finding a good way to parse the string to check if it starts with and if it doesn't add it. That way when its outputted to an html page the link actually works.
QUESTION THREE/FOUR
I want to store pictures. Users will upload the pics, and I will display then on a website. What is the best way to do this-- Should I store them in an access database or on the hard drive. I'm using win2k adv server, and I SUSPECT that somehow I can cache the database into ram, and hence give me faster results than reading binary data from the HD. Question four is-- if storing it into the DB is best, HOW on earth do I do such a thing, I know how to set up the datatype in access- just not how to actually GET the objects Data INTO the db.
QUESTION FIVE
Users may upload BMP's which take up WAY too much space, is there some kinda utility, or code i can use to auto convert the bmp's to jpegs and then store the jpeg? if there is some type of code that does it could you be very specific, I am still learning asp/VBscript.
Please bear with me- Lots of questions. This post is an old one that got lost in the forums, so I'm gonna repost it, hopefully Paul reads this ;-)
I'll sum up this problem: I want to close a connection after creating a recordset, using the client curosr location in an attempt to lessen the connections to my database. When I close the connection i get an error that everyone has told me means a field name doesn't match up with one in a database. I checked all the field names they are fine-- read on:
When I delete the "connectionToDatabase.close
set connectionToDatabase = nothing
at the top, it works. My code WAS after pauls suggestion:
frmID=Request.QueryString("ID"
Set connectionToDatabase=Server.CreateObject("ADODB.Connection"
connectionToDatabase.ConnectionTimeout=60
connectionToDatabase.Open "DSN=MyBuddyInfo1"
Set recordSet=Server.CreateObject("ADODB.RecordSet"
recordSet.cursorLocation = 2 'adUseClient
recordSet.cursorType = 3 'adOpenStatic
recordSet.lockType = 3 'adLockOptimistic
recordSet.Open "SELECT * FROM Users_Accounts_A WHERE ID=" &frmID, connectionToDatabase
connectionToDatabase.close
set connectionToDatabase = nothing%>
<html>
<body bgcolor="<% Response.Write(RecordSet("BGCOLOR"
) %>"One of my friends thought that when we close the connection so early, the recordset object gets destroyed, which means it cannot find "BGCOLOR" in a recordset that is not there. Maybe I misunderstood the faq by paul about closing the connection so early...
QUESTION TWO i have a field where people can enter URLS. Sometimes people enter http:// and sometimes they just do www. I'm at a loss of finding a good way to parse the string to check if it starts with and if it doesn't add it. That way when its outputted to an html page the link actually works.
QUESTION THREE/FOUR
I want to store pictures. Users will upload the pics, and I will display then on a website. What is the best way to do this-- Should I store them in an access database or on the hard drive. I'm using win2k adv server, and I SUSPECT that somehow I can cache the database into ram, and hence give me faster results than reading binary data from the HD. Question four is-- if storing it into the DB is best, HOW on earth do I do such a thing, I know how to set up the datatype in access- just not how to actually GET the objects Data INTO the db.
QUESTION FIVE
Users may upload BMP's which take up WAY too much space, is there some kinda utility, or code i can use to auto convert the bmp's to jpegs and then store the jpeg? if there is some type of code that does it could you be very specific, I am still learning asp/VBscript.