It is strange how it works in CF 4.5 and not MX , what is it that MX
does not like??
I thought MX was supposed to be the more powerful platform !
In the debugging it seems as if there is a problem, accessing the
database from the error below ?
Exceptions
16:25:07.007 - Database Exception - in
F:\Websites\devzzz\corporate\personnel\staffno_search.cfm : line 15
Error Executing Database Query.
-----Original Message-----
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]
Sent: 04 February 2004 16:24
To: CF-Talk
Subject: RE: What could be wrong with this code ? Any expertise
on this please??
Ian,
one guess:
<cfquery name="recordset_search"
datasource=#MM_Universe_Connection_DSN#
username=#MM_Universe_Connection_USERNAME#
password=#MM_Universe_Connection_PASSWORD#>
Put quotes around the username and password and datasource:
<cfquery name="recordset_search"
datasource="#MM_Universe_Connection_DSN#"
username="#MM_Universe_Connection_USERNAME#"
password="#MM_Universe_Connection_PASSWORD#">
If there are any weird characters in them this will alleviate
that as a possibility.
-Mark
-----Original Message-----
From: Ian Vaughan [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 04, 2004 9:50 AM
To: CF-Talk
Subject: What could be wrong with this code ? Any expertise on
this please??
I am contacting you for some of your expertise please to see
what could
be causing this error ...
I have set up a connection to an IBM universe database through
Windows
Administrative Tools > ODBC Datasource Administrator, this
pings and
tests correctly.
I then set this up through the ODBC socket option in CFMX
administrator
and it verfies ok.
But when running my code in the browser I am receiving the
following
error, do you have any ideas on why I am getting this, I have
been
looking for a solution to this for months but to no avail.
When testing in CF 4.5 this worked ok, it is just since we
migrated to
MX 6.1, could it be something to do with MX ?? As I cant find
nothing
on the Macromedcia site ?
Could it be a mapping or permissions problem ???? that is
causing to the
Invalid argument value in CFMX ?
<-------- CODE SNIPPET----------------->
<cfif NOT (isDefined("SESSION.USERNAME"))>
<cflocation url=""> </cfif>
<cfparam name="FORM.P_STAFFNUMBER" default="">
<cfparam name="Search__P_STAFFNUMBER"
default="#FORM.P_STAFFNUMBER#">
<cfif #SESSION.USERNAME# eq "MCROW">
<cfquery name="recordset_search"
datasource=#MM_Universe_Connection_DSN#
username=#MM_Universe_Connection_USERNAME#
password=#MM_Universe_Connection_PASSWORD#>
select count(*) staff_valid
from SQL_PERS_DATA a
where a.EmployeeNumber = '#Search__P_STAFFNUMBER#'
and ((a.AA_Section = '#SESSION.SECTION#')
OR (a.AA_Section = 'CATERING')
OR (a.AA_Section = 'CLEANING'))
AND AA_Directorate like '%EDUCATION%'
</cfquery>
<cfelse>
<cfquery name="recordset_search"
datasource=#MM_Universe_Connection_DSN#
username=#MM_Universe_Connection_USERNAME#
password=#MM_Universe_Connection_PASSWORD#>
select count(*) staff_valid
from SQL_PERS_DATA a
where a.EmployeeNumber = '#Search__P_STAFFNUMBER#'
and a.BB_PostLocation = '#SESSION.SCHOOL#'
</cfquery>
</cfif>
<-------- END CODE SNIPPET----------------->
Error Occurred While Processing Request
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC
Socket][VMARK][UVODBC][2301524]Invalid argument value.
The error occurred in F:\staffno_search.cfm: line 15
13 : from SQL_PERS_DATA a
14 : where a.EmployeeNumber = '#Search__P_STAFFNUMBER#'
15 : and ((a.AA_Section = '#SESSION.SECTION#')
16 : OR (a.AA_Section = 'CATERING')
17 : OR (a.AA_Section = 'CLEANING'))
________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
