Professional Web Applications Themes

How you convert this cfquery to TSQL? - Coldfusion - Advanced Techniques

Does anyone know how to convert this cfquery to TSQL? <cfquery name="test" datasource="abcinc"> select * from profiles where 0=0 <cfif isdefined('form.firstname') and form.firstname neq ''>and firstname='form.firstname'</cfif> </cfquery> I'm having a tuff time creating the condition in the WHERE part to check if the variable form.firstname exists first, and then to make sure its not null. I'm trying to build a search form and then have the search criteria queried in a MS SQL Server stored procedure directly for the sake of speed. Appreciate any help:) Roofus....

  1. #1

    Default How you convert this cfquery to TSQL?

    Does anyone know how to convert this cfquery to TSQL?

    <cfquery name="test" datasource="abcinc">
    select *
    from profiles
    where 0=0
    <cfif isdefined('form.firstname') and form.firstname neq ''>and
    firstname='form.firstname'</cfif>
    </cfquery>

    I'm having a tuff time creating the condition in the WHERE part to check if
    the variable form.firstname exists first, and then to make sure its not null.
    I'm trying to build a search form and then have the search criteria queried in
    a MS SQL Server stored procedure directly for the sake of speed.

    Appreciate any help:)

    Roofus.

    roofusthedoofus Guest

  2. #2

    Default Re: How you convert this cfquery to TSQL?

    Looks like you just need the pound signs to make it translate in the SQL query:
    <cfquery name='test' datasource='abcinc'> select * from profiles where 0=0
    <cfif isdefined('form.firstname') and form.firstname neq ''>and
    firstname='#form.firstname#'</cfif> </cfquery>

    Pat D. Guest

Similar Threads

  1. Converting cfquery to TSQL stored procedure
    By roofusthedoofus in forum Coldfusion - Advanced Techniques
    Replies: 1
    Last Post: February 24th, 03:02 AM
  2. How u convert this cfquery to TSQL?
    By roofusthedoofus in forum Coldfusion Database Access
    Replies: 2
    Last Post: February 22nd, 09:13 PM
  3. Is it possible to do this using TSQL instead of cursor ??
    By Ricky in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 7th, 05:50 PM
  4. IIF/Format equivalent in TSQL
    By andi in forum Microsoft SQL / MS SQL Server
    Replies: 5
    Last Post: July 1st, 05:11 PM
  5. Please improve this TSQL algorithm ..
    By Krist Lioe in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: June 30th, 08:18 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