cfloop in the cfmail tag?
Is it possible to use inside a tag? I want to filter through a directory list and only mail files with today's date. Specifically, I want to check the mail/undelivr folder each night and email the names and contents of entries for that day. Here is what I have: The following emails were placed in the CFFUSION\mail\undelivr folder on Web1 on #dateFormat(NOW(), ' d, ')#. File name: #name# Contents: #Test# I know the cffile works, I tested the output, but the email never gets sent. Thanks for any suggestions. __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com __ 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
missing k2server.ini file
I have CF 5.0 Professional and can not find the k2server.ini files on my server. Does anyone know if Professional ships with verity k2, and if so, how do I load it on the server? Tim __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ __ 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
controlling the Summary attribute of
Is there a way to control the content that is returned with the Summary atribute of cfsearch? Maybe a way to disgnate text, or read the metatag description field? Tim __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ __ 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
mime attchments with cfmail
Is it possible to send more than one attchment with cfmail? I tried to list the attachments seperated by a comma and by a semi colon, but got errors. Tim ~~ 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
Using cffile to append to a text file
I am using to append text to a text file from a form. I know to use (chr10) and (chr13) for line breaks and carriage returns, but what do I use to creats spaces between the fields and to tab over? Thanks, Tim __ Do You Yahoo!? Send your FREE holiday greetings online! __ 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=coldfusiona 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
reading text file contents intro a database
I need to read the contents of a comma or tab delimited .txt file, and have the contents placed in the appropriate fields in a database. For example, the text file will look like: Course name 1 First person 2 second person 3 third person etc. The database will have a "course_name" field, and a "first", "second" "third" up to "twenty". I need to enter the course name in the course_name field, then enter the first person's name into the "first" field, second person's name in the "second" field, etc. I will have a number of course files, and will need to do each. Any help would be appreciated. Tim __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! __ 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=coldfusiona 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
Need a way to cycle through records
I have a database of race results cover six years. The results table has a date field, race name field, and fields for the first 50 finishers. I also have a race name table and a racers table. The fields in the results table are populated with the corresponding key fields for the race and runners. The user will select a racer to query. I need to loop through the results table and do two things: 1) check the name of the race, and 2) check with field that the runner finished in each race. (first loop, check all race #1 entries and placement of runner #1, second loop check all race #2 entries and placement of runner #1, etc. For results, I need to show the name of each race, and the number of top 5 finishes, top 10 finishes, top 15 finishes and average finish that that runner has had in that particular race over the years. I'm confused as to whether to use cfswitch or cfif statements. Or whether I should use arrays. Could someone give some guidance, and possible examples of how the code should look? Thanks, Tim __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! __ 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=coldfusiona 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
creating a list from a query
I need to create a comma delineated list of all field values generated from a query. I know ValueList will create a list, but from what I can tell it will only create a list of values from one column for all records. Is the a way to create a list of all fields for one record? I need to be able to search the list for specific values later. __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! __ 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
Query for specified month
I need to query a database for records based on month. I have a date field, and I tried the following two ways: WHERE DatePart("m", rundate) = #cnt and I tried WHERE Month(rundate) = #cnt# #cnt is a variable that gets incremented. I keep getting errors that say DatePart and Month are Invalid Operators. Any ideas on how to do this? __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! __ 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=coldfusiona 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
How to start on a two-week calendar?
I have conference call database. I'd like to have a web page that presents a two-week view of upcoming conference calls. It will show the curent week, Monday-Friday, and the next week, Monday-Friday, with the title of each conference call hyperlinked to the conference call information. The user will also be able to view the next two weeks, or the previous two weeks. How do I start with the calendar? I'm not sure how to get it to show the current week and the next week, then provide the Next and Previous functions. Can anyone get me pointed in the right direction? I know there are calendar custom tags out there, and have no problem using one that does what I need it to, if someone can recommend one. But rather than picking through a custome tag to get it to work for me, I think I'd rather get some practice in building one from scratch. Thanks. Tim - Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices ~~ 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
database sorting
I have a conference database with a text field for time. The times are entered in 12 hour time with am or pm (ex., 9:00 am or 2:00 pm). Is there a way to sort this field to list the conferences in order by time? The problem I see, is 2 comes before 9, so the above example will list the 2:00 pm time before the 9:00 am time. I'd like to do this without changing the actual database if possible. The code I use to list the times is (it displys a table with the current weeks worth of conferences): #dateformat(dateadd("d", i, url.startdate), "ddd, mmm d")# SELECT ID, conf_name, begin_time, conf_date FROM data WHERE conf_date = #createodbcdate(dateadd("d", i, url.startdate))# ORDER BY begin_time #qGetDates.begin_time# #qGetDates.conf_name# This works, except that the conferences are listed in the order they are in the database, not time order. Thanks, Tim ~~ 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
searching date ranges
I have a database with fields called facility, rcvd_date and audit_date. I need to query the database for a user selected facility with a rcvd_date that is greater than 90 days old and the audit_date field is blank. For instance, the user selects Atlanta, and the query will return all records for Atlanta, where the rcvd_date is older than 90 days from the current date, and the audit_date field is blank. So, if a record for Atlanta has a rcvd_date of 05/01/2001, it would not be returned, but one with a date of 02/01/2001 would. I have the facility portion done, but can not figure out how to search the rcvd_date field to check the records with dates 90 days old or more. Any ideas? Tim ~~ 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
WHERE statement with multiple ANDs
I am a little confused as to how to code a WHERE statement that has more than one qualifier. See this code: SELECT Location, Date_rcvd, status, Certificate_Number FROM 39_TRACKING WHERE Location = '#form.location#' AND status = '#form.status#" AND date_rcvd> #DateFormat(CreateODBCDate(Form.firstdate), 'm/d/')# AND date_rcvd < #DateFormat(CreateODBCDate(Form.seconddate), 'm/d/')# Group Bylocation, date_rcvd, status, certificate_number The queary does not work. Do I need to use parentheses in a WHERE statement with a number of AND's? Is it even a good idea to use this many AND's or is there another way I should be doing this? Tim ~~ 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
passing year value into cfswitch
The code below works, except for one thing...passing the year value via DatePart. If I remove that, and put a year, like 1999 or 2000, the whole cfswitch works and does what it is supposed to. But it won't read the date from DatePart, it goes to the cfdefaultcase. I also tried YEAR(qGetTimes.cert_issue_date), but that did not work either. No work done Any ideas on how to pass the year values into the cfswitch? Is there an easier way I should be doing this? ~~ 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
Two database query questions
First, is there a way to NOT require an entry for a date field? I have a access database with a date/time field, but the date field is not required, and quite often is not initally entered. But leaving the date field blank gives me errors. Is there a way around this? Second, is there a way to make a password field fill in with asterics (*) instead of letters? My password field shows the password as it is typed, not very secure. Thanks, Tim ~~ 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
Aggregate functions (AVG())
I have a simple query that includes the AVG() function to average some fields. The code is: SELECT overall, AVG(overall) AS OAvg, needs, AVG(needs) as NAvg, tech, AVG(tech) AS TAvg, equipment, AVG(equipment) AS EAvg, software, AVG(software) AS SAvg, location FROM main WHERE (location = 'Atlanta') GROUP BYlocation, overall, needs, tech, equipment, software Results for Atlanta; number of responses: #qGetAtlanta.RecordCount# Overall Rating of IT, #qGetAtlanta.OAvg# Overall rating of IT support, #qGetAtlanta.NAvg# Technical capability, #qGetAtlanta.tavg# Equipment availability, #qGetAlanta.eavg# Software availability, #qGetAlanta.savg# However, it is not outputting the average of each field. It returns the correct number od records, 4, but appears to just output the value in each field of the first record. The four records have field values of 2, 3, 1, 4, 5; 5, 4, 3, 5, 4; 2, 4, 3, 2, 1; and 5, 5, 5, 5, 5. The output is returning values of 2, 3, 1, 4 and 5, the values of the first record's fields. They should be 3.5, 4.0, 3.0, 4.0 and 3.75. Any ideas? ~~ 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
Getting entire text box from database to show in form.
I have a database with a text field set at 255 characters. When I query the datasource and return that field to a form to be viewed, the data is truncated. The form field is set up as: , and the code to return the data is: #qGetAll.Other#. How do I present all the data in that field? ~~ 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
how to perform a variety of searches on a database
I have an access database. The users would like to be able to search on any one of the fields. Plus, they would like to search on the fields within a date range, and have one of the fields added up when the results are shown. For example, a user will search the location field for a specific location during the the month of January. The results will show all records with the searched location for that month, and the bottom of the list will have totaled up the manhours for the records returned. My first instict was to build a seperate query statement for each field to search. It will check if the field id blank, and if not, perform the search. However, I get the followinf error. HTTP Error 405 405 Method Not Allowed The method specified in the Request Line is not allowed for the resource identified by the request. Please ensure that you have the proper MIME type set up for the resource you are requesting. Please contact the server's administrator if this problem persists. Any guidance? I can send code to those who want to see it. Thanks. ~~ 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
see a problem with this code?
I have a pre-filled form for users to change a record. The form calls an action page to update the record. I keep getting the dreaded error: Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. I have looked backward and forward, checked spelling, quotes, etc., and can't figure out the problem. I figureed it was time for a new set of eyes. Is there something about this that I am missing: UPDATE data SET conf_name = '#Form.conf_name#', conf_purpose = '#Form.conf_purpose#', conf_date = #Form.conf_date#, occurance = '#Form.occurance#', begin_time = '#Form.begin_time#', end_time = '#Form.end_time#', mod_name = '#Form.mod_name#', mod_phone = '#Form.mod_phone#', mod_station = '#Form.mod_station#', poc_name = '#Form.poc_name#', poc_phone = '#Form.poc_phone#', poc_station = '#Form.poc_station#', facilities = '#Form.facilities#', comments = '#Form.comments#', WHERE ID = #Form.ID# I can add and view records in the database. ~~ 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
database connections in Studio
I used to not have these problems, and it seems like they just started occuring since I added the upgrade to version 4.5.2 from CF Server 5.0. When I select the database tab in the Resources section of Studio's window and try to expand the tables of an access database, I get an error that reads "access violation at address 00617D40 in module 'cfstudio45.exe'. read of address ." It then just sits there and say "retrieving tables", but never does anything. Also, I have a remote SQL server, and when I try to connect to that, nothing happens at all. Once in a while I get an error that reads "unknown internal error in RDS proxy. Enable logging if possible". All these daabases are entered in as ODBC datasources and DO verify via CF Administrator. My CF pages that query these databases also do work. Any help would be greatly appreciated. Tim ~~ 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: database connections in Studio
> Get the Studio 5 beta 2. Much, *much* better than 4.5... I can't find any reference to CF Studio 5 at the Macromedia web site. Did you confuse this with UltraDev Studio? ~~ 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
problems querying a query
I am trying to query the results of a query against SQL server and am getting errors. The first query I am running is: SELECT CertificateID, AuditDate, WasVetTopOfCert FROM dbo.tblDEUCertificates WHERE AuditDate IS NOT NULL The second query is: SELECT WasVetTopOfCert FROM qGetFour WHERE WasVetTopOfCert IS NOT NULL The error I get is: Error Diagnostic Information Query Manipulation Error Code = 0 Invalid Operator WasVetTopOfCert SQL = "SELECT WasVetTopOfCert FROM qGetFour WHERE WasVetTopOfCert IS NOT NULL" Data Source = "" Query qgetFour runs ok. WasVetTopOfCert is a bit field set to accept nulls. I have a feeling the problem is in the I check the a bit field for null values. Any ideas? Tim ~~ 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 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: Compensating for Server Time
If you want to it directly from SQL you can create a function and call that from your sql query create function localtime (@gmtdate datetime, @timezoneoffset int) returns datetime As begin declare @localtime datetime select @localtime = dateadd(hh, -1 * @timezoneoffset, @gmtdate) return @localtime end Then it can be called like this select localtime(getdate(), 3) Tim -Original Message- From: cf-talk [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 4:54 PM To: CF-Talk Subject: RE: Compensating for Server Time Does that work in SQL 2000? I've always used _javascript_ at logon to determine the time zone of the user's computer. I then store the time zone offset in a cookie or session/client variable. I then use a UDF to convert the time from the SQL server to that user's local time. If there was a way to do this all in one single shot via SQL as it seems you have a solution for below I'd love to try it out. Unfortunately I can't seem to make the example you gave below work in SQL 2000. -Novak -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 12:55 PM To: CF-Talk Subject: Re: Compensating for Server Time Chris Montgomery wrote: > > What's the best way to compensate for time on a server in a hosted > environment when the time is set to a different time than a user's local > time zone? Ex: client is in Central Time, server is on Eastern Time (one > hour ahead); client wants everything to reflect local time. I use the AT TIME ZONE functionality from SQL, it even compensates for daylight savings time: testDB=> select '2003-12-31 12:00:00' AT TIME ZONE 'cet'; timezone - 2003-12-12 12:00:00 testDB=> select '2003-07-31 12:00:00' AT TIME ZONE 'cet'; timezone - 2003-06-12 11:00:00 Jochem -- Who needs virtual reality if you can just dream? - Loesje _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Compensating for Server Time
Yes you can detect their time zone everytime they login or what I've done in the past is to build it in to the users profile, so that the user has the ability to select the time zone their in when they create/update their profile. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 5:38 PM To: CF-Talk Subject: RE: Compensating for Server Time but how are you going to *KNOW* the persons local time? _javascript_ is the only way. -Original Message- From: Tim [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 5:35 PM To: CF-Talk Subject: RE: Compensating for Server Time If you want to it directly from SQL you can create a function and call that from your sql query create function localtime (@gmtdate datetime, @timezoneoffset int) returns datetime As begin declare @localtime datetime select @localtime = dateadd(hh, -1 * @timezoneoffset, @gmtdate) return @localtime end Then it can be called like this select localtime(getdate(), 3) Tim -Original Message- From: cf-talk [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 4:54 PM To: CF-Talk Subject: RE: Compensating for Server Time Does that work in SQL 2000? I've always used _javascript_ at logon to determine the time zone of the user's computer. I then store the time zone offset in a cookie or session/client variable. I then use a UDF to convert the time from the SQL server to that user's local time. If there was a way to do this all in one single shot via SQL as it seems you have a solution for below I'd love to try it out. Unfortunately I can't seem to make the example you gave below work in SQL 2000. -Novak -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 12:55 PM To: CF-Talk Subject: Re: Compensating for Server Time Chris Montgomery wrote: > > What's the best way to compensate for time on a server in a hosted > environment when the time is set to a different time than a user's local > time zone? Ex: client is in Central Time, server is on Eastern Time (one > hour ahead); client wants everything to reflect local time. I use the AT TIME ZONE functionality from SQL, it even compensates for daylight savings time: testDB=> select '2003-12-31 12:00:00' AT TIME ZONE 'cet'; timezone - 2003-12-12 12:00:00 testDB=> select '2003-07-31 12:00:00' AT TIME ZONE 'cet'; timezone - 2003-06-12 11:00:00 Jochem -- Who needs virtual reality if you can just dream? - Loesje _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
deactivating Enter key in forms
Is it possible to deactivate the Enter key in ? I have users that prematurely submit forms by accidentally hitting the Enter key, and I'd like to restrict form submission to the Submit button. __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! __ 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
manipulating Tab key in forms
Is it possible to manipulate the Tab key so that it only tabs between fields, and not to text in a form? I have form fields with pop-up hints for each field, but whem users hit Tab, it highlights the links. I need it to skip the links and tab to the next field. Thanks, Tim __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! __ 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
CF as a document manager?
Does anyone know of a simple, free, application or custome tag that will work as a document manager in CF? I need to allow users to view the contents of a folder and download/edit/upload documents. I'd really like to have sort of "checkout" feature that will let other users know a document has been downloaded by someone. Tim __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games __ 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=coldfusiona 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
Query a query by months
I am trying to query a query and process the records by month. My code is: SELECT * FROM qGetResults WHERE (Month(qGetResults.Rundate) = #cnt#) My problems are with the WHERE statement. If I do WHERE #Month(qGetResults.RunDate)# = #cnt#, it interprets the data as a variable (1 = 1, 1 = 2, etc) and retirns all records when true (1 = 1). If I leave the pound signs off, I get errors. __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games __ 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
Forms: submit via button and required fields not working
I have a form that I wanted to restrict so that the user has to hit the Submit button to enter the form, and not the Enter key. I included the following: This does work as far as resticting the Enter Key, but the Required attribute does not work now. The user does not get a message if a required field is left blank, and the form is acted upon, producing errors. If I take the above code out and insert a plain submit button, the Required attribute works, but not restricting the Enter key. Anyone have an idea on how to do both, restrict form submission only when the button is selected and checking for required fields? Tim - Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® __ 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
How to check form fields for content and modify?
I have a form that does not require all fields to be filled out. On the action page, I need to check the non-required fields for content, and if empty place "n/a" or a zero in the field before the record is added to the database. I tried using , but it does not seem to work. The code is: INSERT INTO data (Location, Requested, Service, TDate, Position, Extension, NDate, Format, PeriodicalTitle, Volume, Issue, Authors, Pages, Year, ArticleTitle, Source, NLM, Other, Status) Values ('#form.Location#', '#form.Requested#', '#Service#', '#TDate#', '#Position#', #form.Extension#, '#NDate#', '#form.Format#', '#form.PeriodicalTitle#', '#Volume#', '#Issue#', '#Authors#', #Pages#, #Year#, '#ArticleTitle#', '#Source#', '#NLM#', '#Other#', '#Status#') Any other ideas? ~~ 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
Windows Identity Framework (WIF) & CF 9
Can anyone point me to a good resource for integrating a cf 9 app with WIF. Thanks Tim ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334614 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfpdf and cffileupload
I've been working with these tags a lot lately and am currently finding them a little buggy. It works for the most part beautifully but it seems like once in a while when doing a merge, one or more of the merged pdf files get the error "insufficient data for an image". It's random as to which one since there are multiple files scanned and saved by same person in the same batch. I'm able to open the file w/ adobe reader 8 and 9 but when I do the merge to show as a package, a couple of files show the error. When I open the pdf in adobe 8 pro and re-save it as optimized pdf it works fine. So I tried optimizing the merged pdf (using cfpdf action="optimize") but that didn't work :( As with the cffileupload it works fine for everybody else but me since I'm using chrome. I get the "status code: 302" error. No biggie but just a little annoying. Any insight would be greatly appreciated. Thanks, Tim ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336411 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Using a CSV as a datasource (CF8)
I have a badge reader that hangs on the network. It collects magnetic stripe scans to a CSV file located on the server. I need to get this into a SQL Server db ideally. I created the ODBC text data source on the server. When I attempt to add the data source in the ColdFusion administrator, it tells me: Connection verification failed for data source: BadgeScanner java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Text Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Text Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. I suspect my connection string for the data source in the administrator needs to be populated. Right now it is blank. Can anyone tell me what the connection string should look like... or any ideas on how to get these scans (occurring all day every day) into my database? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337232 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Gateway / Telnet Resources
I have searched the web so much that Google wants to put me on the payroll. I am looking for a great tutorial on Gateways / Telnet for an application I am building. I am using CF8 in a Windows environment. I am a complete newbie with Gateways, and the information I am finding in the docs is amazingly lacking. Is it me, or is there truly a dearth of information out there? Can anyone point me in the right direction? I need to monitor a device at a given IP address (it is a magnetic stripe badge reader hanging on the network, no PC). When a scan is detected, I want to send the data into my database and send a command back to the badge reader triggering the indicator light. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337310 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Using a CSV as a datasource (CF8)
To get this to work, I had to do something really hokey. I created an Access database, and used a linked table to the actual text file. Works great. And no, I am not proud of this solution... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337414 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Gateway / Telnet Resources
Bueller? Bueller? I have everything set up in the administrator, but nothing ever comes through. When looking at the socket-gateway.log I spy the following: error attempting to listen on socket: java.net.socketException: socket closed I find this odd because when I review the ports in windows, 1070 specifically says "listening". This entry is logged whenever I start and stop the gateway instance in the ColdFusion administrator. The STATUS in the ColdFusion administrator says "RUNNING". Nothing ever shows up in the IN and OUT columns in the administrator. What can I do to ensure that the socket is opened, even though Windows insists that it is listening? > I have searched the web so much that Google wants to put me on the > payroll. I am looking for a great tutorial on Gateways / Telnet for an > application I am building. I am using CF8 in a Windows environment. I > am a complete newbie with Gateways, and the information I am finding > in the docs is amazingly lacking. Is it me, or is there truly a dearth > of information out there? Can anyone point me in the right direction? > I need to monitor a device at a given IP address (it is a magnetic > stripe badge reader hanging on the network, no PC). When a scan is > detected, I want to send the data into my database and send a command > back to the badge reader triggering the indicator light. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337518 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfdocument text cuts off at page break
I see quite a few posts on this bug but there seems to be only hot fixes for mx7 and 8, I'm on 9 so I figured it should've/would've been applied... The last line of the page gets cut off and the next page has the other half. I'm using cfsavecontent, building html and putting inside of cfdocument. Has anybody figured out how to fix this?? Thanks! Tim ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338175 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfdocument text cuts off at page break
Yes, all text are inside table w/ complete html tags. -Original Message- From: Rick Root [mailto:rick.r...@gmail.com] Sent: Thursday, October 14, 2010 9:37 AM To: cf-talk Subject: Re: cfdocument text cuts off at page break On Thu, Oct 14, 2010 at 11:24 AM, Tim Do wrote: > > I see quite a few posts on this bug but there seems to be only hot fixes for > mx7 and 8, I'm on 9 so I figured it should've/would've been applied... The > last line of the page gets cut off and the next page has the other half. I'm > using cfsavecontent, building html and putting inside of cfdocument. Has > anybody figured out how to fix this?? Is your text inside a table ce ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338179 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfdocument text cuts off at page break
hmmm, so I removed the marginbottom attribute and it seems to have fixed it. -Original Message- From: Tony Bentley [mailto:cascadefreehee...@gmail.com] Sent: Thursday, October 14, 2010 9:56 AM To: cf-talk Subject: Re: cfdocument text cuts off at page break Why didn't Adobe fix some of the simple needed changes in CF9 for cfdocument? I have no idea. Known issues that suck: -THEAD does not carry over on page break. The solution? Use cfreportbuilder (god help me). - Border collapse does not work. The solution? Write some really funky inline styles at the first row of the table, last row of the table and first/last td of each row. (How much has this cost our company?) -Table breaks in the middle of a row. No solution. (Shoot me) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338182 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfdocument text cuts off at page break
I'm currently using CF_HTML2PDF3 and it's quite old and hangs the server pretty often. Since cfdocument isn't working, what's everybody else using to convert to pdf? -Original Message- From: Bryan Stevenson [mailto:br...@electricedgesystems.com] Sent: Thursday, October 14, 2010 11:53 AM To: cf-talk Subject: RE: cfdocument text cuts off at page break Hey Tim, No you have fixed this one instance...trust me I know...I've battled that same thing. If the amount of text varies, you WILL see this again. Cheers On Thu, 2010-10-14 at 10:01 -0700, Tim Do wrote: > hmmm, so I removed the marginbottom attribute and it seems to have fixed it. Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: br...@electricedgesystems.com web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. Please consider the environment before printing this e-mail ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338188 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Report Builder
Report Builder is something that you, as a developer, would use to create the report. I do not consider it a valid end-user tool. > I want to give the users of my CF 8 site the ability to dynamically > generate reports. I've never used Report Builder before. Will > non-technical users be able to use this, or will something else be > better suited for them? > > Thanks, > Scott ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338807 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SpoolLockTimeoutException
An exception occurred when setting up mail server parameters. This exception was caused by: coldfusion.mail.MailSpooler$SpoolLockTimeoutException: A timeout occurred while waiting for the lock on the mail spool directory.. We've been getting this error recently and had to restart jrun to get it to start again. Reading that this is a common problem in versions 7/8 and can be fixed w/ hotfixes and even uninstalling latest updates but we're on 9 here. The worst thing about this is that users don't always tell you that the email alerts/reports didn't go out when they were supposed to, until it's a day or two later. I've had issues w/ the spooler piling up often, so I created a job to check the number of files in the spool directory and restart if it's greater than 20. But this latest error doesn't even add to the spool directory and emails don't go out even after a restart. Does anybody have any ideas/suggestions as to how to get notified as to when cfmail has choked? Whether it be from the spool directory being stuck or locked?? We send out so many emails throughout the day and night that it's impossible to check to see if every email was sent. Thanks! Tim ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338830 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
coldfusion standard edition version switched to developer edition?!
We just restarted the coldfusion server and now it's suddenly a developer edition on our live web server! I tried entering the coldfusion9 standard license in (in cfadmin) to update but it's asking for the old version's serial which I entered but it says the numbers don't match. Also, whats the update file box for? I left it blank and hit submit. PLEASE help! Thanks, Tim ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339373 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: coldfusion standard edition version switched to developer edition?!
I was able to find a key that matched. Server is back up now. Question is, how/why did the config file get set to developer edition... it was never installed as a developer edition to begin with. -Original Message- From: Mike Chabot [mailto:mcha...@gmail.com] Sent: Thursday, November 18, 2010 12:52 PM To: cf-talk Subject: Re: coldfusion standard edition version switched to developer edition?! The easiest thing to do would be to enter the CF8 standard serial number. That is what I would do in your situation. I wonder what caused it to happen. Maybe the config file got messed up. If you keep server backups you could restore your CF config files from backup. -Mike Chabot On Thu, Nov 18, 2010 at 3:36 PM, Tim Do wrote: > > We just restarted the coldfusion server and now it's suddenly a developer > edition on our live web server! I tried entering the coldfusion9 standard > license in (in cfadmin) to update but it's asking for the old version's > serial which I entered but it says the numbers don't match. Also, whats the > update file box for? I left it blank and hit submit. PLEASE help! > > Thanks, > Tim > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339378 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: coldfusion standard edition version switched to developer edition?!
It's been up for a while (around 6-8months?), and has been rebooted quite often I'd have to say... -Original Message- From: Ian Skinner [mailto:h...@ilsweb.com] Sent: Thursday, November 18, 2010 1:11 PM To: cf-talk Subject: Re: coldfusion standard edition version switched to developer edition?! On 11/18/2010 12:58 PM, Tim Do wrote: > I was able to find a key that matched. Server is back up now. Question is, > how/why did the config file get set to developer edition... it was never > installed as a developer edition to begin with. How long was the server running? If it was something around 1 month, could it have unintentionally been configured as a 'trial'. Those run for 30 days as a full server with only a few differences and then revert to a developer edition at the end of the trial. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339389 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
PDF printing issues
We're having a bit (HUGE) of a problem printing PDFs created by using cfdocument. We just updated our PDF generator to us CF instead of html2pdf. We are having many users complain that it takes 20-30 minutes to print out PDFs (20-25pgs). The file size itself is about 1mb so file size isn't the problem, although I did notice that the file size balloons up when in the queue, but I read its normal since PDF is compressed. It works on certain printers but not others, same make/model printers as well. We tried updating printer drivers on them but it would work on some but not all. Some of the printers are relatively new with newer drivers. So my question is.. is this a printer driver issue or is this an issue w/ how the PDFs are generated?? Anybody else having problems printer larger PDFs generated with cfdocument/cfpdf? Thanks, Tim ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340174 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: PDF printing issues
Thanks Mark... I used a couple of your suggestions to speed it up a bit. But the moment that I set the dpi from 600 to 300, bam! Pages printed beautifully. -Original Message- From: Mark A. Kruger [mailto:mkru...@cfwebtools.com] Sent: Monday, December 20, 2010 12:50 PM To: cf-talk Subject: RE: PDF printing issues Tim, There are many tips and tricks to optimizing your pdf generation. Most of them boil down to removing or streamlining the external resources needed. So, for example, if you use an exteneral CSS file, cfdocument has to... -Resolve the URL to the css file -"get" the CSS file via cfhttp -"render" the css into whatever is needed for pdf formatting using the rendering engine -Include the info in-line in the file. Multiply that times all images and external resources needed to produce the single file (unlike HTML everything must be "in" the file). If your PDF takes, say 25 images - that is 25 CF Threads to call those images etc. There are some ways around it and my blog has a lot of great documentation on this subject. http://www.coldfusionmuse.com Do a search for "cfdocument" and you'll get 4 or 5 articles and some tangential ones as well. -Mark Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Tim Do [mailto:t...@wng.com] Sent: Monday, December 20, 2010 2:05 PM To: cf-talk Subject: PDF printing issues We're having a bit (HUGE) of a problem printing PDFs created by using cfdocument. We just updated our PDF generator to us CF instead of html2pdf. We are having many users complain that it takes 20-30 minutes to print out PDFs (20-25pgs). The file size itself is about 1mb so file size isn't the problem, although I did notice that the file size balloons up when in the queue, but I read its normal since PDF is compressed. It works on certain printers but not others, same make/model printers as well. We tried updating printer drivers on them but it would work on some but not all. Some of the printers are relatively new with newer drivers. So my question is.. is this a printer driver issue or is this an issue w/ how the PDFs are generated?? Anybody else having problems printer larger PDFs generated with cfdocument/cfpdf? Thanks, Tim ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340187 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Strange occurrence
Correct me if I am wrong, but I thought it was possible to "hijack" a session if a user knew another users cfid and cftoken variables. I have seen users pages get "switched" if a user emails another user a url to a page with the cfid and cftoken in the url line (e.g http://mydomain.com/file.cfm?cfid=1234&cftoken=29282928) Would it be possible that the one user emailed the other user a link? I did have a lot of problems with session variables getting switched and with firewalls with CF 4 -- it has been a while and it could have been a locking issue at the time -- at any rate, there was a long thread in the CF forums about this and the only fix that I was able to come up with was to switch to client variables instead. You might want to search the cf forums, if the suggestions here didn't fix it for you. Tim P. - Original Message - From: "Mark A. Kruger - CFG" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, November 06, 2002 9:40 AM Subject: Strange occurrence > One of the guys in my user group works for a firm that is very concerned > with security. They recently ran across this situation. I've offered a > couple of possible explanations, but I'm interested in any other possible > explanation: > > > -he wrote--- > I had an occurrence today that was very strange. I have a CF 4.5.1 Server > running on NT 4.0 using IIS 4.0 with the latest service packs installed. My > site looks at an incoming request and if they don't already have session > variables set (cached via cookies for 48 hours) they are given a password > screen to log in with. > > Around 13:00 Central time today a remote user was attempting to log into the > site. His profile in our database did not have him authorized to log in and > he was denied access as expected. While speaking with our Service Desk who > was attempting to log in as him locally his remote display brought up a page > that would only have been displayed to the local Service Desk technician. > To the best of my knowledge, there was no password information passed to the > remote user (he still wasn't authorized at that point in our profile > database.) > > How could he possibly received a page from our server that belonged to our > internal technician? The remote user and the local tech are both situated > behind two different firewalls from the server. > I am at a total loss, and am hoping that someone may be able to shed some > light. > --- > > > I'm thinking he's not getting the full story from the help desk > > > Mark A. Kruger, MCSE, CFG > www.cfwebtools.com > www.necfug.com > mxc.blogspot.com > ..no more brochures! > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
Re: CSS2 and NetScape
I like http://www.blooberry.com -- it has a very nice css reference. Tim P. - Original Message - From: "Robert Polickoski" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, November 06, 2002 1:48 PM Subject: OT: CSS2 and NetScape > All, > > I apologize for t he off-topic post but I am having a terrible > time finding another resource. > > I have a site on which I am using a CSS2 style sheet (validated) > to format the content. IE6 displays it beautifully. NS messes it > up copmpletely. I think it is because NS hasn't implemented the > position attribute. Does anyone know of a good source of > information or support, preferably free? > > If curious, the site is http://www.buildacourse.com . > > Thank you, > Robert > > Robert J. Polickoski > Senior Programmer, ISRD Inc. > (540) 842-6339 > [EMAIL PROTECTED] > AIM - RobertJFP > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
help with output from 2 tables
I'm not sure if this is a database relationship/join question or a cf question, but here goes... I have an events database with 2 tables (categories and events). The categories table has 2 fields . "cat_no" (number) and "descr" (text) The events table has many fields including category1 and category2 (an event can have one OR two categories such as "board meeting" and/or "product shows"). Entries into the Category1 and Category2 fields are numbers that correspond to the cat_no field in the categories table. I'm struggling with getting an event with two categories to display those two category descriptions. it's no big deal to get the category numbers to show, but if I try to output the descriptions (descr field from the categories table) I only get the first description. the related code excerpt is below (I hope this makes some kinda sense) SELECT e.category1, e.category2, c.category_no, c.descr .etc. FROM events e, category c where (e.year=#year# or e.firstyear=#year#) and (e.category=c.cat_no or e.category2=c.cat_no) order by month, day category: #descr# Tim ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: help with output from 2 tables
Al... thanks for the response... I need to show my ignorance what is a mapping table? -Original Message- From: Everett, Al [mailto:AEverett@;askallied.com] Sent: Friday, November 08, 2002 8:27 AM To: CF-Talk Subject: RE: help with output from 2 tables The key, I believe, is to outer join your category table twice: SELECT e.category1, e.category2, c1.category_no as cat_no1, c1.descr as descr1, c2.category_no as cat_no2, c2.descr as descr2 FROM category c2 RIGHT OUTER JOIN events e ON c2.cat_no = e.category1 LEFT OUTER JOIN category c1 ON e.category2 = c1.cat_no where (e.year=#year# or e.firstyear=#year#) and (e.category1 is not null OR e.category2 is not null) order by month, day This should select all events that have one or both category columns defined. Then in your output, put in decision logic so you display the description if it exists (e.g., Len(Trim(findcal.descr1)) GT 0). Of course, it would have been better to use a mapping table between the two. If you get to more than two categories I strongly suggest it. > -Original Message- > From: Tim Laureska [mailto:hometeam@;goeaston.net] > Sent: Thursday, November 07, 2002 8:57 PM > To: CF-Talk > Subject: help with output from 2 tables > > > I'm not sure if this is a database relationship/join question or a cf > question, but here goes... I have an events database with 2 tables > (categories and events). > > The categories table has 2 fields . "cat_no" (number) and > "descr" (text) > > The events table has many fields including category1 and category2 (an > event can have one OR two categories such as "board meeting" and/or > "product shows"). Entries into the Category1 and Category2 fields are > numbers that correspond to the cat_no field in the categories table. > > I'm struggling with getting an event with two categories to display > those two category descriptions. it's no big deal to get the category > numbers to show, but if I try to output the descriptions (descr field > from the categories table) I only get the first description. > the related > code excerpt is below (I hope this makes some kinda sense) > > > SELECT e.category1, e.category2, c.category_no, c.descr .etc. > FROM events e, category c > where (e.year=#year# or e.firstyear=#year#) and > (e.category=c.cat_no or > e.category2=c.cat_no) > order by month, day > > > > category: #descr# > > > Tim > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
RE: help with output from 2 tables
This sounds very useful but where do you do this "relationship managing/table mapping"... is this done as part of a query? I have not a clue where to incorporate this into the code... I apologize.this is probably pretty basic stuff for most I quess Tim -Original Message- From: Everett, Al [mailto:AEverett@;askallied.com] Sent: Friday, November 08, 2002 10:06 AM To: CF-Talk Subject: RE: help with output from 2 tables It's a way to manage many-to-many relationships. One-to-many relationships are easy to manage with a foreign key in one table. Once you have to have more relationships (an event in more than one category, for instance) you have to start adding columns, which doesn't scale well. In your case, I would do something like this: Category Table category_id category_name . Event Table event_id event_name event_date . EventCategoryMap Table event_id category_id Then with simple inner joins from Category to EventCategoryMap and from Event to EventCategoryMap, I can get all events in a category, all categories for an event, or whatever I need. > -Original Message- > From: Tim Laureska [mailto:hometeam@;goeaston.net] > Sent: Friday, November 08, 2002 8:48 AM > To: CF-Talk > Subject: RE: help with output from 2 tables > > > Al... thanks for the response... I need to show my > ignorance what is > a mapping table? > > > -Original Message- > From: Everett, Al [mailto:AEverett@;askallied.com] > Sent: Friday, November 08, 2002 8:27 AM > To: CF-Talk > Subject: RE: help with output from 2 tables > > The key, I believe, is to outer join your category table twice: > > > SELECT e.category1, e.category2, c1.category_no as cat_no1, > c1.descr as > descr1, c2.category_no as cat_no2, c2.descr as descr2 > FROM > category c2 RIGHT OUTER JOIN > events e ON c2.cat_no = e.category1 LEFT OUTER JOIN > category c1 ON e.category2 = c1.cat_no > where > (e.year=#year# or e.firstyear=#year#) > and > (e.category1 is not null OR e.category2 is not null) > > order by month, day > > > This should select all events that have one or both category columns > defined. Then in your output, put in decision logic so you display the > description if it exists (e.g., Len(Trim(findcal.descr1)) GT 0). > > Of course, it would have been better to use a mapping table > between the > two. > If you get to more than two categories I strongly suggest it. > > > > > -Original Message- > > From: Tim Laureska [mailto:hometeam@;goeaston.net] > > Sent: Thursday, November 07, 2002 8:57 PM > > To: CF-Talk > > Subject: help with output from 2 tables > > > > > > I'm not sure if this is a database relationship/join > question or a cf > > question, but here goes... I have an events database with 2 tables > > (categories and events). > > > > The categories table has 2 fields . "cat_no" (number) and > > "descr" (text) > > > > The events table has many fields including category1 and > category2 (an > > event can have one OR two categories such as "board meeting" and/or > > "product shows"). Entries into the Category1 and Category2 > fields are > > numbers that correspond to the cat_no field in the categories table. > > > > I'm struggling with getting an event with two categories to display > > those two category descriptions. it's no big deal to get > the category > > numbers to show, but if I try to output the descriptions > (descr field > > from the categories table) I only get the first description. > > the related > > code excerpt is below (I hope this makes some kinda sense) > > > > > > SELECT e.category1, e.category2, c.category_no, c.descr .etc. > > FROM events e, category c > > where (e.year=#year# or e.firstyear=#year#) and > > (e.category=c.cat_no or > > e.category2=c.cat_no) > > order by month, day > > > > > > > > category: #descr# > > > > > > Tim > > > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: help with output from 2 tables
Tony... I saw the one with the CFloop example (and thank you)... I want to play with that example, but was curious about/intrigued by this "mapping" I have a basic understanding of relational databases, but not much experience yet ... I've played a small bit with relationships between two tables, but have never dealt with mapping -Original Message- From: Tony Weeg [mailto:tony@;navtrak.net] Sent: Friday, November 08, 2002 3:19 PM To: CF-Talk Subject: RE: help with output from 2 tables tim, hi there. well, first of all, Many-To-Many and Many-To-One relationships are theories, and practices of database design and construction, its about how you relate tables, rows etc ie. if I have a Single table with Categories and Id's for those categories, then I have another table with Many different products, all with different categories, some in the same category etc...then I have a one to many relationship between cats/products, one cat-many productsetc. did you see my email with a sample query/table structure to display a database setup like you have? .tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Tim Laureska [mailto:hometeam@;goeaston.net] Sent: Friday, November 08, 2002 3:15 PM To: CF-Talk Subject: RE: help with output from 2 tables This sounds very useful but where do you do this "relationship managing/table mapping"... is this done as part of a query? I have not a clue where to incorporate this into the code... I apologize.this is probably pretty basic stuff for most I quess Tim -Original Message- From: Everett, Al [mailto:AEverett@;askallied.com] Sent: Friday, November 08, 2002 10:06 AM To: CF-Talk Subject: RE: help with output from 2 tables It's a way to manage many-to-many relationships. One-to-many relationships are easy to manage with a foreign key in one table. Once you have to have more relationships (an event in more than one category, for instance) you have to start adding columns, which doesn't scale well. In your case, I would do something like this: Category Table category_id category_name . Event Table event_id event_name event_date . EventCategoryMap Table event_id category_id Then with simple inner joins from Category to EventCategoryMap and from Event to EventCategoryMap, I can get all events in a category, all categories for an event, or whatever I need. > -Original Message- > From: Tim Laureska [mailto:hometeam@;goeaston.net] > Sent: Friday, November 08, 2002 8:48 AM > To: CF-Talk > Subject: RE: help with output from 2 tables > > > Al... thanks for the response... I need to show my > ignorance what is > a mapping table? > > > -Original Message- > From: Everett, Al [mailto:AEverett@;askallied.com] > Sent: Friday, November 08, 2002 8:27 AM > To: CF-Talk > Subject: RE: help with output from 2 tables > > The key, I believe, is to outer join your category table twice: > > > SELECT e.category1, e.category2, c1.category_no as cat_no1, > c1.descr as > descr1, c2.category_no as cat_no2, c2.descr as descr2 > FROM > category c2 RIGHT OUTER JOIN > events e ON c2.cat_no = e.category1 LEFT OUTER JOIN > category c1 ON e.category2 = c1.cat_no > where > (e.year=#year# or e.firstyear=#year#) > and > (e.category1 is not null OR e.category2 is not null) > > order by month, day > > > This should select all events that have one or both category columns > defined. Then in your output, put in decision logic so you display the > description if it exists (e.g., Len(Trim(findcal.descr1)) GT 0). > > Of course, it would have been better to use a mapping table > between the > two. > If you get to more than two categories I strongly suggest it. > > > > > -Original Message- > > From: Tim Laureska [mailto:hometeam@;goeaston.net] > > Sent: Thursday, November 07, 2002 8:57 PM > > To: CF-Talk > > Subject: help with output from 2 tables > > > > > > I'm not sure if this is a database relationship/join > question or a cf > > question, but here goes... I have an events database with 2 tables > > (categories and events). > > > > The categories table has 2 fields . "cat_no" (number) and > > "descr" (text) > > > > The events table has many fields including category1 and > category2 (an > > event can have one OR two categories such as "board meeting" and/or > > "product shows"). Entries into the Category1 and Category2 > fields are > > numbers that correspond to the cat_no field in the categories table.
RE: help with output from 2 tables
Is there any recommended reference material on this? -Original Message- From: Tony Weeg [mailto:tony@;navtrak.net] Sent: Friday, November 08, 2002 3:19 PM To: CF-Talk Subject: RE: help with output from 2 tables tim, hi there. well, first of all, Many-To-Many and Many-To-One relationships are theories, and practices of database design and construction, its about how you relate tables, rows etc ie. if I have a Single table with Categories and Id's for those categories, then I have another table with Many different products, all with different categories, some in the same category etc...then I have a one to many relationship between cats/products, one cat-many productsetc. did you see my email with a sample query/table structure to display a database setup like you have? .tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Tim Laureska [mailto:hometeam@;goeaston.net] Sent: Friday, November 08, 2002 3:15 PM To: CF-Talk Subject: RE: help with output from 2 tables This sounds very useful but where do you do this "relationship managing/table mapping"... is this done as part of a query? I have not a clue where to incorporate this into the code... I apologize.this is probably pretty basic stuff for most I quess Tim -Original Message- From: Everett, Al [mailto:AEverett@;askallied.com] Sent: Friday, November 08, 2002 10:06 AM To: CF-Talk Subject: RE: help with output from 2 tables It's a way to manage many-to-many relationships. One-to-many relationships are easy to manage with a foreign key in one table. Once you have to have more relationships (an event in more than one category, for instance) you have to start adding columns, which doesn't scale well. In your case, I would do something like this: Category Table category_id category_name . Event Table event_id event_name event_date . EventCategoryMap Table event_id category_id Then with simple inner joins from Category to EventCategoryMap and from Event to EventCategoryMap, I can get all events in a category, all categories for an event, or whatever I need. > -Original Message- > From: Tim Laureska [mailto:hometeam@;goeaston.net] > Sent: Friday, November 08, 2002 8:48 AM > To: CF-Talk > Subject: RE: help with output from 2 tables > > > Al... thanks for the response... I need to show my > ignorance what is > a mapping table? > > > -Original Message- > From: Everett, Al [mailto:AEverett@;askallied.com] > Sent: Friday, November 08, 2002 8:27 AM > To: CF-Talk > Subject: RE: help with output from 2 tables > > The key, I believe, is to outer join your category table twice: > > > SELECT e.category1, e.category2, c1.category_no as cat_no1, > c1.descr as > descr1, c2.category_no as cat_no2, c2.descr as descr2 > FROM > category c2 RIGHT OUTER JOIN > events e ON c2.cat_no = e.category1 LEFT OUTER JOIN > category c1 ON e.category2 = c1.cat_no > where > (e.year=#year# or e.firstyear=#year#) > and > (e.category1 is not null OR e.category2 is not null) > > order by month, day > > > This should select all events that have one or both category columns > defined. Then in your output, put in decision logic so you display the > description if it exists (e.g., Len(Trim(findcal.descr1)) GT 0). > > Of course, it would have been better to use a mapping table > between the > two. > If you get to more than two categories I strongly suggest it. > > > > > -Original Message- > > From: Tim Laureska [mailto:hometeam@;goeaston.net] > > Sent: Thursday, November 07, 2002 8:57 PM > > To: CF-Talk > > Subject: help with output from 2 tables > > > > > > I'm not sure if this is a database relationship/join > question or a cf > > question, but here goes... I have an events database with 2 tables > > (categories and events). > > > > The categories table has 2 fields . "cat_no" (number) and > > "descr" (text) > > > > The events table has many fields including category1 and > category2 (an > > event can have one OR two categories such as "board meeting" and/or > > "product shows"). Entries into the Category1 and Category2 > fields are > > numbers that correspond to the cat_no field in the categories table. > > > > I'm struggling with getting an event with two categories to display > > those two category descriptions. it's no big deal to get > the category > > numbers to show, but if I try to output the descriptions > (descr field > > from t
Re: Locked Out
> > output="temp"> > output="request.application"> > > > > (4) Add the following to onrequestend.cfm: > > > output="temp"> > output="application"> > > Roger, Just curious -- what is the purpose of serializing/deserializing it into wddx and back to CF? Couldn't you just use ? (with the proper locking of course) Tim P. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
Re: Browser Printing Question
- Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, November 11, 2002 10:31 AM Subject: Browser Printing Question > When printing from a browser is there anyway to disable the printer to not print the url and path at the bottom of the page? > You might want to look at ScriptX from MeadCo -- they have an activex control that lets you control the formatting.. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
Re: WDDX / Missing Struct Keys & CFMX
Brook, I just ran into this last night. I was trying to serialize the Form structure into a wddx packet and saving that, but it would only save 10 fields maximum. To get around it -- I copied the from structure to a tmp variable and then serialized the tmp var instead of form and that seemed to work and get all the variables. HTH, Tim P. - Original Message - From: "Brook Davies" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, November 11, 2002 2:35 PM Subject: WDDX / Missing Struct Keys & CFMX > Hello, > I have a structure that I am converting to WDDX and then storing in a DB. > Upon retrieving it, the structure is missing several keys. I ran this test: > > > > > > > > > > > > > And this results in a struct with about 50% less keys that the original?! I > can not see any commonalities between the missing struct keys. Its seems to > skip 1 and then 2 at a time. > > One other thing I just noticed is that the resulting WDDX Structure > contains a max of 10 struct keys. Each time I refresh the page, the > resulting WDDX structure has a max of ten, apparently random keys from the > original struct. > > Anybody familiar with this? > > Brook Davies > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
basic question
Is it possible to do something like this to pass multiple variables thru a link, because it doesn't work and I'm wondering if its just an easy syntax Problem: listing page Tim ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
RE: basic question
Thanks Dan and Howie for some reason, using "&" worked but "&or" didn't -Original Message- From: Howie Hamlin [mailto:howie@;coolfusion.com] Sent: Monday, November 11, 2002 8:22 PM To: CF-Talk Subject: Re: basic question Sure, try: listing page HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server >>> Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: "Tim Laureska" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, November 11, 2002 8:09 PM Subject: basic question > Is it possible to do something like this to pass multiple variables thru > a link, because it doesn't work and I'm wondering if its just an easy > syntax Problem: > > listing page > > Tim > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
RE: basic question
Browser is IE6.0 -Original Message- From: Adam Reynolds [mailto:adam@;craze.co.uk] Sent: Tuesday, November 12, 2002 4:41 AM To: CF-Talk Subject: RE: basic question Your browser might be interpreting &or as a character (like ). This has happened to me in the past with specific versions of browsers > -Original Message- > From: Tim Laureska [mailto:hometeam@;goeaston.net] > Sent: 12 November 2002 02:05 > To: CF-Talk > Subject: RE: basic question > > > Thanks Dan and Howie for some reason, using "&" worked but "&or" > didn't > > -Original Message- > From: Howie Hamlin [mailto:howie@;coolfusion.com] > Sent: Monday, November 11, 2002 8:22 PM > To: CF-Talk > Subject: Re: basic question > > Sure, try: > > listing page > > HTH, > > -- > Howie Hamlin - inFusion Project Manager > On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 > inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server > >>> Find out how iMS Stacks up to the competition: > http://www.coolfusion.com/imssecomparison.cfm > > - Original Message - > From: "Tim Laureska" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, November 11, 2002 8:09 PM > Subject: basic question > > > > Is it possible to do something like this to pass multiple variables > thru > > a link, because it doesn't work and I'm wondering if its just an easy > > syntax Problem: > > > > listing page > > > > Tim > > > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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.
Re: IIS Administration
- Original Message - From: "Michael Ross" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, November 13, 2002 10:52 AM Subject: IIS Administration > I need some help. Our end goal is to have users that are able to access IIS and create sites, edit sites all that fun stuff without being server administrators. So far we set up all the users and made them power users and granted operator so they can see the IIS stuff. But they are still unable to do anything serious in IIS.Can anyone point me in the right direction to do this. > > Thanks > > Mike Mike, Try http://www.intrafoundation.com/ihtk.html -- there is a number of cfx tags that will let you control IIS, nt users, etc. I have not used it, but I have heard it works well. There may be other things like this on the tag gallery, too. Tim P. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
RE: Training Recommendations
I've taken a few courses at Learning Tree .. not web developer stuff but Windows 2000 networking/security ... and man, they blitz through the info and you can only absorb a small piece... my impression is they assume a higher level of knowledge than what they're advertised prereq's say.. I'm looking into on-line courses thru University of Maryland for similar stuff ... to go at a slower more effective pace -Original Message- From: Kamie Curfman [mailto:kbcurfman@;yahoo.com] Sent: Wednesday, November 13, 2002 12:18 PM To: CF-Talk Subject: Training Recommendations My company currently is taking training requests for next year. I've been working with CF and SQL Server for over three years now and although I could always stand to improve in these areas, I'm also looking to branch out. In particular, I think I need to get my feet wet in Java and XML. I don't have an OO background and, thus, was eyeing the Java for Web Developers classes being offered by Figleaf and Hal Helms. For the XML stuff I've been looking mostly at Learning Tree. Any other thoughts out there? I live/work in the DC area and I think my company would prefer local training (they didn't buy the whole "I need to go to Vegas" for Hal's upcoming class). I just spoke with a Figleaf person and have a sense of what they offer. Anything else I should consider? Thanks in advance. Kamie = Kamie Curfman, Web Developer, FGM Inc. 45245 Business Court, Suite 400 Dulles, VA 20166 http://www.fgm.com __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
CF Studio codesweeper ?
I have CF Studio and just selected code sweeper to format the code...I tried a test template and created a sample table to see how it works. codesweeper is configured for table rows and table data to be indented (tabbed) but it ain't happening... is there something special you have to do to trigger codesweeper to format the code (autoformat?) Thanks in Advance Tim Laureska 1st-String Technologies 443-496-1261 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: OT JS Help
if (parseInt(document.form.Date1.value) > parseInt(document.form.Date2.value)) { alert("Date1 must be before the Date2!") document.form.Date1.focus() return false; } -Original Message- From: Tipton Josh (orl1jdt) [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 10:32 AM To: CF-Talk Subject: OT JS Help I have a set date already and I want to make sure that the date entered is not higher than the current set date and if so then a warning would show. In my reasearch js kind of bites when it comes to dates so I need some help. In short I want to make sure that date1 !> an entered form value. Thanks, Joshua Tipton ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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.
RE: OT: Limiting functionality to individual PC's
What if they're not static and you're using DHCP? -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 23, 2002 2:25 PM To: CF-Talk Subject: Re: OT: Limiting functionality to individual PC's > I am looking to lock down certain types of access to > particular machines. I > was thinking about using cookies to tag the approved PC's. > How easy is it > for a User to copy a cookie from 1 PC to another? > Anyone have alternative methods that they've used? > Thanks, > Andy I wouldn't expect it to be particularly difficult... If the given machines are on your local network ( intranet application ) and your network uses static IP addresses internally, you can associate the static IP address of any given machine on your network with a desired feature using the #cgi.remote_addr# variable. hth s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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.
CFCONTENT Problem with PDF Files
Hello, I am trying to send a PDF to the user so it loads in their browser window. The code I am using is: Note: I also tried a content-type of "x-application/pdf" but that didn't work either. IE 5.5 SP2 just loads the PDF as plain text but Netscape 7.0 works fine and opens the Acrobat Plugin in the browser. I also tried using CFFILE to readBinary the file from the server but wasn't able to output/open the file because the binary stored in the variable could not be converted to a string. Here is the code I tried to get that to work: #variables.test# Has anyone had any luck with CFCONTENT and PDF files, especially in IE 5.5 SP2? My environment is: Windows 2000 Professional SP3, ColdFusion MX 6,0,0,48097 (Developer version), IIS 5.0. Thanks in advance. Tim Haak [EMAIL PROTECTED]
RE: Another Newbie Problem
Rick... I'm relatively new to CF myself, but managed to develop a calendar app that does among other things, the two variable query you reference... keep in mind, the solutions are not always "laid out" nicely to see In the situation you reference (the month/year scenario), I set up a database that includes numeric fields for each of the year and month. I set up drop down lists to pass the variables to a query template (as you indicate), then do a query on them ... something like SELECT * FROM events e, category c where (e.firstmonth=#firstmonth# and e.firstyear=#firstyear#) and (e.category=c.cat_no or e.category2=c.cat_no order by event_no, firstyear check out http://208.249.126.159/calendar/webcalendar_first.cfm T -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 6:31 AM To: CF-Talk Subject: Another Newbie Problem In all my cfm references I cannot find a single example of a common task, although you see this kind of thing being used everywhere. What I want to do is select from a pair of drop down lists (like Month and Year) and then display only the records from November 2002, for instance. How do you pass just those two variables to a query and draw just the date and month from a standard db date/time string. Is it a datepart function? I just don't get it. Any insight or pointing toward a tutorial would be appreciated. humbled by cfm yet again Rick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
CFerror
This must be easy but. if I have reference to an error display page in the application.cfm file such as: how can I get an email sent to the administrator with the error details? I tried putting a CFMail tag in the error_page.cfm file, but that doesn't do it Tim Laureska ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
cferror
This must be easy but. if I have reference to an error display page in the application.cfm file such as: how can I get an email sent to the administrator with the error details? I tried putting a CFMail tag in the error_page.cfm file, but that doesn't do it Tim Laureska ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
OT sql order by
hello... I have a varchar field in sql2000 that I use as unit #'s for apts. They can enter as "1,2,3a,4b,10". I would like to order that by the unit number, but since its a varchar, it comes out "1,10,2,3a,4b". How would I order it like this: 1,2,3a,4b,10 TIA ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
error messages not showing up
Hello, I've been getting some errors lately with no error message, the debug queries shows up but not the error message. Any ideas? TIA ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: OT sql order by
it works if the units are numeric.. but if the units are alphanumeric.. the ListSort(UnitsBenefittedList,"numeric") doesn't work... -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 10:12 AM To: CF-Talk Subject: RE: OT sql order by How would you use the cf-side sorted list within a SELECT statement to return the records in the proper order? Matthew P. Smith Web Developer, Object Oriented Naval Education & Training Professional Development & Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 10:22 AM To: CF-Talk Subject: Re: OT sql order by FYIthat function would be used after the data is retrieved. If you want to get it out of the DB in the proper order, use that function to sort the list before you insert it into the DB. 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: "Bryan Stevenson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, December 17, 2002 8:15 AM Subject: Re: OT sql order by > ListSort(YourField,"numeric") > > 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: "Tim Do" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, December 17, 2002 8:04 AM > Subject: OT sql order by > > > > hello... > > I have a varchar field in sql2000 that I use as unit #'s for apts. They > can > > enter as "1,2,3a,4b,10". I would like to order that by the unit number, > but > > since its a varchar, it comes out "1,10,2,3a,4b". How would I order it > like > > this: 1,2,3a,4b,10 > > > > TIA > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
RE: cferror
First, a thanks to those who replied to my initial question about CFERROR I thought it might be useful to share what I finally came up with Using Scott Brady's initial suggestion for using two error template references in the application.cfm file (exception and request). The templates are as follows... these seem to work fine in testing and may be pretty basic, but I learned a fair amount from the exercise APPLICATION.CFM file: ERROR_ADMIN.cfm: (file to send message to web page developer/admin) Error Date/Time: #DateFormat(Now())# at #TimeFormat(Now(),"h:m tt")# Viewers Browser: #http_user_agent# Page error was generated: #error.template# URL Query string of Client's request: #error.QueryString# #error.diagnostics# ERROR_PAGE.CFM (excerpt of page that viewer sees) We have logged the following information that will help us identify and correct the problem: Error occurred at #ERROR.Datetime# Your IP address is #ERROR.RemoteAddress# Your browser is #ERROR.Browser# You were trying to process #ERROR.Template#?#ERROR.QueryString# If you can provide us with any additional information that would help us fix this problem, please send E-Mail to: mailto:#ERROR.MailTo#";>#ERROR.MailTo#. Tim Laureska -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 8:26 AM To: CF-Talk Subject: RE: cferror Here's my notes on cferror types (CF 4.5 SP2, Solaris, Oracle 8i): Chris Norloff type="expression" - catches bad expression like "select * from m_job_summary where job_id=#doesnt_exist#" type="database" - catches bad SQL like "select * from m_job_summary GROUP ORDER BY" - catches invalid column like "select * from m_job_summary where doesnt_exist=10" type="missinginclude" - catches missing cfincluded files - catches missing cfmodule files. type="lock" - catches problem with lock, such as timing out while waiting to get exclusive access. type="any" Catches things not caught by a previous cfcatch statement. Example: - timeout error. Sometimes timeout error has type COM.ALLAIRE.COLDFUSION.REQUEST.TIMEOUT. Sometimes type is UNKNOWN and the message is Request timed out. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
RE: cferror
Rick... sorry I didn't respond sooner about your initial "blank screen .. I think that was the same problemquestion" -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 2:04 AM To: CF-Talk Subject: RE: cferror Thanks for the in-depth analysis, Mosh! Concerning this comment: "This is still valid with one caveat; you must put CFOUTPUT tags around any variables used in the request handler." I found that out when I followed your suggestion to the user display page from within the admin diagnostic page. I ended up putting this on the application.cfm: Then, from within the "error_admin.cfm" page, I put: I could send my mail using a custom tag to send the error info to my email, and have the "CFIncluded" error_user.cfm page display the error info to the user. (After putting the 's around message for error variables.) It's going to be great having these error messages show up in my email when a user has a problem. Now, I'll be able to call them right away, if needed, instead of waiting until they get frustrated and have to call me! Thanks again! Rick -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 12:55 AM To: CF-Talk Subject: RE: cferror Mosh Teitelbaum wrote: > ... there's no reason why you can't specify multiple CFERROR > TYPE="Exception" tags as in: > > > > > > I don't know what would happen though if you did the above and > also included an EXCEPTION="All". Would it catch everything, > ignoring the other tags, or would it catch everything not > specified in the other tags. Order might matter in this case (as > it does when declaring CFCATCH blocks). Dunno... if I have some > time tonight, I'll try to remember to test it out. So I did some testing and, for those that are interested, what follows is a summary of the findings and some items to note: ColdFusion lets you define multiple instances of the CFERROR tag. The two attributes we're concerned with here are TYPE and EXCEPTION. TYPE="Request" is something of a catch all declaration that will catch all exceptions not handled by other CFERROR instances and exceptions caused by other error handlers. TYPE="Exception" allows you to define handlers on a per exception basis using the EXCEPTION attribute which can specify the name of a single exception type or the word "Any" which, like TYPE="Request", catches all exceptions not handled by other instances of CFERROR. If you specify EXCEPTION="Any", than a TYPE="Request" is used only when an exception is generated in an error handler. That is, the EXCEPTION="Any" essentially relieves TYPE="Request" of it's role as a catch-all. EXCEPTION="Any" will only catch those exceptions not otherwise handled by other EXCEPTION="" definitions. So, with the following code: An Expression exception will be handled by expression.cfm but any OTHER type of exception will be handled by any.cfm. Order of declaration does not matter. As I mentioned above, when you declare EXCEPTION="Any", TYPE="Request" is only used to catch exceptions caused by an exception handler. Even if the type of exception thrown by the handler has a defined handler (for example, if the Expression handler in the above code causes a MissingInclude exception to be thrown) it will be handled by the Request handler, not the Exception handler. Finally, I had suggested earlier in the thread that, instead of maintaining multiple displays to inform the user that an error occurred, you can simply define it once -- in the Request handler -- and just include the request handler from your other handlers. This is still valid with one caveat; you must put CFOUTPUT tags around any variables used in the request handler. All exception handlers (including Request) can access several variables from the ERROR scope. However, the request handler is limited in that it cannot make use of CFML so, to output the variables from the ERROR scope, you simply escape them with pound signs, no CFOUTPUT needed. But, if the request handler is executed by way of inclusion from another exception handler, it will be executing in the "role" of a non-request handler, i.e., it needs CFOUTPUT. Because the request handler simply ignores CFML syntax, you can wrap the variables with CFOUTPUT tags and everyone is happy. So that's it. I hope this is helpful. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
debug code on top
I remember seeing this posted before but don't remember if it was ever answered. I get a couple of lines of debug code on top of my page once in a while. Anybody know why? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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.
RE: Crystal Reports Enterprise 8.5 ohhhh the pain
CR does set a cookie for each parameter, and i believe the max is 20. Passing it via url does cause cookie problems. What I do is use NT authentication for the login, Just make sure the crystal server is logged in as a user that the db has an account for. A problem that I ran across was subreports, when you use cross db joins, it will get confused with all the usernames and passwords, so I just used the same usernames and passwords. FYI, create a list and pass it in as one parameter and strip it apart in CR that way you won't run into the cookie problem. -Original Message- From: Sean McCarthy [mailto:[EMAIL PROTECTED]] Sent: Monday, December 23, 2002 9:10 AM To: CF-Talk Subject: RE: Crystal Reports Enterprise 8.5 o the pain No I am not passing the login and pass in the url. If you leave the params blank it uses the nt auth. Heres how I ended up getting it to work. http://mybox.box.com/crystal/enterprise/viewer/viewrpt.cwr?apsauthtype=secWi ndowsNT&id=204 If you have any other techniques for this please let me know. Thanks for your reply Sean -Original Message- From: Frank Mamone [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 21, 2002 9:03 AM To: CF-Talk Subject: Re: Crystal Reports Enterprise 8.5 o the pain Do you really want to pass the username and password in the URL? I'm not sure how you are trying to implement your reports, but if you give some details I may be able to help as we use reporting with CF/Crystal extensively. -Frank - Original Message - From: "Sean McCarthy" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, December 17, 2002 11:12 PM Subject: OT: Crystal Reports Enterprise 8.5 o the pain > Hi, > We are attempting to use Crystal Enterprise with windows auth. > Everything is configured according to the docs they have provided but > unfortunately the windows auth through iis works but the user is still > prompted with the login box for crystal enterprise. I can select 'nt auth' > from the crystal drop down enter no credentials and hit submit and it knows > who i am. I believe everything is working properly but crystal needs to > create some sort of cookie?through the submit from the crystal auth > screen. > > > How can I avoid this screen and just get directly to the report with my auth > information? I guess how can I create the cookie on the fly when accessing > the url for the report? Can I pass generic vars on the url to get it to > pass and create the cookie? > > This is the only link I have successfully gotten to work: > > http://servername/crystal/enterprise/admin/en/admin.cwr?action=logon&aps=aps > name&auth=secWindowsNT&usr=&pwd > > If I could do this when I call my report url that would be great. > > > Thanks for any input you might have > > > Sean > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
cferror
Hello all, I'm getting the error page when I do a js validation and alert. This is what I have for my cferror code: and here is my js code: alert('Sorry...\The APN Number you entered does not exists, Please Try again.'); window.history.go(-1); ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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.
RE:
This is just the advice I was looking for. Thanks Justin! Tim Bahlke, CIFO thinkcreate.com p. 336.230.0575 f. 336.230.0083 -Original Message- From: Justin v0.9 MacCarthy [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 22, 2000 3:12 PM To: [EMAIL PROTECTED] Subject: Re: Tim, you might want to combine CF and JavaScript for what you want to do. For example : SELECT Name FROM dB #name# Hope that helps ~JustinMacCarthy -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
URL parameter in a Frame
I ask for some advice on if this is the best way to pass a URL parameter to a nested frame. In application.cfm I have The frame cannot access the URL parameter directly so I though of this work around. Am I going to run into problems down the road if I do this? Thanks. Tim Bahlke, CIFO thinkcreate.com p. 336.230.0575 f. 336.230.0083 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Error Msg
Every once in a while, I get a message box that pops up in studio 4.5.1 saying "Canvas does not allow". I hit OK but it just keeps coming up. I have to cycle studio to work again. It seems to happen most when I come back to studio after looking at my page in the browser (IE). Anyone else getting this? -------- Tim Bahlke, CIFO thinkcreate.com p. 336.230.0575 f. 336.230.0083 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Security
We've been using advanced security for over 3 months and its been working perfectly. The user provides their NT login name and password and then they are given access rights to certain pages. Lately we've been having bugs with it. People who are supposed to have access aren't getting in. While some people are. Also, out NT passwords have recently been made to have certain characters in them that it did not have to have before. Can anyone tell me if someone has not changed their password to the meet the new criteria could that be causing the problems with the CF security? -Tim -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Browser Issue
Netscape 4.7 on PC cannot read my session variables. Netscape 4.* on Mac and IE both on PC and MAC are just fine. Is this a known issue, or just happening to me? I thought since CF was server side the browser or platform would not matter. Tim Bahlke, CIFO thinkcreate.com p. 336.230.0575 f. 336.230.0083 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Browser Issue
The problem was due to the fact that NN was setup not to accept cookies (which opens my eyes to a whole 'nother issue I need to address). Thanks to Dana and Anthony for pointing me in the right direction! ---- Tim Bahlke, CIFO thinkcreate.com p. 336.230.0575 f. 336.230.0083 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Advice needed on making arrays/structures persist
Folks, I have an application that presents its users with a page of survey questions -- a page that is built by a CF template that consults a database. As part of building the page, the template places data about each question it places on a page into a structure and then places that structure into an array. The questions are placed on the page inside a CFFORM. The action template for the form consults the array of structures to determine how to interpret the filled in answers to the questions. Until now (we are still in development), the array of structures has been kept in session scope variables. After each page of questions is processed by the action template, the array and its contained structures is reinitialized. There will never be more than about 15 questions on a page so it is easy to calculate the maximum memory usage for session variables. But now we have a scalability problem. I need to add features to allow the user to press the Back button to return to an earlier page and begin again from there. My (tentative) solution is to not reinitialize my array of structures but store each into a more overriding array of pages. Now I begin to worry about memory usage inherent in session scope variables and would like to switch to client scope variables stored in a database. But it appears that client variables must be scalar and can't be arrays or structures. Is that true? It doesn't explicitly say so in the Allaire manuals or the Forta books, but I got an error for CF when I tried to store an array into a client variable. If so, how can I get around it? Any advice will be appreciated. How do I make a fairly large amount of structured data persist for the life of a session without using up too much server memory? Thanks, for any light you can shed on this for me. -- Tim Dempsey -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
cf-talk@houseoffusion.com
I have never had luck getting cfmail to work. How does this look to y'all: Message When I process this page nothing happens, no email, no error, nothing, and nothing is showing up in the logs ... nothing Thanks ---- Tim Bahlke, CIFO thinkcreate.com p. 336.230.0575 f. 336.230.0083 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE:
I have switched to doing this, and I am receiving nothing. Tim Bahlke, CIFO thinkcreate.com p. 336.230.0575 f. 336.230.0083 -Original Message- From: David Shadovitz [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 13, 2000 12:28 AM To: [EMAIL PROTECTED] Subject: Re: Tim, Are you sure nothing is happening? I'd try using your own email address as the "To" field. -David On Wed, 12 Jul 2000 17:27:58 -0400 "Tim Bahlke" <[EMAIL PROTECTED]> writes: > I have never had luck getting cfmail to work. How does this look to > y'all: > > SUBJECT="Order > #URL.sessionid#" SERVER="server1.clicktex.com"> > > Message > > > > When I process this page nothing happens, no email, no error, > nothing, and > nothing is showing up in the logs ... nothing 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.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE:
I have looked in the Undeliverable Directory, nothing The connection to the server in CF Administrator has been verified I'm using a different server other then mine to send the emails. Could that be the problem ... do I need to send the message form the same server that the from address is associated with? ---- Tim Bahlke, CIFO thinkcreate.com p. 336.230.0575 f. 336.230.0083 -Original Message- From: Gordon Burns [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 13, 2000 1:18 AM To: [EMAIL PROTECTED] Subject: Re: Hi Tim, Have you looked in the Undelivered Directory? Have you made sure you can connect to the SMTP server? Is thinkcreate.com allowed to send mail through the smtp server you are using? Regards Gordon At 21:27 12/07/00 -0700 David Shadovitz said.... >Tim, >Are you sure nothing is happening? I'd try using your own email address >as the "To" field. >-David > >On Wed, 12 Jul 2000 17:27:58 -0400 "Tim Bahlke" <[EMAIL PROTECTED]> >writes: >> I have never had luck getting cfmail to work. How does this look to >> y'all: >> >> > SUBJECT="Order >> #URL.sessionid#" SERVER="server1.clicktex.com"> >> >> Message >> >> >> >> When I process this page nothing happens, no email, no error, >> nothing, and >> nothing is showing up in the logs ... nothing > >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.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_t alk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE:
The mail script is on the machine that I am referencing with Server="server". I am just using my email as the sender. And now I have changed it to go to me and come from someone else (address local to the server housing the script) for testing purposes. -------- Tim Bahlke, CIFO thinkcreate.com p. 336.230.0575 f. 336.230.0083 -Original Message- From: Todd Ashworth [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 13, 2000 9:17 AM To: [EMAIL PROTECTED] Subject: Re: If you are trying to end E-mail from one machine to another machine using a 3rd machine as a go-between, your messages won't make it if the machine is set not to relay mail. If you have access to the mail server, you might want to see if setting up a trusted domain for the domain you are trying to send from. I wouldn't recomend turning on relaying by default, or you are just inviting some spammer to come in and hose your server. Todd Ashworth - Original Message - From: "Tim Bahlke" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, July 13, 2000 9:06 AM Subject: RE: | I have looked in the Undeliverable Directory, nothing | | The connection to the server in CF Administrator has been verified | | I'm using a different server other then mine to send the emails. Could that | be the problem ... do I need to send the message form the same server that | the from address is associated with? | | | Tim Bahlke, CIFO | thinkcreate.com | p. 336.230.0575 | f. 336.230.0083 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE:
I did verify the connection to server1.clicktex.com through the administrator. Yesterday, when I was sending (or trying to send) the test message I was getting no error and nothing was showing up in the logs, even hours after. However, this morning I do have log entries. How come the delay? Does CF server hold the messages to send out until a certain number are spooled or until a specific amount of time Tim Bahlke, CIFO thinkcreate.com p. 336.230.0575 f. 336.230.0083 -Original Message- From: Conrad, Christopher [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 13, 2000 9:25 AM To: [EMAIL PROTECTED] Subject: RE: put the your mail server "server1.clicktex.com" into your CF admin mail settings and try to verify. Chris Christopher Conrad Victoria's Secret Catalogue http://www.VictoriasSecret.com Senior.Programmer.Analyst 614.337.5653 [EMAIL PROTECTED] > -Original Message- > From: Tim Bahlke [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, July 13, 2000 9:07 AM > To: [EMAIL PROTECTED] > Subject: RE: > > I have looked in the Undeliverable Directory, nothing > > The connection to the server in CF Administrator has been verified > > I'm using a different server other then mine to send the emails. Could > that > be the problem ... do I need to send the message form the same server that > the from address is associated with? > > > Tim Bahlke, CIFO > thinkcreate.com > p. 336.230.0575 > f. 336.230.0083 > > -Original Message- > From: Gordon Burns [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 13, 2000 1:18 AM > To: [EMAIL PROTECTED] > Subject: Re: > > Hi Tim, > > Have you looked in the Undelivered Directory? > > Have you made sure you can connect to the SMTP server? > > Is thinkcreate.com allowed to send mail through the smtp server you are > using? > > Regards > > Gordon > > > > > > At 21:27 12/07/00 -0700 David Shadovitz said > >Tim, > >Are you sure nothing is happening? I'd try using your own email address > >as the "To" field. > >-David > > > >On Wed, 12 Jul 2000 17:27:58 -0400 "Tim Bahlke" <[EMAIL PROTECTED]> > >writes: > >> I have never had luck getting cfmail to work. How does this look to > >> y'all: > >> > >> >> SUBJECT="Order > >> #URL.sessionid#" SERVER="server1.clicktex.com"> > >> > >> Message > >> > >> > >> > >> When I process this page nothing happens, no email, no error, > >> nothing, and > >> nothing is showing up in the logs ... nothing > > > >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.mail-archive.com/cf-talk@houseoffusion.com/ > >To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_t > alk or send a message to [EMAIL PROTECTED] with > 'unsubscribe' in the body. > > > -- > -- > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > > > -- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
cfmail
Can I have the 'TO' and 'From' point to the same address? With what I am trying to accomplish, is doesn't mean a hill of beans who the message comes from ... it's just really a notification that something has happened. Thanks in advance Tim Bahlke, CIFO thinkcreate.com p. 336.230.0575 f. 336.230.0083 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Need Mail Help Too!!!
I propose we change the name of this list to cfmail-talk Tim Bahlke, CIFO thinkcreate.com p. 336.230.0575 f. 336.230.0083 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
session management
Hey all, I am having a serious session management problem. Here is my cfapplication tag ... When I was working with the application last night I had a cfid of 71. This morning when I come back in (machine was shutdown last night) and logged back into the application I had a cfid of 71 and the stuff that I put into the shopping cart last night showed up. What am I doing wrong!!! Tim Bahlke, CIFO thinkcreate.com p. 336.230.0575 f. 336.230.0083 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
rogue SMTP request
The ColdFusion RDS Service on my machine (Win98 *yea, I know*) running on a NAT'ed network, which is connected through a SDSL modem, is apparently sending out SMTP requests, to where I have no idea. The requests are not getting a response nor are they timing out. They are just pilling up in the NAT table, which in turn is bringing our Internet connection down. I have CF running on three basically identical machines and am only having this problem with one. Has anyone ever run into or heard of something like this before? I have no idea why CF is sending out the requests. We have definitely narrowed the problem down to CF, when we shut the RDS Service down on this particular machine all is well again. Thanks for any help/suggestions that you can send my way. ---- Tim Bahlke, CIFO thinkcreate.com p. 336.230.0575 f. 336.230.0083 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: session management
I thought the CreateTimeSpan function syntax was days, hours, minutes, seconds. If this is correct (I am referencing CFML Language Reference in Studio) then I have the Session and Application set to timeout in 1 hour. Tim Bahlke, CIFO thinkcreate.com p. 336.230.0575 f. 336.230.0083 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, July 14, 2000 10:10 AM To: [EMAIL PROTECTED] Subject: Re: session management The SessionTimeOut and ApplicationTimeout has a 1 day before they can kill the variables. That's what I think where the problem is. Rob << Hey all, I am having a serious session management problem. Here is my cfapplication tag ... When I was working with the application last night I had a cfid of 71. This morning when I come back in (machine was shutdown last night) and logged back into the application I had a cfid of 71 and the stuff that I put into the shopping cart last night showed up. What am I doing wrong!!! -------- Tim Bahlke, CIFO thinkcreate.com p. 336.230.0575 f. 336.230.0083 >> -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Whats up with Macs and ?
I had this exact same problem. I attended CF training with Dave a couple weeks ago and mentioned it to him. He said that it was an IE Mac issue. Try using NN ... that took care of the problem for me Tim Bahlke, CIFO thinkcreate.com p. 336.230.0575 f. 336.230.0083 -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 15, 2000 10:07 PM To: Cf-Talk Subject: Whats up with Macs and ? I am using cffile as in: and when a user with a Mac tries to upload a photo, something happens so the photo will not show up, as if it is corrupted or something. I can look on the server and the file does get loaded, but a browser will not display the picture?? Could it be a form issue before the cffile tag?: I'm stuck on this one, it works fine for all PCs, and I think at least one Mac, but not all macs. Jeff Fongemie -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Form Problem
like causes a line break after the closing tag. A work around is to put the in its own Tim Bahlke, CIFO thinkcreate.com p. 336.230.0575 f. 336.230.0083 -Original Message- From: paul smith [mailto:[EMAIL PROTECTED]] Sent: Monday, July 24, 2000 6:19 PM To: [EMAIL PROTECTED] Subject: Form Problem I've tried Enter Key Words to search Headings & Listings: Selected>AllSelected>#GetCities.City# -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Scheduled Tasks
Do the scheduled tasks in cfide/administrator get written to a text file or to a table anywhere in CF? If so, where? -Tim -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: [Semi-OT] Win NT error codes
I think you can go to the command line and type 'net helpmsg [errornumber]' in NT. -------- Tim Bahlke, CIFO thinkcreate.com p. 336.230.0575 f. 336.230.0083 -Original Message- From: Greg Creedon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 26, 2000 2:38 PM To: CF-Talk Subject: [Semi-OT] Win NT error codes I was looking through my CF 4.5.1 server log files and saw the following entries: "Error","TID=131","07/26/00","14:25:09","Unable to write reply -- client browser stopped waiting for request. " "Error","TID=131","07/26/00","14:25:09","Windows NT error number 109 occurred." "Error","TID=131","07/26/00","14:24:05","Error number 232 occurred attempting to close connection to web server." "Error","TID=131","07/26/00","14:24:05","Windows NT error number 232 occurred." Of course, the Microsoft site is so disorganized and tough to use - I couldn't find a good list of NT errors. Any pointers/clues/explanations for the above?? Thanks! Greg Creedon bla-bla -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Job Titles
How about 'Pixel Overseer' -------- Tim Bahlke, CIFO thinkcreate.com p. 336.230.0575 f. 336.230.0083 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Insert date and time into database
If table_id is an integer, take away the quotes ... update hitclear where table_id = reeldemand set cleardate = '#now#' Also, I'm not sure if you can use now as the variable name is your CFSET statement. If you can't, I'm sure someone on this list will speak up. Tim Bahlke, CIFO thinkcreate.com p. 336.230.0575 f. 336.230.0083 -Original Message- From: Jacob [mailto:[EMAIL PROTECTED]] Sent: Monday, July 31, 2000 2:34 PM To: [EMAIL PROTECTED] Subject: Insert date and time into database I want to insert the date and time into a sql database. Here is want I am trying to do: update hitclear where table_id = 'reeldemand' set cleardate = '#now#' But, I get the following error: Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'where'. SQL = "update hitclear where table_id = 'reeldemand' set cleardate = '{ts '2000-07-31 11:12:22'}'" Data Source = "hits" SQL = "update hitclear where table_id = 'reeldemand' set cleardate = '{ts '2000-07-31 11:12:22'}'" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (7:1) to (7:44) in the template file D:\html\counter.htm The specific sequence of files included or processed is: D:\HTML\COUNTER.HTM . Date/Time: 07/31/00 11:12:22 I did have it working, but it was almost 8 lines of coding to set the date and time. I Would like to shorten the code to speed up the template. Any suggestions? Thanks Jacob -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.