Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more - View Single Post

Itsacon · 09-10-2006, 12:05 AM

Hmm, don't have experience with ASP, so don't know the syntax, but I'll try to explain what you need to do.

the 'request.querystring("playerID")' sounds pretty logical to me, I assume that's the code to request the part from the querystring (GET and POST vars) that's tagged 'playerID'.

Then you need to parse it into the SQL query. Again, I don't know the ASP syntax for string concatenation, but I believe it's the ampersand (&):

Your current code will be something like this:

Code:

SQLquery = "SELECT * FROM mydatabase where playerID = 'player1'";

change it to something like this

Code:

SQLquery = "SELECT * FROM mydatabase where playerID = '" & request.querystring("playerID") & "'";

Again, I'm not proficient in ASP, so I hope this is useful.

09-10-2006, 12:05 AM	#4 (permalink)
Itsacon Junior Member Join Date: Sep 2006 Location: Sector ZZ9 Plural Z Alpha Posts: 34	Re: SQL Statment Hmm, don't have experience with ASP, so don't know the syntax, but I'll try to explain what you need to do. the 'request.querystring("playerID")' sounds pretty logical to me, I assume that's the code to request the part from the querystring (GET and POST vars) that's tagged 'playerID'. Then you need to parse it into the SQL query. Again, I don't know the ASP syntax for string concatenation, but I believe it's the ampersand (&): Your current code will be something like this: Code: SQLquery = "SELECT * FROM mydatabase where playerID = 'player1'"; change it to something like this Code: SQLquery = "SELECT * FROM mydatabase where playerID = '" & request.querystring("playerID") & "'"; Again, I'm not proficient in ASP, so I hope this is useful. __________________ "The biggest problem encountered while trying to design a system that was completely foolproof, was, that people tended to underestimate the ingenuity of complete fools." ---Douglas Adams