Access database question: how to structure a link between two tables

have 1 or more safes that match to it, with a maximum number of 3 safes or premises. what structure should i use for the link between the two tables? sincerely, --- Hubert Earl ICQ#: 16199853 AIM: hubertfme My Jamaican Art, Craft More Online Store: http://www.angelfire.com/ny/hearl

How to make sure that 'select', 'textarea' and 'checkbox' data fields are filled from the database when performing an update?

=30 MAXLENGTH=20 VALUE=#CustPassword# /TD /TR --- /FORM /BODY /HTML /CFOUTPUT --- Hubert Earl ICQ#: 16199853 AIM: hubertfme My Jamaican Art, Craft More Online Store: http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html

Re: Problem with page showing blank

--- /CFIF!---LEVEL #1--- Hubert --- Hubert Earl ICQ#: 16199853 AIM: hubertfme My Jamaican Art, Craft More Online Store: http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html - Original Message - From: Todd Ashworth [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday

Problem with form showing blank

=reset VALUE=Clear --- /TABLE /FORM /BODY /HTML /CFOUTPUT CFELSE!---LEVEL #2--- CFLOCATION URL='GOTOLOGIN.CFM'ADDTOKEN=No /CFIF!---LEVEL #2--- /CFIF!---LEVEL #1--- hubert --- Hubert Earl ICQ#: 16199853 AIM: hubertfme My Jamaican Art, Craft More Online Store: http

Re: Problem with page showing blank

=reset VALUE=Clear --- /TABLE /FORM /BODY /HTML /CFOUTPUT CFELSE!---LEVEL #2--- CFLOCATION URL='GOTOLOGIN.CFM'ADDTOKEN=No /CFIF!---LEVEL #2--- /CFIF!---LEVEL #1--- Hubert --- Hubert Earl ICQ#: 16199853 AIM: hubertfme My Jamaican Art, Craft More Online Store: http

How to resolve help file links into web pages in Studio 4?

has occurred. HTTP/1.0 404 Object Not Found Sincerely, --- Hubert Earl ICQ#: 16199853 AIM: hubertfme My Jamaican Art, Craft More Online Store: http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html ~~ Structure your

Problem with page showing blank

should be checking for. hubert --- Hubert Earl ICQ#: 16199853 AIM: hubertfme My Jamaican Art, Craft More Online Store: http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html ~~ Structure your ColdFusion code with Fusebox. Get the official

Re: Problem with page showing blank

hi, thanks for the feedback. actually, all my comments use two dashes before and after the comment, not three. could that be the problem? hubert --- Hubert Earl ICQ#: 16199853 AIM: hubertfme My Jamaican Art, Craft More Online Store: http://www.angelfire.com/ny/hearl

What's the best way to deal with inexplicable error messages?

, since there *must* be a way to avoid the enormous frustration I often feel while coding! :-) Hubert --- Hubert Earl ICQ#: 16199853 AIM: hubertfme My Jamaican Art, Craft More Online Store: http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html

Re: Problem with login page

B. clicoapplication.cfm !---Name application--- CFAPPLICATION NAME=clicologin SESSIONMANAGEMENT=YES SESSIONTIMEOUT=#CreateTimespan(0,0,30,0)# !---Set appliction constants--- CFSET DB=Clico cfparam name=session.auth default=NO Hubert --- Hubert Earl ICQ#: 16199853 AIM: hubertfme

Re: Problem with login page

Hi, Thanks for the feedback. Please see my next email for an update on my efforts. Hubert --- Hubert Earl ICQ#: 16199853 AIM: hubertfme My Jamaican Art, Craft More Online Store: http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html - Original Message - From: Semrau, Steven

How to configure Studio to use only block capitals in the default template with edited and inserted tags?

Hi, How can I configure CFStudio so that: 1. The default template will have only block capitals? 2. All edited or inserted tags will automatically be in block capitals? Sincerely, --- Hubert Earl ICQ#: 16199853 AIM: hubertfme My Jamaican Art, Craft More Online Store: http

How to resolve help file links into web pages in Studio 4?

has occurred. HTTP/1.0 404 Object Not Found Sincerely, --- Hubert Earl ICQ#: 16199853 AIM: hubertfme My Jamaican Art, Craft More Online Store: http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html ~~ Structure your

Problem with login page

suggest what I may be overlooking? Thanks. --- Hubert Earl ICQ#: 16199853 AIM: hubertfme My Jamaican Art, Craft More Online Store: http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html ~~ Structure your ColdFusion code with Fusebox

Re: How can I get CF to ignore a form field with no data?

--- Hubert Earl ICQ#: 16199853 AIM: hubertfme My Jamaican Art, Craft More Online Store: http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html - Original Message - From: Bill Davidson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, April 28, 2001 9:07 PM Subject

Re: How can I get CF to ignore a form field with no data?

#', '#UserEmail#','#PhoneHome#') /CFQUERY /CFIF CFLOCATION URL=AdminPage.cfm It didn't matter where in the above I put the code you sent me, I still got the same message. When I changed value for default, name or type, I got other error messages. Hubert --- Hubert Earl ICQ#: 16199853 AIM: hubertfme My

Can a cflocation effect take place without a cflocation tag?

a cflocation tag either within an else or elseif clause, or elsewhere. Sincerely, --- Hubert Earl ICQ#: 16199853 AIM: hubertfme My Jamaican Art, Craft More Online Store: http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html

How can I get CF to ignore a form field with no data?

Hi, How can I get CF to ignore a form field with no data? I have a form with a field called MiddleInit which will not always be filled in. At the moment, however, an error message is generated if that field is blank. Sincerely, --- Hubert Earl ICQ#: 16199853 AIM: hubertfme My Jamaican Art

Re: Problem with Studio 4.5.2 help

---! -Original Message- From: Hubert Earl [mailto:[EMAIL PROTECTED]] Sent: Monday, April 23, 2001 7:06 PM To: CF-Talk Subject: Problem with Studio 4.5.2 help Hi, While Studio 4.5.2 was indexing its help files for the first time, as a result of a search I was trying

Where can I get a copy of Studio 4.5.1?

Hi, Where can I get a copy of Studio 4.5.1? All I'm seeing on the net are sites for Studio 4.5.2. Sincerely, --- Hubert Earl ICQ#: 16199853 AIM: hubertfme ~~ Structure your ColdFusion code with Fusebox. Get the official book at http

OT: what is the address of microsoft's news server (as in news.somethingortheother.com)?

hi, what is the address of microsoft's news server (as in news.somethingortheother.com)? i once found it on the microsoft site, but i can't find it again. thanx. sincerely, --- Hubert Earl ICQ#: 16199853 AIM: hubertfme My Jamaican Art, Craft More Online Store: http://www.angelfire.com/ny

Problem with Studio 4.5.2 help

the situation). What can I do to rectify the situation? Sincerely, --- Hubert Earl ICQ#: 16199853 AIM: hubertfme My Jamaican Art, Craft More Online Store: http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html ~~ Structure your ColdFusion

Error message in window generated by link from a web page viewed in CFStudio's editor window

Processing Request Error Diagnostic Information An error has occurred. HTTP/1.0 404 Object Not Found Can you or anyone reading this kindly advise me on this as well? Sincerely, --- Hubert Earl ICQ#: 16199853 AIM: hubertfme ~~ Structure your

Trouble with controlling decimal places in Access table currency datatype

Hi, I'm having trouble controlling the number of decimal places that is used by a column in an Access table with currency datatype. Although I set the number at 2, I keep getting 4. I'd appreciate any advice. Sincerely, --- Hubert Earl ICQ#: 16199853 AIM: hubertfme My Jamaican Art, Craft

Problem controlling decimal places in Access table currency datatype

Hi, I'm having trouble controlling the number of decimal places that is used by a column in an Access table with currency datatype. Although I set the number at 2, I keep getting 4. I'd appreciate any advice. Sincerely, --- Hubert Earl ICQ#: 16199853 AIM: hubertfme

Problem browsing web pages in the CFStudio editor window

e URL resolution for this file." What does 'server development mapping' mean, and how and to where should I add it? sincerely, --- Hubert Earl ICQ#: 16199853 AIM: hubertfme ~~ Structure your ColdFusion code with Fusebox. Get the official boo

Re: Problem browsing web pages in the CFStudio editor window

, --- Hubert Earl ICQ#: 16199853 AIM: hubertfme - Original Message - From: Christopher Olive, CIO [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, April 18, 2001 8:23 PM Subject: RE: Problem browsing web pages in the CFStudio editor window go to Debug-Development Mappings (Alt-M

Error message in window generated by a link from a web page viewed in CFStudio's editor window

Processing Request Error Diagnostic Information An error has occurred. HTTP/1.0 404 Object Not Found Can you or anyone reading this kindly advise me on this as well? Sincerely, --- Hubert Earl ICQ#: 16199853 AIM: hubertfme My Jamaican Art, Craft More Online Store: http://www.angelfire.com/ny

Problem with edit operation creating duplicate values in a Microsoft Access database

ok, that's quite a few names, but the underlying code structure is the same). What should I be considering as a possible cause of the problem? Sincerely, --- Hubert Earl ICQ#: 16199853 AIM: hubertfme My Jamaican Art, Craft More Online Store: http://www.angelfire.com/ny/hearl/link_page_on_ange

Re: Problem with edit operation creating duplicate values in a Mi crosoft Access database

Hi, Thanks for the advice. The problem eventually turned out to be that I was using cfinsert instead of the sql insert statement. Hubert --- Hubert Earl ICQ#: 16199853 AIM: hubertfme My Jamaican Art, Craft More Online Store: http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html

Showing the results of an add or edit operation

the changes made (for the delete operation, however, the change is shown). What additional code should I use so that the results of the add to and edit operations are immediately visible, and in which file should the code be put? Sincerely, --- Hubert Earl ICQ#: 16199853 AIM: hubertfme My

Problem getting CFStudio 4.5.1 resource tab to reappear

the missing section of the Studio window urgently. Sincerly, --- Hubert Earl ICQ#: 16199853 AIM: hubertfme See pictures of items in my Jamaican Art, Craft More Store Online Sale on my "Me" page on eBay (this tells you a little about myself, including a photo), and there's a link to th

Protecting an admin page

page? Sincerely, --- Hubert Earl ICQ#: 16199853 AIM: hubertfme See pictures of items in my Jamaican Art, Craft More Store Online Sale on my "Me" page on eBay (this tells you a little about myself, including a photo), and there's a link to the auctions themselves: http://members.ebay.c

Please ignore this test email

--- Hubert Earl ICQ#: 16199853 AIM: hubertfme See pictures of items in my Jamaican Art, Craft More Store Online Sale on my "Me" page on eBay (this tells you a little about myself, including a photo), and there's a link to the auctions themselves: http://members.ebay.com/aboutme/he

Problem with login code

ON URL="login.cfm" /CFIF CFELSE !---login failed - send them back to the login page--- CFSET ERRORMESSAGE="You must enter a valid password and user name to enter this site" CFLOCATION URL="login.cfm" /CFIF Sincerely, --- Hubert Earl ICQ#: 16199853 See pictures of

How to remove a server data source name from the CFStudio Remote window?

Hi, How do I remove a server data source name from the CFStudio Remote window? Hubert --- Hubert Earl ICQ#: 16199853 See pictures of items in my Jamaican Art, Craft More Store Online Sale on my "Me" page on eBay (this tells you a little about myself, including a photo), and ther

Problem with CFStudio debugger

. H:ubert --- Hubert Earl ICQ#: 16199853 See pictures of items in my Jamaican Art, Craft More Store Online Sale on my "Me" page on eBay (this tells you a little about myself, including a photo), and there's a link to the auctions themselves: http://members.ebay.com/aboutme/hearl1/ See pictu

OT: How to dock a pop-up ad?

Hi, Someone once told me of a method to 'dock' pop-ups in free hosting sites, so that the ad would appear at the bottom of my page and not in a separate pop-up window. Can anyone remind me of how to do it? Sincerely, --- Hubert Earl ICQ#: 16199853 See pictures of items in my Jamaican Art

OT: Can anyone recommend a reliable hosting service for web pages?

) and I'm looking to move to a reliable on urgently. Sincerely, --- Hubert Earl ICQ#: 16199853 See pictures of items in my Jamaican Art, Craft More Online Sale (please excuse the pop-ups--this is currently being hosted on just a temporary, emergency server: http://www.angelfire.com/ny/hearl

Re: Can anyone recommend a reliable hosting service for web pages?

Thanks. Hubert --- Hubert Earl ICQ#: 16199853 See pictures of items in my Jamaican Art, Craft More Online Sale (please excuse the pop-ups--this is currently being hosted on just a temporary, emergency server: http://www.angelfire.com/ny/hearl/eBay_links_page_on_Angelfire.htm - Original

OT: Is it to be expected that a server may be down for 24 hours once in a while?

on the Net, it is rather unsettling. However, I don't want to move if it is a situation that may normally happen on most servers from time to time. Sincerely, --- Hubert Earl ICQ#: 16199853 See pictures of items in my Jamaican Art, Craft More Online Sale: http://cfwarrior.homeip.net/hubert

Can a hypertext link be made to self-activate without being clicked on?

advantage of attaching the web page thru some = sort of hypertext link is that I only have to make changes on one web = page. What I'm looking for, therefore, is a way to code the hypertext link = that will cause it to self-activate upon the loading of each auction = listing. Sincerely, --- Hubert

OT: The Certified Internet Webmaster qualification

of having a better chance of getting web work? Sincerely, --- Hubert Earl ICQ#: 16199853 PhoneFree ID: 1841134 I develop maintain web sites internationally. I also build web applications using ColdFusion, JavaScript and CGI scripts written in Perl. I accept subcontracting work. **Personal

OT: Bordercom International

this has taken any of its courses, how informative have they been? 2. How well taught are its courses? 3. Do any organizations offer online instruction for the same qualification? Sincerely, --- Hubert Earl ICQ#: 16199853 PhoneFree ID: 1841134 I develop maintain web sites internationally. I

What does the term 'session key' mean?

hi. i'm reading about session variables and cookies, and my text says: cfid--the unique client id. part of the session key. what is the "session key"? sincerely, --- Hubert Earl ICQ#: 16199853 I develop maintain web sites internationally. I also build web applications using

Automatically transferring data from one table to another

to my first table, without having to copy and paste them (for example). I'd appreciate any suggestions. Sincerely, --- Hubert Earl ICQ#: 16199853 I develop maintain web sites internationally. I also build web applications using ColdFusion, JavaScript and CGI scripts written in Perl. I accept

Re: The CF Studio default template

Hi Fred, Thanks for your response. Best thing would be to store your default in the wizards folder then go to settings/ options f8 and tell it to use the new template. You might want the old default back one day. I can't find anything is 'settings' which allows me to start with a new

The CF Studio default template

I've modified the cf studio default template, and I'd like to replace the original with it. Where is the default template stored? Sincerely, --- Hubert Earl ICQ#: 16199853 I develop maintain web sites internationally. I also build web applications using ColdFusion, JavaScript and CGI

Comparison of Website and Personal Web Server (for anyone with experience with both)

of dealing with all these problemss with website, which is why i'm shifting to pws. however, just to make sure i'm not jumping from the frying pan to the fire, have you been satisfied with your experience with pws? do you think it is overall a better server than website? sincerely, --- Hubert Earl ICQ

Comparison of Website and Personal Web Server (for anyone with experience with both)

of dealing with all these problemss with website, which is why i'm shifting to pws. however, just to make sure i'm not jumping from the frying pan to the fire, have you been satisfied with your experience with pws? do you think it is overall a better server than website? sincerely, --- Hubert Earl

The cf-talk@dowdell.com mailing list

Hi, Does anyone know what has happened to the [EMAIL PROTECTED] mailing list? I haven't received anything from it in a long time. Sincerely, --- Hubert Earl ICQ#: 16199853 I develop maintain web sites internationally. I also build web applications using CGI scripts written in Perl. I

Problem controlling output

-- -- The form action template: CFQUERY DATASOURCE="Jokes" NAME="JokeData" SELECT Joke FROM WordJokes WHERE JokeTitle=JokeTitle /CFQUERY !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTML H

this is a test--please ignore

This is a test--please ignore --- Hubert Earl ICQ#: 16199853 I develop maintain web sites internationally. I also build web applications using CGI scripts written in Perl. I accept subcontracting work. **Personal web site: http://www.geocities.com/SiliconValley/Peaks/8702/ (please remember

CFQUERY problem

m" METHOD="POST" Please select the joke titles from the contents of the select boxes below. You may select up to five titles at a time. Joke title #1: SELECT NAME="JokeTitle" OPTION CFOUTPUT QUERY="Titles" OPTION VALUE="#JokeTitle#"#Titles# /cfoutput

CFQUERY problem (sorry if you've got this before--I'm having mailing problems)

m" METHOD="POST" Please select the joke titles from the contents of the select boxes below. You may select up to five titles at a time. Joke title #1: SELECT NAME="JokeTitle" OPTION CFOUTPUT QUERY="Titles" OPTION VALUE="#JokeTitle#"#Titles# /cfoutput /

test--please ignore

test --- Hubert Earl ICQ#: 16199853 I develop maintain web sites internationally. I also build web applications using CGI scripts written in Perl. I accept subcontracting work. **Personal web site: http://www.geocities.com/SiliconValley/Peaks/8702/ (please remember to view

Re: Problem controlling output

/cfloop /BODY /HTML Hope this works for you. Good luck! dBIII+ -Original Message- From: Hubert Earl [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 25, 2000 2:18 AM To: [EMAIL PROTECTED] Subject: Problem controlling output Hi, I'm having a problem controlling the output of a for

Re: Problem controlling output

Thanks, Birgit, for the code. Unfortunately, I was unable to change my form fields in a way to make your code work. Please give me an example. Thanks. Hubert - Original Message - From: Birgit Pauli-Haack [EMAIL PROTECTED] To: Hubert Earl [EMAIL PROTECTED] Sent: Tuesday, April 25, 2000

The cf-talk@dowdell.com mailing list

Hi, Does anyone know what has happened to the [EMAIL PROTECTED] mailing list? I haven't received anything from it in a long time. Sincerely, --- Hubert Earl ICQ#: 16199853 I develop maintain web sites internationally. I also build web applications using CGI scripts written in Perl. I

A CF Studio question

Hi, How can I configure cf studio so that when it autocompletes tags, it does so using uppercase letters? Sincerely, --- Hubert Earl ICQ#: 16199853 I develop maintain web sites internationally. I also build web applications using CGI scripts written in Perl. I accept subcontracting work

Please ignore this message. It is a test

Please ignore this message. It is a test to see if my isp is allowing me to post to the list. --- Hubert Earl ICQ#: 16199853 I develop maintain web sites internationally. I also build web applications using CGI scripts written in Perl. I accept subcontracting work. **Personal web site

Sorry, folks, this is another test message to be ignored (but you can view the contents for an explanation)

. Thanks for your understanding. Sincerely, --- Hubert Earl ICQ#: 16199853 I develop maintain web sites internationally. I also build web applications using CGI scripts written in Perl. I accept subcontracting work. **Personal web site: http://www.geocities.com/SiliconValley/Peaks/8702

This is a test. Please ignore it.

I'm testing to see if my isp is allowing me to send mail to the list. --- Hubert Earl ICQ#: 16199853 I develop maintain web sites internationally. I also build web applications using CGI scripts written in Perl. I accept subcontracting work. **Personal web site: http://www.geocities.com

Re: Auto Reply to your message ...

ok - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, April 15, 2000 3:01 PM Subject: Auto Reply to your message ... This is a MIME-encapsulated message --=38F7D2960123/server0.sys-con.com - The following text is an automated

Problem populating certain fields thru update template

tion)#" /TEXTAREA 2. SELECT NAME=3D"make"option = value=3D"Make"OPTIONNissanOPTIONFiat/SELECT Please advise me what changes to make. Thanks. Sincerely, --- Hubert Earl ICQ#: 16199853 I develop maintain web sites internationally. I also build web = applicati

Missing primary key error message

ate template appears to be normal, and had worked prior to = some changes I made to the update form. Could it be possible that = changes to display tags on the update form could affect the functioning = of the update template? I'm quite puzzled, and I'd appreciate some = advice. Sincerely,

Extraneous end tag error message

" CFOUTPUTOPTION value=3D"#ModelYear#"#ModelYear#/CFOUTPUT /CFLOOP =20 /CFOUTPUT /select blah, blah /CFFORM /CFOUTPUT Despite what the error message says, there's only one /CFFORM tag in = the template. Is it possible that the first /cfoutput also closes off = cfform? =20

Extraneous end tag error message--corrected version of message

one /CFFORM tag in = the template. Is it possible that the first /cfoutput also closes off = cfform? =20 Sincerely, --- Hubert Earl ICQ#: 16199853 I develop maintain web sites internationally. I also build web = applications using CGI scripts written in Perl. I accept subcontracting = work

Re: Extraneous end tag error message

Hi Jordon, Thanks for the response. Had the same issue mising CFFORM with standard HTML form elements. Either use just the FORM tag, This results in the following error message: "Tag context validation error The tag CFINPUT must be nested inside a CFFORM tag. The ancestor CFFORM tag must

Question concerning select box code

. populate the box with the value already chosen or b. allow the user to either=20 1. choose the other value(s) in the box or=20 2. enter a value not already there (if possible)? sincerely, --- Hubert Earl ICQ#: 16199853 I develop maintain web sites internationally. I also build web = ap

Question concerning select box code

. populate the box with the value already chosen or b. allow the user to either=20 1. choose the other value(s) in the box or=20 2. enter a value not already there (if possible)? =20 sincerely, --- Hubert Earl ICQ#: 16199853 I develop maintain web sites internationally. I also

Question concerning select boxes

ode to:=20 a. populate the box with the value already chosen b. allow the user to either=20 1. choose the other value in the box or=20 2. enter a value not already there? the code: SELECT = NAME=3D"Make"OPTIONOPTIONNissanOPTIONFiat/SELECT sincerely, --- Hubert Earl ICQ#: 16199853 I d

Question concerning select boxes

ode to:=20 a. populate the box with the value already chosen b. allow the user to either=20 1. choose the other value in the box or=20 2. enter a value not already there? the code: SELECT = NAME=3D"Make"OPTIONOPTIONNissanOPTIONFiat/SELECT sincerely, --- Hubert Earl ICQ#: 16199853 I d

How to dynamically create a link to an update form

g the data entered into the form. The email = must also contain a link back to the form in case the user wants to = modify any of the data he/she had entered. How can I code that link in = such a way as it will generate the data update form filled with the = appropriate data? Sincerely, --- Huber

Re: Advice requested on building an admin page

This is a multi-part message in MIME format. --=_NextPart_000_00A0_01BF9762.69BAC420 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable thanks very much. hubert --- Hubert Earl ICQ#: 16199853 I develop maintain web sites inter