The lesson learned was never ever trust the recent files list in Access...
see if two files have the same name it overwrites the shortcut on the recent
file list... so like if you open one out of a zip archive it overwrites the
others... so what was
the shortcut to c:\websites\projects\community\db.mdb
was replaced with a shortcut to c:\windows\temp\db.mdb...
and all the shortcut said was c:\.....\db.mdb...
Yuck, I feel stupid...
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 2:45 PM
Subject: RE: It works
> Great...Pray tell, what was the "lesson learned?"
>
> -----Original Message-----
> From: Tony Hicks [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 11, 2000 3:28 PM
> To: CF-Server
> Subject: It works
>
>
> Ok.... Everyone it works just fine...
>
> Can I ask another question... I have a textarea or two and is there a way
to
> make it so that if it says
>
> "Tony Hicks
> Righteous Designs"
>
> then I can put #signature# somewhere on the page and it will output it
that
> way... so the source would have to say
>
> "Tony Hicks<br>
> Righteous Designs"?
>
> And also I'd like to ask if any of you mind your names being included in a
> special thanks to file?
>
> 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: "Bruce Heerssen" <[EMAIL PROTECTED]>
> To: "CF-Server" <[EMAIL PROTECTED]>
> Sent: Monday, December 11, 2000 2:18 PM
> Subject: RE: A very Irritating Database
>
>
> > Tony, maybe this will help.
> >
> > Run the following code:
> >
> > <cfquery name=updateprofiles datasource=Community>
> > select * from Members
> > </cfquery>
> > <cfoutput>#test.columnlist#</cfoutput>
> >
> > if the email column does not appear then the field is not in the
database.
> > Verify that the datasource is pointing to the correct file and that you
> are
> > updating the correct database. If it does appear then the problem does
not
> lie
> > in the database. In that case, have yet another look at your code.
> >
> > hth
> >
> > - Bruce
> >
> > P.S. While I was writing this, Claudio Betancourt replied with a good
idea
> > (compacting and repairing the database). If the above does not work, try
> that.
> >
> >
> > <tip type="coldfusion" author="Bruce Heerssen">
> > If you need a quick list of all the columns in a query, ColdFusion makes
> it easy
> > for you by providing a variable, called columnlist, that you can
reference
> in
> > your cfoutputs. Just call it like so:
> > "<cfoutput>#queryName.columnlist#</cfoutput>", and CF will output a
> > comma-delimited list of all the columns returned by the query.
> > </tip>
> >
> > > -----Original Message-----
> > > From: Tony Hicks [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, December 11, 2000 1: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
