Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: emueth
  • Content: Threads
  • Order by date
  1. emueth

    Multi-step query question

    I need to run the following query. The code runs fine in SQL but I'm not sure what to do with it in Cold Fusion. I am using SQL 7 and CF5. The query (with hardcoded values instead of variables) is: DECLARE @emps varchar(50) SELECT @emps = COALESCE(@emps + ';', '') + e.last_name FROM...
  2. emueth

    Bit query in SQL

    I have a Cold Fusion application with a SQL 7 database. The database has an employee table with a bit field for storing certain permissions. How do I write my sql statement to, for example, return all employees that meet the criteria of a bitand on the fourth bit? Thanks in advance for the help.
  3. emueth

    SQL bit query

    I have a Cold Fusion application with a SQL 7 database. The database has an employee table with a bit field for storing certain permissions. How do I write my sql statement to, for example, return all employees that meet the criteria of a bitand on the fourth bit? Thanks in advance for the help.

Part and Inventory Search

Back
Top