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]
