Re: HTML problem
If images are designed at one size and displayed at another, chances are that something's going to look funny. What I've done and heard recommended is to cushion the edge(s) with table cells filled with background color or a solid color image (depends on which browsers you need to support). Leave your actual images all their intended sizes, but resize the last (and first, if you like) columns. Fill these resizable columns with solid color. Wendy Peck discusses this in one of her columns. She calls it "liquid design" - see http://www.webreference.com/graphics/column43/5.html. Heather ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Query join problem
This will get you the email addresses for exact matches (zapSearch = body) for one advert_details record. This should at least help get you started. SELECT zapEmail FROMzap z WHERE zapSearch IN (SELECT body FROMadvert_details WHERE advertID = @LastAdverAddedID) --- W Luke [EMAIL PROTECTED] wrote: Hi, Not sure what I need to do for this - hope someone can help. After someone posts an advert, it's entered into the database table advert_details. A table called zap contains 2 fields, zapSearch and zapEmail, with zapSearch being a search string. After posting the advert, I need to run through zapSearch to search for the text in the just-posted advert. If it finds anything, send an email to zapEmail. I just can't fathom how to do this. The fields in advert_details we're worried about are body and subject. I've had a go, but this is out of my depth. Can anyone help? Thanks Will ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT Flash List
There is also the flasher list at chinwag... www.chinwag.com (under technical in the left navigation bar). --- "Guy J. McDowell" [EMAIL PROTECTED] wrote: Hi CF_Folks, I'm trying to find a list similar to this one about Flash and ActionScripting, to no avail. Can anyone point me in the right direction? Perhaps those wonderful FigLeaf fellows can help? Guy www.guymcdowell.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Learning Javascript Books,
The best book we've got here at work for JavaScript is "Professional JavaScript" (ISBN: 1-861002-70-X). There's also IRT's JavaScript FAQ which has excellent specific examples at http://developer.irt.org/script/script.htm. Heather ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Portland, Oregon: Ben Forta to Present
From an Internet Professionals Northwest (http://www.ipn.org/) mailing list... Directions to OHSU are available at the IPN web site. *** ColdFusion 5.0 Preview with Ben Forta Tuesday December 5, 2000 *** Allaires Ben Forta will present a preview of ColdFusion 5.0 to the ColdFusion Users Group December 5 at 3:30 p.m in the OHSU Auditorium. His presentation will also include Allaires technology roadmap for 2001 and beyond. Mr. Forta is the widely recognized ColdFusion evangelist and best selling author of The ColdFusion 4.0 Web Application Construction Kit and Advanced ColdFusion 4.0 Application Development. He has published many other titles including his most recent, WAP Development with WML and WML Script. The meeting runs from 3:30 5:30 p.m. at the Oregon Health Sciences University Auditorium. Food and Networking will take place between 3:00-3:30 p.m. The meeting is open and free to everyone. Please contact Jeff Cram at 221-9860 x103 or [EMAIL PROTECTED] for more information. __ Do You Yahoo!? Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Input type=File
In your form tag, you need to set the enctype: form name="formname" enctype="multipart/form-data" action="action.cfm" method="post" onSubmit="return formCheck()" --- Norman Elton [EMAIL PROTECTED] wrote: Well I'm not particularly looking for any photojournalists, BUT: I'm trying to do an INPUT type="file"..., but it doesn't seem to work! In reading some websites and documentation, it looks like I need to install Microsoft Posting Acceptor. Does anyone have any experience with this? Is it still required for Windows 2000? All the copies I can find seem to be rather old, so I don't want to install anything without knowing that it is in fact what I'm looking for. Thanks! Norman Elton Information Technology College of William Mary Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] __ Do You Yahoo!? Thousands of Stores. Millions of Products. All in one Place. http://shopping.yahoo.com/ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: HTML problem still here...
This should help: http://forums.allaire.com/DevConf/Thread.cfm?Message_ID=597339_#Message597339 If it doesn't, try going to http://forums.allaire.com - click on search at the top and type in your function name, select your scope and click search. Good Luck, Heather --- ibtoad [EMAIL PROTECTED] wrote: Ok, I created this little form page that helps people generate a professional ebay auction page. As you can see the only way they can get the html code right now is to use the internet explorer source button. I have asked this same question a couple of day ago and still haven't figured it out. Is there a way I can get the html code that is generated to display in the browser instead of using the source button? Here is the link: http://www.cfm-resources.com/h/happytoad/ Some people have suggested the htmleditformat fuction, but I don't understand how that works. P.S. you don't have to fill in any info to test it just click the submit button. Thanks, Rich Thanks, Rich Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Messenger - Talk while you surf! It's FREE. http://im.yahoo.com/ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: SQL UPDATE question (was Update Query/Output question from a newbie)
Mike, You need to remove the quotes from your ID field (which is a number, I assume...) CFQUERY DATASOURCE="dbcms" UPDATE tbldistrib SET distrib_name='#Form.distrib_name#', distrib_city='#Form.distrib_city#', distrib_state='#Form.distrib_state#', distrib_phone='#Form.distrib_phone#' WHERE distrib_id = #distrib_id# /CFQUERY Any help with this will be much appreciated. My Query is as follows: CFQUERY DATASOURCE="dbcms" UPDATE tbldistrib SET distrib_name='#Form.distrib_name#', distrib_city='#Form.distrib_city#', distrib_state='#Form.distrib_state#', distrib_phone='#Form.distrib_phone#' WHERE distrib_id = '#distrib_id#' /CFQUERY I have a hidden field in my update form for the distributor ID: INPUT TYPE="hidden" NAME="distrib_id" Value="#distrib_id#" The error I receive is: ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. SQL = "UPDATE tbldistrib SET distrib_name='Calico Corners III', distrib_city='Charlston', distrib_state='SOUTH CAROLINA', distrib_phone='555-555-' WHERE distrib_id = '31'" Data Source = "DBCMS" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (2:1) to (2:29) in the template file c:\inetpub\wwwroot\cms\updatedata.cfm. Thanks for your time, Mike Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Messenger - Talk while you surf! It's FREE. http://im.yahoo.com/ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
How to disable JavaScript popup windows...
I'm not sure it was here, but I remember someone asking about how to get rid of all the windows some ISPs open up when a user loads your page... I haven't tested this, but I ran across a possible solution this afternoon... http://developer.irt.org/script/540.htm __ Do You Yahoo!? Yahoo! Mail Free email you can access from anywhere! http://mail.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: more questions from an obvious newbie
Before calculating any line prices, set some variable
to zero. Add each line price to this variable as you
calculate the line price...your variable will then
equal the sum of the line prices.
--- Jon Tillman [EMAIL PROTECTED] wrote:
I need a bit more help (suprise).
I am wondering how I would go about adding together
the output of a dynamic
number of the following statement:
#DollarFormat("#ListGetAt(ShoppingCart_Qty,ListFind(ShoppingCart_Product,productId))#"*"#productPrice#")#
Basically, the above is the unit price * the
quantity, giving a line price. I
now need to take all of the line prices and create a
total of them. Any ideas?
--
This Email is 100% Virus Free! How do I know?
Because no Microsoft products were used to
generate it!
:::
Jon Tillman
LINUX USER: #141163
ICQ: 4015362
[EMAIL PROTECTED]
http://tillman.freehosting.net
:::
--
Archives:
http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
or send a message to
[EMAIL PROTECTED] with 'unsubscribe'
in the body.
__
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
http://invites.yahoo.com/
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Javascript:Writing you're own validation routine.
In order to use this from HTML, I would use
onClick="return validate()" for a button. Then the
function submits the form.
Not sure if this applies to your case or not.
--- Angél_Stewart [EMAIL PROTECTED] wrote:
Ok, in order to validate a date of the format
01-Jan-2000, someone wrote a
validation script for me in Javascript.
Now i am having problems attaching it to the CFINPUT
tags for the date
fields.
I tried:
---
cfform action="testdates.cfm" method="POST"
enablecab="Yes"
Wittle Text Box
cfinput type="Text" name="wittletextbox"
message="Yuh have to type
something here" required="Yes"
br
cfinput type="Text" name="date" required="yes"
onvalidate="javascript:validate();"
br
input type="submit"
/cfform
-
But it does not seem to be calling the validate()
function at all :-\
The Validate Function starts off:
script language="JavaScript1.2"!--
function validate()
{
date = document.forms[0].Date.value.toLowerCase();
var valid = "OK"
var count = 0
var GoodChars =
"janfebmrpyulgsoctvd/:-0123456789"
-
Have any of you written you're own validation
script,or used a third party
one with Coldfusion?
And if so, how was the script structured?
I'm at a total loss here.
-Gel
--
Archives:
http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
or send a message to
[EMAIL PROTECTED] with 'unsubscribe'
in the body.
__
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
http://invites.yahoo.com/
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Help with passing values via url hyperlinks
Here's the basic idea... URL: a href="formpage.cfm?button=value" action page: if url.button=optiona do this stuff if url.button=optionb do different stuff else do some default thing If the forms are basically the same, you can just set the form's action attribute and use the same form. __ Do You Yahoo!? Get Yahoo! Mail Free email you can access from anywhere! http://mail.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Results from several like tables
select fielda, fieldb, fieldc from JAN2000 union select fielda, fieldb, fieldc from FEB2000 etc. Should do the trick. --- Howie Hamlin [EMAIL PROTECTED] wrote: I have a client application where monthly data are stored in a single database (Access 2K for now) but in separate tables (each table has the same structure). For example: JAN2000 FEB2000 etc Is there any way, besides concatenating these tables, to perform a single SELECT query on these multiple tables? Thanks, Howie Hamlin -- inFusion Project Manager; On-Line Data Solutions, Inc. (631)737-4668 www.CoolFusion.com Please vote for iMS in the Most Innovative category here: *** http://www.sys-con.com/ColdFusion/readerschoice2000/ *** Check out inFusion Mail Server - the world's most configurable email server -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. __ Do You Yahoo!? Get Yahoo! Mail Free email you can access from anywhere! http://mail.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Request Server Variables
This is a web server thing. As far as I know, certain server variables are always available. Check the documentation for you web server for details. --- Frank Mamone [EMAIL PROTECTED] wrote: Is this CF4.5+ specific? What is the scope and longevity of its contents? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. __ Do You Yahoo!? Get Yahoo! Mail Free email you can access from anywhere! http://mail.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: problem with primary key
Double check that your record actually exists. select id from table where id=x (where x is the id you are trying to update) --- gregg Kachel [EMAIL PROTECTED] wrote: Hi, haveing a crisis here. Everything was working fine earlier, now all of a sudden when I try to do an update on my membership page I get the following error. SQL operation updated no rows. The SQL operation affected no rows.Either the Key value has changed or the row has been deleted. The primary key is id, and I can't figure out why it suddenly would stop working. The database and the program look fine. Any ideas what might be going on? Gregg -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. __ Do You Yahoo!? Get Yahoo! Mail Free email you can access from anywhere! http://mail.yahoo.com/ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: OT: ASP!
It'll puke if they put in an invalid user name and
password. Check for rs.eof before you display their
name and color.
--- David Shadovitz [EMAIL PROTECTED] wrote:
Can any of you ASP programmers tell me whether the
following code will
work?
It is the action page of a login form. It should
get the user's record
from a database and display the user's first name
and chosen color. I'm
not too concerned that it should be graceful, I just
want working code.
Thanks.
-David
===
(I've omitted the beginning and ending HTML tag)
head
titleUser Info/title
/head
body
h1User Info/h1
p
%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "demo"
set RS = Conn.Execute("select * from [UserInfo]
where [username]="
request.form("username") " and [password] =
request.form("password"))
%
table border="1" cellspacing="2" cellpadding="2"
bgcolor="%
=RS("color") %"
trtdHello, % =RS("f_name") %!/td/tr
/table
p
Additional page content goes here.
/body
YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk! For your FREE
software, visit:
http://dl.www.juno.com/get/tagj.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
or send a message to
[EMAIL PROTECTED] with 'unsubscribe'
in the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
or send a message to
[EMAIL PROTECTED] with 'unsubscribe'
in the body.
__
Do You Yahoo!?
Yahoo! Photos -- now, 100 FREE prints!
http://photos.yahoo.com
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Update Query
You need a primary key field that the user shouldn't be able to modify. Autonumber is the easiest way to do it in Access. That's the only way to uniquely identify a single record in your table. Otherwise, your data integrity would be compromised. --- Miriam Hirschman [EMAIL PROTECTED] wrote: How can I specify which row in my table I want to update if the user has the ability to change every field. Is there any way besides making an autoNumber field? I have an Access DB. Thanks, ---miriam -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. __ Do You Yahoo!? Send instant messages get email alerts with Yahoo! Messenger. http://im.yahoo.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Formatting Table Join Output question
The query below works if you take out the "test" part...that was to test it against an existing SQL database... I tested this same setup in Access 97 and it worked fine. You will need to set up your relationships in Access. I've got one to many/enforce referential integrity set up between event and audience_event and audience and audience_event. Here's the query: select e.eventname, e.eventdescription, a.audiencename from event e, audience_event ae, audience a where e.event_id = ae.event_id and ae.audience_id = a.audience_id I would display this with something to the effect of "for each eventname, show a list of audiences." I'll email you the database separately. --- Kurt Wiersma [EMAIL PROTECTED] wrote: Thank you for your help on this query below it is not working under Access. I am now trying, with the code below, to output the results of this query to an email. I need the audienceIDs to be joined to the audience name in the audience table but of course when I do this under this structure I get two records resulting. Both these records are the the same other then then their audience names. I need some way to catch these two audience names out of there and display them in the email along with the rest of the email being intact. Perhaps I should store them in a local var and then output them? Anyone have a good way I can accomplish this? Thanks in advance, --KW CFQUERY NAME="fullentry" DATASOURCE="#application.DataSource#" SELECT calendar.*, audience.*, audevent.eventID, audevent.audienceID FROM calendar INNER JOIN (audience INNER JOIN audevent ON audience.audienceID=audevent.audienceID) ON calendar.eventID=audevent.eventID /CFQUERY CFMAIL QUERY="fullentry" MAXROWS=1 TO="#application.emailto#" FROM="#contactemail#" SUBJECT="Calendar Entry to be Approved" TYPE="HTML" This email was generated by fusion.acc.stolaf.edu! P CFOUTPUT The following calendar entry sent by #contactname# is waiting for approval. P BEvent Name:/B #eventname#BR BStart Date:/B #DateFormat(startdate, "MM/DD/")#BR BEnd Date:/B #DateFormat(enddate, "MM/DD/")#BR BTime:/B #TimeFormat(eventtime, "hh:mm tt")#BR BLocation:/B #location#BR BWebURL:/B #webURL#BR P BAudience:/B #name# P BCategory:/B #name# P BDescription:/BBR #description# --- -- BA HREF="http://fusion.acc.stolaf.edu/calendar/admin/approve.cfm?id=#eventID#" Approve Entry/A/B BA HREF="http://fusion.acc.stolaf.edu/calender/admin/editevent.cfm?id=#eventID# "Edit this Entry/A/B /CFOUTPUT /CFMAIL On 5/16/00 5:34 PM, Heather Haindel at [EMAIL PROTECTED] wrote: Based on the tables I gave below, I would use this: select e.eventname, e.eventdescription, a.audiencename from test_event e, test_audience_event ae, test_audience a where e.event_id = ae.event_id and ae.audience_id = a.audience_id This works in SQL Server 6.5...you may need to adjust for your needs. I would also consider setting this up as a view (a query in Access) and pulling the data to your web site from there. --- Kurt Wiersma [EMAIL PROTECTED] wrote: What would be the SQL query to join these tables so that I could display the names of the audiences for each event? Would something like this work? CFQUERY NAME="fullentry" DATASOURCE="#application.DataSource#" SELECT c.eventID, c.startdate, c.enddate, c.eventname, c.eventtime, c.location, c.approved, c.webURL, c.description, c.contactname, c.contactemail FROM calendar c WHERE c.eventID IS IN (SELECT eventID, audienceID FROM audevent WHERE audienceID IN (SELECT audienceID, name FROM audience)) /CFQUERY -- From: Heather Haindel Reply-To: [EMAIL PROTECTED] Date: Mon, 15 May 2000 17:21:47 -0700 (PDT) To: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Database Structure Question Assuming I understand correctly, you have two entities...audience and event. Each event on your calendar can be classified under one to many audience (types). Each audience (type) can be a classification for zero to many events. That gives you a many to many relationship between audience and event. In order to normalize this, you need an intersection table. I would create these three tables: audience - audience_id (PK), audiencename event - event_id (PK), eventname, eventdescription audience_event - audevent_id (PK), audience_id (FK), event_id (FK) --- Kurt Wiersma wrote: I have a database which is going to hold events for a calendar app. In it I have a table for audiences which has an audienceID and audience name. Inside the calendar t
Re: Database Structure Question
Assuming I understand correctly, you have two entities...audience and event. Each event on your calendar can be classified under one to many audience (types). Each audience (type) can be a classification for zero to many events. That gives you a many to many relationship between audience and event. In order to normalize this, you need an intersection table. I would create these three tables: audience - audience_id (PK), audiencename event - event_id (PK), eventname, eventdescription audience_event - audevent_id (PK), audience_id (FK), event_id (FK) --- Kurt Wiersma [EMAIL PROTECTED] wrote: I have a database which is going to hold events for a calendar app. In it I have a table for audiences which has an audienceID and audience name. Inside the calendar table I have a field for audienceIDs where I was thinking of keeping a comma delimited list of audienceIDs. The problem is I cannot join the two tables very easily in this format. I want the user to be able to check a checkbox for each audience they would like the event to be categorized under. Can anyone suggest a better database structure or code that would allow the two tables to be joined under this structure? Please cc my email address in the reply as I am on the digest format right now! Thanks for you help, -- Kurt -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. __ Do You Yahoo!? Send instant messages get email alerts with Yahoo! Messenger. http://im.yahoo.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
*answer?*Re: Question(banging my head against a wal)
Try cf_querytoarray in the developer exchange. Then you'll be able to have the number of fields and their names. http://devex.allaire.com/developer/gallery/ --- Clint Tredway [EMAIL PROTECTED] wrote: I am trying to build a dynamic browser based database utility. Is there a way to output columns from a query when you don't know what the field names are? Here is what I am talking about: I pass a cfm page a list of fields that I want to see all the records for. I use the form name in my select statement, then I loop through the form name to create my table header. Now I want to display the values for the fields under the header I created. what is the method to do this? Here is my code I use the form name in my select statement cfquery name="selecttable" datasource="#form.get_db#" Select #form.table# From #form.tablename# /cfquery then I loop through the form name to create my table header table width="700" cellpadding="0" cellspacing="0" border="0" tr class="header" cfset fieldcount = 0 cfloop list="#form.table#" index="curr_field" cfset fieldcount = fieldcount + 1 cfoutputtd#curr_field#/td/cfoutput /cfloop cfoutputfieldcount: #fieldcount#/cfoutput /tr cfset abc = 0 Now I want to display the values for the fields under the header I created. cfloop list="#selecttable.columnlist#" index="curr_col" cfif abc IS 0 tr /cfif cfset abc = abc + 1 tdcfoutput#curr_col#/cfoutput/td cfif abc IS fieldcount /tr cfset abc = 0 /cfif /cfloop /table This output is used for debugging purposes cfoutput query="selecttable" cfloop list="#selecttable.columnlist#" index="curr_column" #curr_column#br /cfloop /cfoutput What do I need to change/fix/get rid off for this to work. I can do this in ASP with ADO, but I want this in CF. Thanks for any help/suggestions. Clint -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. __ Do You Yahoo!? Send instant messages get email alerts with Yahoo! Messenger. http://im.yahoo.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: REVERSE QUESTION --- Is there anything that Cold Fusion can do that ASP can't do?
I have yet to find a way to get .asp to duplicate the functionality of cfinclude. I guess this is supposed to be fixed w/ the new version (of IIS or ASP?)... __ Do You Yahoo!? Send instant messages get email alerts with Yahoo! Messenger. http://im.yahoo.com/ -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
