I'm glad I could help, but you'll still need a superuser account,
whomever is coding for you is going to need to add a flag to the database,
and write code to check for the superuser flag..
sas
kevin pieto wrote:
>> We moved our site over to a new hosting company (godaddy) and are now
>> receiv
> We moved our site over to a new hosting company (godaddy) and are now
> receiving an error on admin login. It worked fine with the previous
> host be now has an error with godaddy. Any suggestions?
>
> error shown here
>
> http://www.frontierstravel.com/pic10.jpg
Worked
Thanks so much!
SELECT *
FROM [user]
WHERE uname = AND
pword=
and...
you now need to remove this line, because you've exposed your master password
to the internet
if (session.user.uname eq "ben" OR session.user.uname eq "jgray4567") {
session.masteradmin = "Y
> We moved our site over to a new hosting company (godaddy) and are now
> receiving an error on admin login. It worked fine with the previous
> host be now has an error with godaddy. Any suggestions?
>
> error shown here
>
> http://www.frontierstravel.com/pic10.jpg
Thanks for the help, how
Hmm, so it is. Please disregard the MySQL link I posted then. For some
reason I was thinking it was MySQL.
~Brad
- Original Message -
From: "Scott Stewart" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Monday, August 18, 2008 10:13 AM
Subject: Re: syntax error
One more thing... I'm going to assume, since the error references the
Microsoft Jet Engine, that this an Access DB..
You can enclose user in square brackets ie: [user], and that will get
you around any reserved work issue.
You really want to use cfqueryparams with this.Especially with the rash
;Greg Morphis" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Monday, August 18, 2008 9:33 AM
Subject: Re: syntax error in from clause on godaddy hosting
>
~|
Adobe® ColdFusion® 8 software 8 is the most important
Probably not a good idea to post your DSN on a shared hosting box..
The query looks good... I think USER is a reserved word in queries..
but I don't know why it would have worked and then not..
On Mon, Aug 18, 2008 at 8:45 AM, kevin pieto <[EMAIL PROTECTED]> wrote:
> We moved our site over to a n
judging by the picture, it *looks* like you're missing single quotes on
the variables,
replace with (no quotes around )
kevin pieto wrote:
> We moved our site over to a new hosting company (godaddy) and are now
> receiving an error on admin login. It worked fine with the previous host be
> n
We moved our site over to a new hosting company (godaddy) and are now receiving
an error on admin login. It worked fine with the previous host be now has an
error with godaddy. Any suggestions?
error shown here
http://www.frontierstravel.com/pic10.jpg
~~
It worked!! Thank you so much. I have lots to learn as a newbie.
>in most databases that i'm aware of, month() is a built in function
>and as such is a reserved word.
>
>as such, it really shouldn't have worked in CFMX 6. be glad it worked
>for as long as it did :)
>
>if you can't change the co
sheldon turchin wrote:
> Installed CF7 and get error but do not get the error in CF6.
>
>
>SELECT Month
>FROM Month
>WHERE MonthID = #GetStatRecords.MonthID#
>
>
> Is Month reserved and cannont be used in CF7?
CF would not see that as a reserved word in that context, but the DB
in most databases that i'm aware of, month() is a built in function
and as such is a reserved word.
as such, it really shouldn't have worked in CFMX 6. be glad it worked
for as long as it did :)
if you can't change the column name, enclose it in square brackets:
SELECT [Month]
FROM [Month]
WHER
According to Live Docs it is:
http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentation&file=0189.htm
On 4/5/07, sheldon turchin <[EMAIL PROTECTED]> wrote:
>
> Installed CF7 and get error but do not get the error in CF6.
>
>
>S
Installed CF7 and get error but do not get the error in CF6.
SELECT Month
FROM Month
WHERE MonthID = #GetStatRecords.MonthID#
Is Month reserved and cannont be used in CF7?
~|
Macromedia ColdFusion MX7
Upgrade to MX
15 matches
Mail list logo