----- Original Message -----
Sent: Friday, December 05, 2003 10:36
AM
Subject: [cfaussie] Re: Server IP
Hi
My provider has mirgrated my site to cfmx from
4.5 and iam getting bugs.
it seems the major problems are cfif tags i have
tried coldfusion.com for info on specific changes but cant locate the answers.
i am also getting a [Macromedia][SequeLink JDBC Driver][SequeLink Server]Required
user name is missing
here is a sample of code thats falling
over
any points please
<CFQUERY name="GetRecord"
datasource="interacttalent" maxRows=1>
SELECT Talent.talentID AS
ViewField1, Talent.Name AS ViewField2, Talent.Gender AS ViewField3, Talent.DOB
AS ViewField4, Talent.Hair AS ViewField5, Talent.Eye AS ViewField6,
Talent.Height AS ViewField7, Talent.Clothessize AS ViewField8, Talent.shoesize
AS ViewField9, Talent.hobbies AS ViewField10, Talent.BIO AS ViewField11,
Talent.Compcard AS ViewField12, Talent.ID AS ID_Field
FROM
Talent
<CFIF
ParameterExists(URL.RecordID)>
WHERE Talent.ID =
#URL.RecordID#
</CFIF>
</CFQUERY>
Error
Executing Database Query. |
| [Macromedia][SequeLink JDBC Driver][SequeLink
Server]Required user name is missing. |
| |
The error occurred in
D:\WebSpace\interact\admin\DrillDown_RecordView.cfm: line
25
|
23 : <CFIF ParameterExists(URL.RecordID)>
24 : WHERE Talent.ID = #URL.RecordID#
25 : </CFIF>
26 : </CFQUERY>
27 : <CFQUERY name="allRecord" datasource="interacttalent">
|
|
| SQL |
SELECT
Talent.talentID AS ViewField1, Talent.Name AS ViewField2,
Talent.Gender AS ViewField3, Talent.DOB AS ViewField4, Talent.Hair
AS ViewField5, Talent.Eye AS ViewField6, Talent.Height AS
ViewField7, Talent.Clothessize AS ViewField8, Talent.shoesize AS
ViewField9, Talent.hobbies AS ViewField10, Talent.BIO AS
ViewField11, Talent.Compcard AS ViewField12, Talent.ID AS ID_Field
FROM Talent |
| DATASOURCE |
interacttalent | |
| Please
try the following:
|
| Browser |
Mozilla/4.0
(compatible; MSIE 6.0; Windows NT 5.0; MSOCD; .NET CLR 1.0.3705;
.NET CLR 1.1.4322) |
| Remote
Address |
203.26.24.215 |
| Referrer |
http://interacttalent.com.au/admin/DrillDown_RecordAction.cfm |
| Date/Time |
05-Dec-03
11:20 AM | |
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink Server]Required user name is missing.
at coldfusion.server.j2ee.sql.pool.JDBCPool.requestConnection(JDBCPool.java:677)
at coldfusion.server.j2ee.sql.pool.JDBCManager.requestConnection(JDBCManagerjava:123)
at coldfusion.server.j2ee.sql.JRunDataSource.getConnection(JRunDataSource.java:138)
at coldfusion.server.j2ee.sql.JRunDataSource.getConnection(JRunDataSource.java:125)
at coldfusion.sql.DataSrcImpl.getCachedConnection(DataSrcImpl.java:120)
at coldfusion.sql.DataSrcImpl.getConnection(DataSrcImpl.java:75)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:211)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:447)
at cfDrillDown_RecordView2ecfm1175012082.runPage(D:\WebSpace\interact\admin\DrillDown_RecordView.cfm:25)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:105)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192)
at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
Kind Regards
Greg Stone
Australian
Business Web
---
You are currently subscribed to cfaussie
as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
[EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon
AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
---