Perfect, that part with the getstates query is exactly what I was looking for!
We already had a table with states and abbreviations made, so it saved having
to do a 50-item cfswitch.
Thank you all so much for your help!
>Ok so basically this is a query you want to run ONE time to get the
>in
. Ltd.
www.aegeon.com.au
Phone: +613 9015 8628
Mobile: 0404 998 273
-Original Message-
From: Dave Phillips [mailto:[EMAIL PROTECTED]
Sent: Monday, 18 August 2008 11:37 PM
To: CF-Talk
Subject: RE: Creating a database with repeated information
Melissa,
This is exactly what ColdFusion is designed
But of course. Was just pointing out that it appeared she was only going
to use it once. It's up to the programmer to either code it properly or
delete it when they are through.
Dave Watts wrote:
>> It's a one time query that she's using to insert data into
>> the db initially. Unless she left
> It's a one time query that she's using to insert data into
> the db initially. Unless she left that page open for anyone
> to access no real need to secure it in that fashion. Of
> course doesn't hurt, just saying from the sounds of her post
> it will only be used ONCE, by her.
I do a lot o
ould be in your Query statement.
>>
>> Insert INTO STATES
>> Where State = '#URL.State#'
>>
>> David G. Moore, Jr.
>> UpstateWeb LLC> Subject: Re: Creating a database
>> with repeated information> From:
>> [EMAIL PROTECTED]> To: cf-talk@
tates table:
StateID
State name
State Abbreviation
At 11:11 AM 8/18/2008, you wrote:
>Melissa,
>
>This would be in your Query statement.
>
>Insert INTO STATES
>Where State = '#URL.State#'
>
>David G. Moore, Jr.
>UpstateWeb LLC> Subject: Re: Creating a databas
CTED]
Sent: Monday, August 18, 2008 10:05 AM
To: CF-Talk
Subject: Re: Creating a database with repeated information
Thanks for the welcoming answers. :) I am relatively new to ColdFusion, but
I may have misstated my question; it's not the pulling information from the
database I'm not
Ok so basically this is a query you want to run ONE time to get the
initial data set into the database? I'm assuming you'd be putting the
page "content" and "title" in later?
I would do something as basic as...
Select the states
select state, id from states
Loop through the query...
If
>hmmm... INSERT with a WHERE cause? Didn't you mean UPDATE?
OK. SO I am a litle nervous. All these big dogs of CF and I am trying to pitch
in.
Anyway. Shouldn't this be handled in the Query statement? I will let someone
else handle the specifics now that I have completely screwed it up
D
It's generally a bad idea to specify identity values into your code,
especially for ones that are auto-incrementing. If you have to move your
code to another server or even re-create your data, the identity values
could change which would force you to edit your code. You could just pass
the State
Ooopss.> Subject: Re: Creating a database with repeated information> From:
[EMAIL PROTECTED]> To: cf-talk@houseoffusion.com> Date: Mon, 18 Aug 2008
22:19:03 +0700> > hmmm... INSERT with a WHERE cause? Didn't you mean UPDATE?> >
Azadi Saryev> Sabai-d
hmmm... INSERT with a WHERE cause? Didn't you mean UPDATE?
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
David Moore, Jr. wrote:
> Melissa,
>
> This would be in your Query statement.
>
> Insert INTO STATES
> Where State = '#URL.State#'
>
> David G. Moore, Jr.
>
>
~
Melissa,
This would be in your Query statement.
Insert INTO STATES
Where State = '#URL.State#'
David G. Moore, Jr.
UpstateWeb LLC> Subject: Re: Creating a database with repeated information>
From: [EMAIL PROTECTED]> To: cf-talk@houseoffusion.com> Date: Mon, 18 Au
Thanks for the welcoming answers. :) I am relatively new to ColdFusion, but I
may have misstated my question; it's not the pulling information from the
database I'm not sure how to do, it's the setting the database up (efficiently)
in the first place.
I figure each record will need five fields:
Melissa,
I am not sure, but it sounds like you may be new to ColdFusion. If so, you have
chosen a great language for programming dynamic websites quickly and easily. If
I am wrong, please forgive me. Otherwise, I would recommend you get a book by
Ben Forta on Adobe ColdFusion. You will probably
Melissa,
This is exactly what ColdFusion is designed to do. You will have ten
separate ".cfm" files and each of the files represents one of your 10 pages.
Whatever information is 'static' for each page (in other words, whatever
information stays the same for every state) can be hardcoded into the
16 matches
Mail list logo