PDA

Click to See Complete Forum and Search --> : ASP Datatypes


GingerNinja
Aug 29th, 2000, 10:37 AM
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'

Clunietp
Aug 29th, 2000, 10:43 AM
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.