Generally the syntax is
Select fieldlist FROM server.database.user.table
If administrator is not a table then this aint gonna work
-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]]
Sent: 20 June 2002 16:13
To: CF-Talk
Subject: problem with FB 3.0
Greetings,
I'm using
appologies - realised my last post isn't going to help much after reading
your calling code - will have a rethink
-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]]
Sent: 20 June 2002 16:13
To: CF-Talk
Subject: problem with FB 3.0
Greetings,
I'm using FUSEBOX 3.0,
The username and password you are supplying most likely can't see DBO
tables...
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
John,
I work with FB3 and I'm pretty certain it's not an error with it.
I'm guessing it's a SQL error. There seems to be a discrepancy in your calling code
however with the Query generating an error.
Error Code SQL:
SELECT USERNAME,PASSWORD
FROM DBO.administrator
WHERE USERNAME = 'asd' AND
Personally I wouldn't be too quick to jump on the idea that this is an FB
problem ( don't get me wrong, I'm not an FB advocate or anything ) ... I
suppose it could be, but it wouldn't be the way I would hedge my bets. Is
this a recently coppied / duplicated app?
I'd check the CF Admin and make
This is a problem with your query in act_login. Since you're referencing
the owner of the table as DBO, you need to have the datasource setup to use
the SA account. I would suggest changing the ownership of your tables to a
custom user account and use that instead of the sa account.
-Justin
The username and password you are supplying most likely can't see DBO
tables...
+---+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
7 matches
Mail list logo