Professional Web Applications Themes

Problem with cfsqltype attribute of cfprocparam - Coldfusion Database Access

I am using Microsoft SQL server 2000. The cfsqltype attribute of cfprocparam supports the following as shown below (extract from in its doentation). How about SQL server data type text,ntext,nvarchar, which of the following should we used? CF_SQL_BIGINT CF_SQL_BIT CF_SQL_BLOB CF_SQL_CHAR CF_SQL_CLOB CF_SQL_DATE CF_SQL_DECIMAL CF_SQL_DOUBLE CF_SQL_FLOAT CF_SQL_IDSTAMP CF_SQL_INTEGER CF_SQL_LONGVARCHAR CF_SQL_MONEY CF_SQL_MONEY4 CF_SQL_NUMERIC CF_SQL_REAL CF_SQL_REFCURSOR CF_SQL_SMALLINT CF_SQL_TIME CF_SQL_TIMESTAMP CF_SQL_TINYINT CF_SQL_VARCHAR...

  1. #1

    Default Problem with cfsqltype attribute of cfprocparam

    I am using Microsoft SQL server 2000. The cfsqltype attribute of cfprocparam
    supports the following as shown below (extract from in its doentation). How
    about SQL server data type text,ntext,nvarchar, which of the following should
    we used?
    CF_SQL_BIGINT
    CF_SQL_BIT
    CF_SQL_BLOB
    CF_SQL_CHAR
    CF_SQL_CLOB
    CF_SQL_DATE
    CF_SQL_DECIMAL
    CF_SQL_DOUBLE
    CF_SQL_FLOAT
    CF_SQL_IDSTAMP
    CF_SQL_INTEGER
    CF_SQL_LONGVARCHAR
    CF_SQL_MONEY
    CF_SQL_MONEY4
    CF_SQL_NUMERIC
    CF_SQL_REAL
    CF_SQL_REFCURSOR
    CF_SQL_SMALLINT
    CF_SQL_TIME
    CF_SQL_TIMESTAMP
    CF_SQL_TINYINT
    CF_SQL_VARCHAR


    steve458412 Guest

  2. #2

    Default Re: Problem with cfsqltype attribute of cfprocparam

    Use CF_SQL_LONGVARCHAR that would take big text or just CF_SQL_VARCHAR. At least you will be protected from SQL injection and maybe decrease some performance time.
    CF_Oracle Guest

  3. #3

    Default Re: Problem with cfsqltype attribute of cfprocparam

    Hi

    check the below link, this will gives you full details.


    [url]http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/[/url]
    wwhelp.htm?context=ColdFusion_Doentation&file=0 0000317.htm

    vkunirs Guest

Similar Threads

  1. CFQUERYPARAM CFSQLTYPE Datatype Sizes?
    By -=MM=- in forum Coldfusion Database Access
    Replies: 1
    Last Post: June 23rd, 06:19 PM
  2. CFProcParam - MX7
    By paross1 in forum Coldfusion Database Access
    Replies: 4
    Last Post: April 6th, 04:04 PM
  3. Invalid data error for CFSQLTYPE CF_SQL_VARBINARY
    By TrevJames in forum Coldfusion Database Access
    Replies: 0
    Last Post: July 22nd, 02:35 PM
  4. GUID and CFProcParam
    By DeliK in forum Coldfusion Database Access
    Replies: 5
    Last Post: June 23rd, 11:03 PM
  5. boolean cfsqltype
    By doramon in forum Coldfusion Database Access
    Replies: 3
    Last Post: April 8th, 01:49 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139