I would drop the DSN, compact & repair the database access (even as a new
file), then recreate the DSN.
-----Original Message-----
From: Tony Hicks [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 11, 2000 2:49 PM
To: CF-Server
Subject: Re: A very Irritating Database
I'm using CF 45 trial version... Windows 98 SE, Microsoft Access... 32 mb
ram 166 pentium...
Let me point out that this is not a real server... i just use it for
development so it doesn't even try to handle a server load...
The table "members" serves two purposes... login purpose and profile
purpose... the login is encrypted and it works fine now... every other
field of data works great...
It just refuses to read the email... it'll read every other field of
data....
Thanks,
Tony Hicks
Professionally Designed Websites
http://www.righteousdesigns.com
ICQ: 5874143 AIM: Webmigit Y!: Webmigit
mailto:[EMAIL PROTECTED]
Tired of your web host?
http://www.nextmill.net
Need a Domain? Don't have a credit card?
http://www.domainsbycheck.com
Got your Free Online Business Card Yet?
Here's mine: http://thecardfile.com/webmigit.htm
----- Original Message -----
From: "Gram, Jim" <[EMAIL PROTECTED]>
To: "CF-Server" <[EMAIL PROTECTED]>
Sent: Monday, December 11, 2000 1:39 PM
Subject: RE: A very Irritating Database
> Let's see your table description and the query you're running against it.
> Also anything else you can think of (DB type, O/S, all that jazz).
>
> Jim Gram
>
> -----Original Message-----
> From: Tony Hicks [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 11, 2000 2:26 PM
> To: CF-Server
> Subject: A very Irritating Database
>
>
> Ok... sometimes you can check, recheck, and still check cf code for errors
> and not see it... so I restored from backups... and typed everything
again,
> and it errors like mad.... the same error...
>
> If inside the the cfoutput tag i put #name# it calls the name field at the
> row i specify and outputs correctly but if i put #email# its blank...
> completely blank... totally irritatingly blank... and i just tried
removing
> the name field and re-inserting it and re-adding the data and it works
> correctly... so what could be the problem... anyone know? anyone at all?
and
> yes ive tried restarting various programs, restarting the computer, and
> everything to no avail... OUCH...
>
> OH YEAH... thanks to everyone who has given me feedback on this list...
>
> Thanks,
> Tony Hicks
> Professionally Designed Websites
> http://www.righteousdesigns.com
> ICQ: 5874143 AIM: Webmigit Y!: Webmigit
> mailto:[EMAIL PROTECTED]
> Tired of your web host?
> http://www.nextmill.net
> Need a Domain? Don't have a credit card?
> http://www.domainsbycheck.com
> Got your Free Online Business Card Yet?
> Here's mine: http://thecardfile.com/webmigit.htm
> ----- Original Message -----
> From: "William J. Riley" <[EMAIL PROTECTED]>
> To: "CF-Server" <[EMAIL PROTECTED]>
> Sent: Monday, December 11, 2000 12:41 PM
> Subject: RE: Irritating Database
>
>
> >
> > There are 2 very easy things you can do to debug your app. 99.9% chance
> this
> > is a coding issue on your side.
> >
> > 1)Copy you whole query and place it in a cfoutput to check the values of
> the
> > parameters as in..
> > <CFOUTPUT>
> > update Members
> > set
> >
>
Name='#form.Name#',Location='#form.Location#',Age='#form.Age#',Gender='#form
> >
>
.......Gender#',Interests='#form.Interests#',MyHomepage='#form.MyHomepage#',M
y
U
> R
> L
> > =
> > '#form.myurl#',eadd='#form.eadd#'
> > where ID=#ID#
> > </CFOUTPUT>
> >
> > 2) Use a <CFUPDATE> tag in place of your SQL update, if this works it is
> > clear sign there is a problem with the query.
> > if it fails then the problems is when the form.eadd being set before the
> > update.
> >
> > Regards,
> > William J. Riley
> > Administrator
> > Atlantic Computer Systems & Services
> > Edge Web Hosting
> > Phone:(410) 363-4626
> > Fax:(410) 363-8526
> > [EMAIL PROTECTED]
> > http://www.edgewebhosting.net
> >
> >
> >
> >
> > -----Original Message-----
> > From: Tony Hicks [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, December 11, 2000 1:17 PM
> > To: CF-Server
> > Subject: Irritating Database
> >
> >
> > I was looking at my database yesterday and realized I didn't have an
email
> > column.... so I added it... I added the cfparam where necessary and I
> added
> > the email='#email#' where necessary... That didn't work... it told me
> wrong
> > number of parameters... no matter what i did, it told me that.... so I
> took
> > the line out and the thing worked so I put it back in and it didn't work
> > again.. I tried retyping it... that didn't help... what I don't
understand
> > is that I tried renaming the column and everything but its having a
major
> > problem... it won't recognize the email address column.... the edit
> profile
> > page calls it from the db and that does not work! It will let me enter
> data
> > manually but thats it... it occurred to me that this is the first column
> ive
> > added since i made the datasource so i deleted the datasource and
rebuilt
> > it.....
> >
> > HELP! Here's the query...
> > -------------------
> > <cfquery name=updateprofiles datasource=Community>
> > update Members
> > set
> >
>
Name='#form.Name#',Location='#form.Location#',Age='#form.Age#',Gender='#form
> >
>
.......Gender#',Interests='#form.Interests#',MyHomepage='#form.MyHomepage#',M
y
U
> R
> L
> > =
> > '#form.myurl#',eadd='#form.eadd#'
> > where ID=#ID#
> > </cfquery>
> >
> > Your revisions have been accepted!
> > ---------------------
> >
> > You might notice it says Name='#form.name#'... I've tried it
Name='#Name#'
> > and it works just fine but nothing will make it work on the eadd
field...
> >
> > CAN ANYONE HELP?
> >
> > I'm thinking its just got to be a bug in CF 45?
> >
> > Thanks,
> > Tony Hicks
> > Professionally Designed Websites
> > http://www.righteousdesigns.com
> > ICQ: 5874143 AIM: Webmigit Y!: Webmigit
> > mailto:[EMAIL PROTECTED]
> > Tired of your web host?
> > http://www.nextmill.net
> > Need a Domain? Don't have a credit card?
> > http://www.domainsbycheck.com
> > Got your Free Online Business Card Yet?
> > Here's mine: http://thecardfile.com/webmigit.htm
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
