Display Excel Data
I am trying to deliver spreadsheets in my browser using CF and BlueDragon. I can't get it to display correct. Anyone know what the problem could be?? Here is the code I am using CFSETTING ENABLECFOUTPUTONLY=yes CFQUERY name=PrimaryUserNames datasource=DeploymentDB SELECT * FROMNNPTC_USERS WHERE SEAT_ID IS NOT NULL /CFQUERY CFQUERY name=PrimaryUsers datasource=DeploymentDB SELECT * FROMNNPTC_USERS WHERE ROOM = 'P216' OR ROOM = 'P237' OR ROOM = 'D215' /CFQUERY CFSET TabCHar =Chr(9) CFSET NewLine =Chr(13) CHR(10) CFCONTENTTYPE=application/msexcel CFHEADER NAME=Content-Disposition value=filename=NNPTC_USERS.xls CFLOOP QUERY=PrimaryUserNames cfoutput #Rank##TabCHar# #First_Name##TabCHar# #Middle_Initial##TabCHar# #Last_Name##TabCHar# #Room##TabCHar# #Floor##TabCHar# #SEAT_ID##TabCHar# #Seat_Clin##TabCHar##NewLine# /cfoutput /CFLOOP ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Automatic File List in Database
How would be the easiest way to get a directories file names imported into a database and keep them updated automatically whenever a new file is created? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Automatic File List in Database
The file list holds images and drawings, which need descriptions in another field in order to be selected. There are thousands of files and the files have strange naming conventions. Best I can figure, I need a field with paths and a field with descriptions, so I can call them up and display them in the page. I tried using CFDIRECTORY, but describing the files is the main thing. - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 24, 2003 1:59 PM Subject: Re: Automatic File List in Database Now that I think of it...why store the file list in the DB? Why not just use CFDIRECTORY when the list is needed...that way it's always current and there is no maintenance required. Of course you may have some reason to store it, but there ya go ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 24, 2003 1:53 PM Subject: Re: Automatic File List in Database Well you could use CFDIRECTORY to get the file list and store it in the database. To keep that list current is another matter. It depends on how current the list needs to be (or how often the files change). If it's not too frequently you could have a scheduled task that routinely deletes the file list from the database and sticks in the current list (same way you would get it in the database initially). HTH Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Michael Pool [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 24, 2003 4:36 PM Subject: Automatic File List in Database How would be the easiest way to get a directories file names imported into a database and keep them updated automatically whenever a new file is created? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
MORE Automatic File List in Database with description
Q: How would be the easiest way to get a directories file names imported into a database and keep them updated automatically whenever a new file is created? The file list holds images and drawings, which need descriptions in another field in order to be selected. There are thousands of files and the files have strange naming conventions. Best I can figure, I need a field with paths and a field with descriptions, so I can call them up and display them in the page with their descriptions. I tried using CFDIRECTORY, but describing the files a must. I don't know how CFDIRECTORY could do that ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Automatic File List in Database
That may work...I think.have you got an example of that code? - Original Message - From: Philip Arnold [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 24, 2003 2:21 PM Subject: RE: Automatic File List in Database The file list holds images and drawings, which need descriptions in another field in order to be selected. There are thousands of files and the files have strange naming conventions. Best I can figure, I need a field with paths and a field with descriptions, so I can call them up and display them in the page. I tried using CFDIRECTORY, but describing the files is the main thing. If the description isn't always going to be there, then why not have the location and file name, plus the description in the database, that way you can reference it for those that it needs Then use a Query of Query to join the CFDIRECTORY result to the information in the database Would that work? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Automatic File List in Database
Yes that is where I am going with this.. I have the FTP file upload templates already built for new files, but as for the files currently in the database, I need to import their names into the 'filename' field and leave a blank in the 'description' field. The users still have access to the file system at this time and files are getting added and deleted at such a rate that I can't keep up with it. I am building a document management system that will restrict their access to the files and require descriptions of them added to the database, but until then, I have to keep track of every file in the folder. I was hoping I could possibly update the database 'filename' field automatically at least until I lock them out of the NTFS directory. - Original Message - From: Barney Boisvert l [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 24, 2003 2:25 PM Subject: RE: Automatic File List in Database For situations like this (uploaded files in a CMS, web-based FTP on steroids, etc), I make a table that stores a filename, title, description, and watever else, and then put put all the files in a single directory. Then when you want the file, you use the 'filename' field to go get it form the directory. The one caveat to make is that files added directly to the file system are never visible in the CF interface. Files must be added through the CF interface. This also lets you automatically rename files without the user needing to care if two people both want to upload 'my_picture.jpg'. There's no reason you couldn't make a scraper that'd scrape the file system looking for files not in the DB, and then add them with a null description if keeping things synched from that direction is important. HTH, barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral (formerly PIER System, Inc.) [EMAIL PROTECTED] voice : 360.671.8708 x12 fax : 360.647.5351 www.audiencecentral.com -Original Message- From: Michael Pool [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2003 5:07 PM To: CF-Talk Subject: Re: Automatic File List in Database The file list holds images and drawings, which need descriptions in another field in order to be selected. There are thousands of files and the files have strange naming conventions. Best I can figure, I need a field with paths and a field with descriptions, so I can call them up and display them in the page. I tried using CFDIRECTORY, but describing the files is the main thing. - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 24, 2003 1:59 PM Subject: Re: Automatic File List in Database Now that I think of it...why store the file list in the DB? Why not just use CFDIRECTORY when the list is needed...that way it's always current and there is no maintenance required. Of course you may have some reason to store it, but there ya go ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 24, 2003 1:53 PM Subject: Re: Automatic File List in Database Well you could use CFDIRECTORY to get the file list and store it in the database. To keep that list current is another matter. It depends on how current the list needs to be (or how often the files change). If it's not too frequently you could have a scheduled task that routinely deletes the file list from the database and sticks in the current list (same way you would get it in the database initially). HTH Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Michael Pool [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 24, 2003 4:36 PM Subject: Automatic File List in Database How would be the easiest way to get a directories file names imported into a database and keep them updated automatically whenever a new file is created
Re: Automatic File List in Database
NO VERITY. CF_UNFORTUNATELY BlueDragon - Original Message - From: Jerry Johnson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 24, 2003 2:41 PM Subject: Re: Automatic File List in Database Before you settle into a solution, what type of files are you talking about? I have solved this a couple of different ways. 1. Directories of htm and cfm and pdf files. I embedded extra tags in a comments section at the top of the file. bangdashdash DESCRIPTIONDescription Goes Here/DESCRIPTION TEASERThis is the short line of text to display on listing pages/TEASER ISSUEDATEJan 13, 2003/ISSUEDATE dashdash Then used Verity to search and retrieve these fields from the files, inlcuding path, URL, and these extra FIELDS. 2. Married each file with an info file stored in the same directory with the same name but extra extension. Jerry.jpg Jerry.jpg.nfo or Jerry.jpg.txt or Jerry.jpg.xml And then place all the extra info into that file. Easy to find. Easy to see when missing. 3. For those files with short simple desc, just add the desc to the filename or directory name. MA20030317_News Story_Boy Bitten By Dog.htm Just some ideas, Jerry Johnson [EMAIL PROTECTED] 03/24/03 08:23PM That may work...I think.have you got an example of that code? - Original Message - From: Philip Arnold [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 24, 2003 2:21 PM Subject: RE: Automatic File List in Database The file list holds images and drawings, which need descriptions in another field in order to be selected. There are thousands of files and the files have strange naming conventions. Best I can figure, I need a field with paths and a field with descriptions, so I can call them up and display them in the page. I tried using CFDIRECTORY, but describing the files is the main thing. If the description isn't always going to be there, then why not have the location and file name, plus the description in the database, that way you can reference it for those that it needs Then use a Query of Query to join the CFDIRECTORY result to the information in the database Would that work? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Old Version of CF $erver
Anybody out there know a place I can get ahold of an old copy of CF Server 5 or less? I have a new boss that won't spring for CFMX and he want's me to build a huge Intranet document/information management system. All in all I am looking for ANY cheap routes to getting CF on this server (what a tight ass this guy is!this is a Billion dollar contract and he is worried about $700!!). ANY help you can give me would be greatly appreciated. Believe me, I have tried to convince him to buy me the new version of the server, to no avail. There has got to be a way I can get this thing running inexpensively. I'm only going to have about 75 users on this Intranet (if that) but, this app could carry over to many other installations around the world if I can make it fly. (this means lots of CFMX sales...and I mean LOTS! Plus, lots of CF Programmer jobs for all of us!!!) I know about the single user version, but that is not going to work...I need a cheap, legal, workable solution to this. Thank's CF Peeps. Tryin' to keep the faith M.Pool ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Old Version of CF $erver
Wow! Is this Blue Dragon For Real!!?? Is this the Answer???!!! CFIf I can deploy it on the Intranet and everyone else can get served CFML not just the one local IP./CFif CfElse??? M. Pool -- Original Message -- From: Gary Groomer [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Sat, 22 Feb 2003 07:20:15 -0800 What about Blue Dragon for CFML? http://www.newatlanta.com Gary - Original Message - From: Michael Pool [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, February 22, 2003 7:07 AM Subject: Old Version of CF $erver Anybody out there know a place I can get ahold of an old copy of CF Server 5 or less? I have a new boss that won't spring for CFMX and he want's me to build a huge Intranet document/information management system. All in all I am looking for ANY cheap routes to getting CF on this server (what a tight ass this guy is!this is a Billion dollar contract and he is worried about $700!!). ANY help you can give me would be greatly appreciated. Believe me, I have tried to convince him to buy me the new version of the server, to no avail. There has got to be a way I can get this thing running inexpensively. I'm only going to have about 75 users on this Intranet (if that) but, this app could carry over to many other installations around the world if I can make it fly. (this means lots of CFMX sales...and I mean LOTS! Plus, lots of CF Programmer jobs for all of us!!!) I know about the single user version, but that is not going to work...I need a cheap, legal, workable solution to this. Thank's CF Peeps. Tryin' to keep the faith M.Pool ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Rock Band needs a Codie
OK I give up. I know when I am beat. This is a simple one. I know this but I just can't get it to work for some reason. I saw something similar in an old post, but it was not informative enough. Here's the deal: I have 2 tables in a Rock Band's database. (annie.mdb) GIGLIST and GIGDATES I have a template page that I want to show TONIGHT'S SHOW data if there is a show tonight and IF NOT, then the NEXT SHOW date data. as I am sure you can tell by the extension, this is an ACCESS Database, I have the GIGDATE field set to a date field. (MM/DD/) Fields are as follows: GIGLISTTablename ID, NAME, LOCATION, ADDRESS, CITY_ST_ZIP, PHONE GIGDATESTablename ID, GIGNAME, GIGDATE, GIGTIME (GIGNAME = giglist.name) So, let me reitterate I want to show all of the current variables for the show record that has tonight's date (if there is a show tonight) and set a variable NEXTSHOWTIME to either display the text Tonight's Show or set to Next Show if no show tonight and then show the next available showdate's recordset from the GIGDATES table and the corresponding venue location info from the GIGLIST table. GIGNAME=NAME in the GIGLIST table FREE MUSIC CD to the first one who sends me code that makes this thing work! Thanks! M. Pool [EMAIL PROTECTED] __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Rock Band needs a Codie
I will try to mix up my field values a little morehow does #sibilance#, #Check.test#, #1#, #2#, #3# grab you? Thanks..will check this out and see what comes of it.. MP -Original Message- From: Dan Haley [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 5:25 PM To: CF-Talk Subject: RE: Rock Band needs a Codie Do a subquery selecting the min(gigdate) where gigdate = today. Select the gig that is on that date, then in CF determine what text to show depending on the date of the gig. Something like select giglist.*, gigdates.gigdate, gigdates.gigtime fromgigdates, giglist where gigdates.gigname = giglist.name and gigdates.gigdate = (select min(gigdate) from gigdates where gigdate = now()) cfif gigdate eq today tonight's show cfelse next show /cfif That was fun saying gig so many times ... Dan -Original Message- From: Michael Pool [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 1:21 PM To: CF-Talk Subject: Rock Band needs a Codie OK I give up. I know when I am beat. This is a simple one. I know this but I just can't get it to work for some reason. I saw something similar in an old post, but it was not informative enough. Here's the deal: I have 2 tables in a Rock Band's database. (annie.mdb) GIGLIST and GIGDATES I have a template page that I want to show TONIGHT'S SHOW data if there is a show tonight and IF NOT, then the NEXT SHOW date data. as I am sure you can tell by the extension, this is an ACCESS Database, I have the GIGDATE field set to a date field. (MM/DD/) Fields are as follows: GIGLISTTablename ID, NAME, LOCATION, ADDRESS, CITY_ST_ZIP, PHONE GIGDATESTablename ID, GIGNAME, GIGDATE, GIGTIME (GIGNAME = giglist.name) So, let me reitterate I want to show all of the current variables for the show record that has tonight's date (if there is a show tonight) and set a variable NEXTSHOWTIME to either display the text Tonight's Show or set to Next Show if no show tonight and then show the next available showdate's recordset from the GIGDATES table and the corresponding venue location info from the GIGLIST table. GIGNAME=NAME in the GIGLIST table FREE MUSIC CD to the first one who sends me code that makes this thing work! Thanks! M. Pool [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Rock Band Needs a Codie Updated
OK Guys This works EXCEPT I want the TONIGHT to take preference if it is an available date...as it stands the Greater Than date (next date) takes preference and only displays... cfset DBPath=\annie.mdb cfquery name=get_gig datasource=#DBPath# dbtype=OLEDB provider=Microsoft.Jet.OLEDB.4.0 providerdsn=#DBPath# username=Admin password= maxrows=1 SELECT* FROM gigdates, giglist WHERE gigname = name AND gigdate = '#dateformat(now(), mm/dd/)#' !---this is suspect... I can't figure out how to prefer the date tonight if it is a showdate--- /cfquery cfoutput query=get_gig cfif dateformat(#gigdate#, mm/dd/) eq dateformat(now(), mm/dd/) Tonight's Show (#gigtime#) cfelse Next Show (#gigdate# - #gigtime#) /cfif #Name# #location# #address# #CITY_ST_ZIP# #PHONE#br /cfoutput -Original Message- From: Ken Beard [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 9:10 PM To: CF-Talk Subject: RE: Rock Band needs a Codie right except you're using the table aliases when outputting with cf down near the bottom.. simple mistake :) what's up greg. Ken -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 7:51 PM To: CF-Talk Subject: RE: Rock Band needs a Codie Let me try: cfquery name=get_gig datasource=annie? maxrows=1 SELECTgd.*, gl.* FROM gigdates gd, giglist gl WHERE gd.gigname = gl.name AND gd.gigdate = #dateformat(now, mm/dd/)# /cfquery cfoutput query=get_gig cfif dateformat(get_gig.gigdate, mm/dd/) eq dateformat(now(), mm/dd/) Tonight's Show (#gd.gigtime#) cfelse Next Show (#gd.gigdate# - #gd.gigtime#) /cfif #gl.Name# #gl.location# #gl.address# #gl.CITY_ST_ZIP# #gl.PHONE#br /cfoutput -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 5:36 PM To: CF-Talk Subject: Re: Rock Band needs a Codie No promises. !--- NOTE: the access date query may be wrong, but I believe the date delimiter is ## --- cfset todayÚteFormat(now(),mm/dd/) cfquery name=nextgig datasource=annie? select top 1 NAME, LOCATION, ADDRESS, CITY_ST_ZIP, PHONE, GIGDATE, GIGTIME from gigdates,giglist where gigdate =###today### and gigdate.gigname=giglist.name /cfquery cfoutput query=nextgig cfif dateCompare(gigdates.gigdate,today,d) eq 0 Tonight's Show (#GIGTIME#) cfelse Next Show (#GIGDATE# - #GIGTIME#) /cfif #Name# #location# #address# #CITY_ST_ZIP# #PHONE#br /cfoutput HTH Jerry Johnson [EMAIL PROTECTED] 09/12/02 04:20PM OK I give up. I know when I am beat. This is a simple one. I know this but I just can't get it to work for some reason. I saw something similar in an old post, but it was not informative enough. Here's the deal: I have 2 tables in a Rock Band's database. (annie.mdb) GIGLIST and GIGDATES I have a template page that I want to show TONIGHT'S SHOW data if there is a show tonight and IF NOT, then the NEXT SHOW date data. as I am sure you can tell by the extension, this is an ACCESS Database, I have the GIGDATE field set to a date field. (MM/DD/) Fields are as follows: GIGLISTTablename ID, NAME, LOCATION, ADDRESS, CITY_ST_ZIP, PHONE GIGDATESTablename ID, GIGNAME, GIGDATE, GIGTIME (GIGNAME = giglist.name) So, let me reitterate I want to show all of the current variables for the show record that has tonight's date (if there is a show tonight) and set a variable NEXTSHOWTIME to either display the text Tonight's Show or set to Next Show if no show tonight and then show the next available showdate's recordset from the GIGDATES table and the corresponding venue location info from the GIGLIST table. GIGNAME=NAME in the GIGLIST table FREE MUSIC CD to the first one who sends me code that makes this thing work! Thanks! M. Pool [EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Rock Band needs a CodieFinal Solution
OK I got it. I had to change a few things, but thanks to all who helped. Ken, you win the CD since your's was closest to what I used. Send your address to me off board and I'll ship it out to you. Here is what I ended up with: cfquery name=get_gig datasource=#DBPath# dbtype=OLEDB provider=Microsoft.Jet.OLEDB.4.0 providerdsn=#DBPath# username=Admin password= maxrows=1 SELECT* FROM gigdates, giglist WHERE gigname = name AND gigdate = '#Dateformat (Now(), MM/DD/)#' ORDER BY GIGDATE /cfquery cfoutput query=get_gig cfif #gigdate# eq #Dateformat (Now(), MM/DD/)# Tonight's Show (#gigtime#) cfelse Next Show (#gigdate# - #gigtime#) /cfif #Name# #location# #address# #CITY_ST_ZIP# #PHONE#br /cfoutput Now to format all of that for use in Macromedia Flash and I am cooking with gas! (I got that ready to roll) Thank's again everyoneyou ROCK! M. Pool [EMAIL PROTECTED] -Original Message- From: Ken Beard [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 9:10 PM To: CF-Talk Subject: RE: Rock Band needs a Codie right except you're using the table aliases when outputting with cf down near the bottom.. simple mistake :) what's up greg. Ken -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 7:51 PM To: CF-Talk Subject: RE: Rock Band needs a Codie Let me try: cfquery name=get_gig datasource=annie? maxrows=1 SELECTgd.*, gl.* FROM gigdates gd, giglist gl WHERE gd.gigname = gl.name AND gd.gigdate = #dateformat(now, mm/dd/)# /cfquery cfoutput query=get_gig cfif dateformat(get_gig.gigdate, mm/dd/) eq dateformat(now(), mm/dd/) Tonight's Show (#gd.gigtime#) cfelse Next Show (#gd.gigdate# - #gd.gigtime#) /cfif #gl.Name# #gl.location# #gl.address# #gl.CITY_ST_ZIP# #gl.PHONE#br /cfoutput -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 5:36 PM To: CF-Talk Subject: Re: Rock Band needs a Codie No promises. !--- NOTE: the access date query may be wrong, but I believe the date delimiter is ## --- cfset todayÚteFormat(now(),mm/dd/) cfquery name=nextgig datasource=annie? select top 1 NAME, LOCATION, ADDRESS, CITY_ST_ZIP, PHONE, GIGDATE, GIGTIME from gigdates,giglist where gigdate =###today### and gigdate.gigname=giglist.name /cfquery cfoutput query=nextgig cfif dateCompare(gigdates.gigdate,today,d) eq 0 Tonight's Show (#GIGTIME#) cfelse Next Show (#GIGDATE# - #GIGTIME#) /cfif #Name# #location# #address# #CITY_ST_ZIP# #PHONE#br /cfoutput HTH Jerry Johnson [EMAIL PROTECTED] 09/12/02 04:20PM OK I give up. I know when I am beat. This is a simple one. I know this but I just can't get it to work for some reason. I saw something similar in an old post, but it was not informative enough. Here's the deal: I have 2 tables in a Rock Band's database. (annie.mdb) GIGLIST and GIGDATES I have a template page that I want to show TONIGHT'S SHOW data if there is a show tonight and IF NOT, then the NEXT SHOW date data. as I am sure you can tell by the extension, this is an ACCESS Database, I have the GIGDATE field set to a date field. (MM/DD/) Fields are as follows: GIGLISTTablename ID, NAME, LOCATION, ADDRESS, CITY_ST_ZIP, PHONE GIGDATESTablename ID, GIGNAME, GIGDATE, GIGTIME (GIGNAME = giglist.name) So, let me reitterate I want to show all of the current variables for the show record that has tonight's date (if there is a show tonight) and set a variable NEXTSHOWTIME to either display the text Tonight's Show or set to Next Show if no show tonight and then show the next available showdate's recordset from the GIGDATES table and the corresponding venue location info from the GIGLIST table. GIGNAME=NAME in the GIGLIST table FREE MUSIC CD to the first one who sends me code that makes this thing work! Thanks! M. Pool [EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
FW: Error Diagnostic Information CF_POOF?
OK. I never ask unless I am stumped. I'm sure somebody has run into this b/c when I do a search on the 'Net for the error, I get links to various other CFM web pages that have thrown the error while being indexed by the search engines. Here goes First the stats: Server: Windows NT 4.0 ~ I suspect with all the most current updates (Shared host~ XO Communications) CF Server: 4.5 ~ patched and updated I hope! Database: Access 2000 (Sorry, I can't afford a Lexus either.) Connection: OC48 dual redundant to the backbone (so they say!) Client: OS: Windows 98/2000/XP Browser: IE6 Connection: DSL Cache: Clear w/ 1 meg storage setting and Every visit... checked. XX ERROR::: XX Error Occurred While Processing Request Error Diagnostic Information An error occurred while attempting to establish a connection to the service. The most likely cause of this problem is that the service is not currently running. You can use the 'Services' Control Panel to verify that the service is running and to restart it if necessary. Windows NT error number 2 occurred. XX PAGE CODE :: XX cfif isdefined (customerid)/cfif cfquery datasource=schome name=getinfo select * from agentid where customerid=#customerid# /cfquery cfoutput query = getinfo html head title#realestatefirmwebsite#/title meta name=GENERATOR content=Microsoft FrontPage 4.0 /head frameset framespacing=0 border=false frameborder=0 cols=160,* frame name=left scrolling=no noresize target=rbottom src=http://www.schomesales.com/schome/bluemoon.cfm?customerid=#customer id# frameset rows=129,* frame name=rtop target=rbottom src=http://www.schomesales.com/schome/bluemoontopgui.cfm?customerid=#cu stomerid# scrolling=no noresize frame name=rbottom src=http://www.schomesales.com/schome/bluemoonbody.cfm?customerid=#cust omerid# scrolling=auto /frameset noframes body pThis page uses frames, but your browser doesn't support them./p /body /noframes /frameset /html /cfoutput I made absolute paths out of the individual frames for ease of lookup... It is broken either way, absolute or relative. This error happens intermittently...sometimes often, other times it takes several refreshes to get it to happenclearing the cache helps ensure the error is seen. Sometimes one frame will work, other times 2 frame pages will resolve and one will not...there is no rhyme or reason I can see. I have tried to isolate this as a browser issue or an OS problem, but I really think it is either a codeing problem or a Server issue. ( I'm praying it's their fault and they can fix it.) The most I could find out about Windows NT error number 2 is that it means Page not found (Duhuh... Another egregious waste of syntax by our good friends at MS!) This, CF Developers, is your missionshould you choose to accept it. This message will self destruct in 5..4...3...2 CF_POOF Thanks. Michael Pool [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CSS and Netscape - was(CSS and dynamically changing classes)
I think it is up to us programmers to make a stand and just Boycott the stupid Netscape browser because it is just too much of a pain in the ass. OK, so we are helping Bill Gates out a little, but ya know.the damn thing his company made works better. (I'm not saying it's perfect, but it's better than Netscape!) If browser software was under Darwin's theory of evolution.Netscape wouldn't be a Gecko...it would still be called POND SCUM like it ought to! Lets hope we can Kill it off before it comes under some endangered species list and some tree hugging technocrat makes us buy Netscape Compatible products just so we can say there is diversity in the marketplace!!! What a bunch of BS! Sometimes.ya just gotta make exceptions to the RULES! Give Up USA!! Bill Won! He has more money! (and better products sometimes) I'm just glad he's an American and not from somewhere else! H...wonder what his W2 says on line 2? [Sick of programming for Netscape] Michael Pool -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 2:27 PM To: CF-Talk Subject: RE: CSS and Netscape - was(CSS and dynamically changing classes) You're right, this is a can of worms, but...Really, I am asking that Steve Case drop the Netscape browser altogether. I'm not exactly sure which standards that IE supports or doesn't support, or how NS compares to it. But the fact is that IE it's extremely forgiving, feature-rich, and just a great browser altogether, while NS is just a headache for designers. To tell you the truth, I don't know how they keep producing the NS browser. I't doesn't seems to me that it makes any money for the company. The fact is that there are standards and that anything which makes the code easier to program and maintain should be included in the standard. If NS was the all around better browser, we would be using that instead of IE, right, Mac and Betamax arguments not withstanding because this is a free item we're talking about. I guess it can also be said that it's the inclusion of the free browser from IE that makes both browsers so great today. The whole point of this is that it's cost companies MILLIONS of dollars in lost time developing and lost revenue due to features not working similarly in both browsers because one company can't get it right. If anybody has an argument that Netscape finally does have it right, then I have three questions: 1) Where is Netscape 5? 2) Why was Netscape 6 now based on all new code(Gecko)? 3) Why was Netscape 6.01 so quickly rushed out the door? Anyway, I will include any and all names that wish to be included on the letter. I will include any arguments for the position as well, and I intend to send it directly to Mr. Case via snail mail. Matt Small P.S. This is fun. :-) -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 1:47 PM To: CF-Talk Subject: RE: CSS and Netscape - was(CSS and dynamically changing classes) At the risk of opening a can of worms. Which one is more standards compliant? Netscape or IE? Since I concentrate on database stuff or functionality, I rarely use 'advanced' layout features such as layers or CCS. Are you asking Steve Case / AOL to be compatible with Microsoft Internet Explorer? Or are you asking them to adhere to w3.org standards? Internet Explorer may be the defacto standard in usability, functionality, and features but saying that does not address whether or not they are more (or less) standards-compliant than Navigator. Since that is the issue you want to be addressed, it is probably what you should point out in the letter. Perhaps Mr Case will just point you to Mozilla, which (although I haven't used) is supposed to adhere strictly to standards compliancy. At 01:16 PM 4/16/2002 -0400, you wrote: Dear Mr. Case, We are a group of internet designers/ developers that have come together to express our dissatisfaction with the Netscape line of browsers. Developing for Netscape is more than a headache for web designers and developers. It means money spent for time when developing a new site for multiple browsers; it means having to code for the lowest common denominator in browsers and using the least number of features available. It means that people have different technologies to access the same medium, and they get different, unequal experiences. None of these things are good for the internet. Let us use an analogy: If our television were to get Time-Warner Cable, with every channel from HBO to Fox News, and your different brand of television received the same cable line but the top 30 channels were fuzzy, and then advertisements appeared much different than when the designers created them, what kind of experience would that be? You have advertisers unhappy because their messages do not get across
RE: session cant work in IE 5.5 and 6??
It's a new security patch I thinkgotta turn on your cookies and reset the session variable switch. Thanks a lot MicroSoft! -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 11:37 PM To: CF-Talk Subject: Re: session cant work in IE 5.5 and 6?? I use session variables in 5/5.5 and 6 ...as well as other browsers Don't know what to tell ya ... but it isn't the browser ..unless you have the cookies turned off or something like that.. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder hihi... anyone have such problems before..?? my codes works perfectlyfine in ie 5... but seems like the session variables cant be used in IE 5.5 and 6. i tried to output the values... in 5.. can.. but not in 5.5 and 6.. sigh.. help help sad, han __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF_404_errors_shared_hosting
http://www.cs.tut.fi/~jkorpela/www/404.html Check this out. It may help you. Michael Pool [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 3:40 PM To: CF-Talk Subject: CF_404_errors_shared_hosting This is a shot in the dark ... Our company has a shared hosted site and we want to be able to control the error templates that are displayed when a user gets a 404 error for example. Our hosting company said they CAN'T help us, unless we migrate from a shared hosting to a co-located service. ugh! Does anyone know a CF way around this? I'm figuring the templates are below the CF level at the Web server, so I'm SOL. 8-) Thanks in advance. D- Get the award winning ISP, ATT WorldNet Service http://download.att.net/webtag __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Real-time Monitoring
I have been looking for a free solution to their service as well. Wish I knew how to make one. Anyone have any ideas? -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 11:48 AM To: CF-Talk Subject: OT: Real-time Monitoring A few months ago, we were talking about Humanclick on cf-talk, and how some of us have been using its free Real-time Monitoring program. Since Humanclick no longer off the Real-time Monitoring for the free version, does anyone know of a similar service that's free? Will --- A woman drove me to drink and I didn't even have the decency to thank her. --W.C. Fields __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
