Professional Web Applications Themes

dynamic sql statement with cfqueryparam - Coldfusion Database Access

I am trying to dynamically build a SQL statement (the ENTIRE statement) and palce it into a variables.sqlString to be run later via <cfquery name="foo" datasource="myDS"> #variables.sqlString# </cfquery> The issue I'm dealing with is I am trying to use CFQUERYPARAM as part of the sql statement (which get put into a string). I wasn't sure if I'd be able to put a cfqueryparam into a SQL statement to run later, and it looks like I might be right. Has anyone been able to do this? Here's a small clip of how how I am building the SQL: sqlStatement = sqlStatement ...

  1. #1

    Default dynamic sql statement with cfqueryparam

    I am trying to dynamically build a SQL statement (the ENTIRE statement) and
    palce it into a variables.sqlString to be run later via

    <cfquery name="foo" datasource="myDS">
    #variables.sqlString#
    </cfquery>

    The issue I'm dealing with is I am trying to use CFQUERYPARAM as part of the
    sql statement (which get put into a string). I wasn't sure if I'd be able to
    put a cfqueryparam into a SQL statement to run later, and it looks like I might
    be right. Has anyone been able to do this?

    Here's a small clip of how how I am building the SQL:

    sqlStatement = sqlStatement & ') VALUES (<cfqueryparam
    cfsqltype="cf_sql_integer" value="#variables.keyID#">, <cfqueryparam
    cfsqltype="cf_sql_varchar" value="#currentLocale#">, ';

    etc.

    CF_Greg Guest

  2. #2

    Default Re: dynamic sql statement with cfqueryparam

    The first occurrence of cfqueryparam will begin with ), unless you are taking
    care of that special case. And even though your example does not contain a
    single quote, it would be a good idea to
    #PreserveSingleQuotes(variables.sqlString)#

    BTW, what error message are you getting?

    jdeline Guest

Similar Threads

  1. Error With CFQUERYPARAM
    By csecord in forum Coldfusion - Advanced Techniques
    Replies: 6
    Last Post: July 23rd, 10:48 PM
  2. cfqueryparam
    By SupDave in forum Coldfusion - Getting Started
    Replies: 1
    Last Post: June 14th, 01:15 AM
  3. sql in operator with cfqueryPARAM
    By laurus1 in forum Coldfusion - Advanced Techniques
    Replies: 5
    Last Post: April 29th, 03:40 PM
  4. cfqueryparam question
    By Latino in forum Macromedia ColdFusion
    Replies: 3
    Last Post: March 16th, 02:29 AM
  5. cfqueryPARAM problem
    By man jackals in forum Macromedia ColdFusion
    Replies: 1
    Last Post: February 27th, 07:54 PM

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