Query String

By Alex Hedley 12 years ago

Query String

In this ASP tutorial, I'm going to show you how to handle parameters passed from a Query String.

'CORRECT WAY - Parameterized Query with dynamic sql '-------------------------------------------------- strSQL = "SELECT * FROM users WHERE username=? AND password=?" Dim cmd1 Set cmd1 = Server.CreateObject("ADODB.Command") cmd1.ActiveConnection = cnnLogin cmd1.CommandText = strSQL cmd1.CommandType = adCmdText cmd1.Parameters(0) = Request.Form("login") cmd1.Parameters(1) = Request.Form("password") Set rstLogin = cmd1.Execute()

'BAD WAY WITH CONCATENTATION DON'T DO IT!!! '------------------------------------------ strSQL = "SELECT * FROM users WHERE username='" & Request.Form("login") & _ "' AND password='" & Request.Form("password") & "';" Set rstLogin = cnnLogin.Execute(strSQL)

What if you want a LIKE clause in your Query?

SELECT * FROM tblX WHERE Field LIKE '%' & Name & '%'

Tried this but it didn't work.

SELECT * FROM tblX WHERE Field LIKE '%?%'

Include ADOVBS.inc in your page to use the Constants.

'Set parameter = command.CreateParameter (Name, Type, Direction, Size, Value) 'cmd1.Parameters.Append(cmd1.CreateParameter("Name", 200, 1, 512, name)) cmd1.Parameters.Append(cmd1.CreateParameter("Name", 200, 1, 512, "%" & name & "%"))

Or you could wrap it before you assign:

cmd1.Parameters(0) = name

cmd1.Parameters(0) = "%" & name & "%"

Pre-Requisite

FREE ASP 101: https://599cd.com/ASP101

Members

No members extras today

Recommended Courses

ASP 102: https://599cd.com/ASP102L

Details

In this tutorial, you will learn how to create a function called FancyText that takes a string and makes one character in that string black for aesthetic reasons. I will then demonstrate how I used Bard from Google and ChatGPT to create a function that darkens the color slightly instead of making it black. You will see that ChatGPT's function worked better, and I will walk you through the code. This tutorial is for VBScript and classic ASP.

Learn More

FREE Access Beginner Level 1
FREE Access Quick Start in 30 Minutes
Access Level 2 for just $1

Free Templates

TechHelp Free Templates
Blank Template
Contact Management
Order Entry & Invoicing
More Access Templates

Resources

Diamond Sponsors - Information on our Sponsors
Mailing List - Get emails when new videos released
Consulting - Need help with your database
Tip Jar - Your tips are graciously accepted
Merch Store - Get your swag here!

Questions?

Please feel free to post your questions or comments below or post them in the Forums.

Keywords

#asp, #classicasp, #help, #howto, #tutorial, #learn, #lesson, #training, #webdesign, #VBScript, classic ASP, function creation, FancyText, string manipulation, character colorization, Bard from Google, ChatGPT, color adjustment, course page design

Legacy

Query String

Subscribe to Query String
Get notifications when this page is updated