Replies to all included;
> here's a real silly question but is
>
> <cfset variables.IDCount=getPeopleInfo.RecordCount> written exactly like
>
> this or is it written like
>
> <cfset variables.IDCount=#getPeopleInfo.RecordCount#> leaving the # off
> could be your problem.
You are kidding, right? CF hasn't required the # within CFSET since v2
> Have you run the query in a query analyzer? If so, does it return
> results?
>
> Also, are you catching a database error and not returning anything to
> the client?
Not in Query Analyzer, but I know it does something as I've put some
debugging code around it (getTickCount()) - but it should return 0 in the
recordCount if it returns no records...
> It looks like your code has been greatly excerpted. There is no
> chance that you are setting the variable getPeopleInfo equal to
> some simple value and overwriting the query somewhere between the
> query and the loop? Is the name of the query dynamic?
>
> Sorry for the questions, but it seems very unlikely that ColdFusion
> would behave this way. Any additional information would be useful.
These 2 commands of code are exactly as I pasted them, there isn't anything
between them that could change it - I've changed the query name as well and
it still does nothing...
> I just took out the ---- and #PreserveSingleQuotes(variables.whereList)#
> --- set some variables and it worked fine for me. What's in the
> wherelist??
> It ran fine for me. cf 4.01 on Windows 2000 server.
OK, the variables.whereList contains things like "fieldName='Yes'" or
"fieldName is NULL", I need the PreserveSingleQuotes otherwise it spits when
you use apostrophies
> What about removing the "variables." scope?
I even tried putting <CFLOOP QUERY="getPeopleInfo"> and it came back saying
the query didn't exist
> Are you talking to SQL Server? I don't think it likes the table name
> "Users" Try putting square brackets around the table name, eg.
> "[Users]" and see if that helps.
>
> AND run it with debugging on to show the SQL and the result. This
> will let you know whether the SQL is actually being executed and how
> many rows it returns.
SQL Server 7, otherwise the (nolock) wouldn't work - the table name isn't
Users, that was Jeff's suggestion.
I can't put debugging on as it's a production server - I don't have the data
on my test machine to use, and the amount of data is huge to download
As I said - it's confusing the hell out of me.
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
