Webmaster Forum / ColdFusion / Database Access / November 2004

I have a form where a user can enter someone's first, last, or organization
name to see if they are in the database. The way it works right now is if you
leave all the fields blank, it pulls all the records. If you only enter one
field it only searches on that field. I want to ...

I am getting a 'LDAP Connection Failed' error after migrating my web
application to another server.  The code I have worked on my development and
staging server, but decided to die on me on the production server.  My
co-worker is using LDAP as well (same code) on a separate web ...

We recently upgraded to CFMX and migrated our code. One of the pages (which
didn't require any code change), uses a select statement to pull data for a
particular id from a DB.
The query works for some values of this ID, but not for others.

I have a wired thing happening to my tables in SQL. I have some tables that I
work on locally with the owner is dbo. When I use the export wizard to move the
same tables to the remote DB with the username: gife, it recreates the same
tables with the owner gife and the website ...

I am trying to set up a datasource for SQL. on a PC running windows XP.  I had
been using acess but need a more robust database, so I installed the personal
edition of SQL 2000. When I try to set up the datasource in ColdFusion MX I get
a '...Login failed for user 'sa'. Reason: ...

table with fields s1 throught s40 each field single integer 1-6 need to get AVG
of each field of all rows that field  Tried:    <cfquery name='gtavg'
datasource='bcomp97' dbtype='ODBC'>      SELECT  AVG(s*)      FROM surv1    
</cfquery>  and    <cfquery name='gtavg' ...

I am considering buying a new G5 and doing web development on it. But I am
wondering how I would be able to access my SQL Server databases on my
Windows servers like I do with Enterprise Manager on my XP workstation.

Hi  My table is called classified.  So i want to be able to delete all ads
posted by a user by a single click.  if i do   <cfquery name='Deletemember'  
datasource='digiouiz-data'>     DELETE FROM musiciansnetwork_users WHERE UserID
= #url.Id#     </cfquery>   it's giving me an ...

I'm doing an online booking system for B&B accomdation.
Originally they just had a start date and end date for which days of the year
they are open.
They now want to incorporate extra dates they may be open or closed - i.e.

I have a custom tag that processes query results from a query object that is
received as parameter.
I need to browse through each rows (easy part) and then through each column to
format the data and present it in a table.

Does anyone know if it's possible to connect to a database using CF 5 or
CFMX that has ODBC drivers for Windows, but not CF specifically?
I have a project that the client uses a database called Advanced DB Master
from Macon Systems. There are Windows ODBC drivers but nothing for CF. ...

I am new to CF, sorry for the newbie question. What database types work with CF other than SQL?
TIA

Hey guys,  I'm having a problem with query results using the SQL SUM function.
I'm using an MS Access DB (JetSQL) and CFMX 6.1.  Basically Im running a query
to total up the number of calls our helpdesk has recieved for given shifts
during the day. I'm using SUM in the query to ...

i am having a problem w/ an SQL statement using an Access database.  the
query is:
 <cfquery name="getVel" datasource="BallisticsDb">
  SELECT GREATER(Velocity) AS VelocityHold, Space_Covered

Hi,   I have a problem with a select statements , I wont to search my date for
records between to variable dates , I used the following statements :   SELECT
* FROM table WHERE recrord_Date > '#FORM.Date1#' AND  recrord_Date >
'#FORM.Date2#'    All the time I got error : Data ...