I am aware that you cannot specify datatypes in VBScript for ASP's like you do in regular VB.
Dispite this I want to pass variables, specified by the user in a textbox to an SQL query string that are of type 'datetime' and 'money'
Printable View
I am aware that you cannot specify datatypes in VBScript for ASP's like you do in regular VB.
Dispite this I want to pass variables, specified by the user in a textbox to an SQL query string that are of type 'datetime' and 'money'
You don't need to have the exact data types to have them properly inserted into a string. They are going into a string anyways, so you just need to make sure that their format is correct.
Look into using CDate and FormatCurrency/FormatNumber (all VBScript functions) when you are appending these variables to your SQL query string.