Results 1 to 2 of 2

Thread: ASP Datatypes

  1. #1

    Thread Starter
    New Member
    Join Date
    Aug 2000
    Posts
    4

    Angry

    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'

  2. #2
    Guru Clunietp's Avatar
    Join Date
    Oct 1999
    Location
    USA
    Posts
    1,844
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width