Changing the data command

[MikeL91]

I am tring to change the data command in inter dev durring run time rather than design time.

Thanks in advance,
Mike

 

[MikeL91]

let me redefine the question:

I went to the toolbox and droped RecordSet onto my page, then I went to the SQL bulder and created my SELECT statement:

SELECT FNAME,LNAME
FROM customers

now I only want to get the records that match a variable from Request.Form("Lastname&quot with is called strLastname. I tried:
WHERE LNAME = strLastname

If I am doing this wrong, or you can help with this code, I thanks you in advance.

Thanks
Mike

 

[wrbodine]

Hi,

You need to make sure that strLastName is outside of the quotes of the select statement:

"Select LName, FName
From Customers
Where LName = " & strLastName

Hope that helps,
ray

 

[MerlinB]

The SQL does not know about the various fields on your page. strLastName is rather meaningless to the database.

Try using parameters..

Where LName = ?

Then on the last tab of the recordset, specify the Request.Form("LastName&quot. Or you could specify the parameter value in the recordset_onbeforeopen event..

sub rsMyRecordset_onbeforeopen ()
rsMyRecordset.setParameter 0, Request.Form("LastName&quot
end sub

The benefit of using parameters is that they cope with embedded quote characters - which normally ruin SQL that is programatically constructed using strings.

http://www.websitedesign.co.uk

http://www.zentext.com

(Content Management)