RE: Passing form data to CFC, Array or Structure
Why don't you create a structure that links form field names to database field names and pass that structure and the form structure to your cfc. Pascal -Original Message- From: sonicDivx [mailto:[EMAIL PROTECTED] Sent: 14 October 2004 19:57 To: CF-Talk Subject: Passing form data to CFC, Array or Structure Hi, I am trying to decide which method to pass form data to a CFC that is going to add the data to a DB. My form field names are not the same as the database fieldnames so I need to pass the following; formfield name | database fieldname | formfield value So Was going to do an Array but was wondering if doing a nested Structure wouldn't be easier. Performance is a minor issue. Any thoughts Thanks Kevin [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
late night query ?
i have a query thats uses a userid to get items out of a db that have a matching userID and i need to run another query thats uses those numbers to get descriptions outta another table the basic query is this cfquery name=qCards datasource=#dsn# username=#un# password=#pw# SELECT cardID FROM userscards WHERE usersID = cfqueryparam value=#guserID# cfsqltype=cf_sql_integer /cfquery the other tables is called tblcards and i need to match the list from the 1st query to get all the descriptions from this one from a field called CardID brain is mush, any help? tia [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: late night query ?
dave. What database are you using? try.. SELECT usercards.cardID, tblcards.cardID WHERE usercards.cardID = cfqueryparam value=#guserID# cfsqltype=cf_sql_integer AND usercards.cardID = tblcards.cardID Ricardo. On Fri, 15 Oct 2004 02:09:15 -0400, dave [EMAIL PROTECTED] wrote: i have a query thats uses a userid to get items out of a db that have a matching userID and i need to run another query thats uses those numbers to get descriptions outta another table the basic query is this cfquery name=qCards datasource=#dsn# username=#un# password=#pw# SELECT cardID FROM userscards WHERE usersID = cfqueryparam value=#guserID# cfsqltype=cf_sql_integer /cfquery the other tables is called tblcards and i need to match the list from the 1st query to get all the descriptions from this one from a field called CardID brain is mush, any help? tia [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: late night query ?
If you don't need the results from the first query, do a join SELECT c.whatever, c.somethingelse, c.cardID FROM usercards uc, tblcards c WHERE uc.cardID = c.cardID AND uc.usersID = cfqueryparam value=#guserID# cfsqltype=cf_sql_integer If you need the first query, make a second query if the first returned something: SELECT c.whatever, c.somethingelse, c.cardID FROM tblcards c WHERE c.cardID IN (cfqueryparam value=#ValueList(qCards.cardID)# cfsqltype=cf_sql_integer list=yes) Pascal -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: 15 October 2004 08:09 To: CF-Talk Subject: late night query ? i have a query thats uses a userid to get items out of a db that have a matching userID and i need to run another query thats uses those numbers to get descriptions outta another table the basic query is this cfquery name=qCards datasource=#dsn# username=#un# password=#pw# SELECT cardID FROM userscards WHERE usersID = cfqueryparam value=#guserID# cfsqltype=cf_sql_integer /cfquery the other tables is called tblcards and i need to match the list from the 1st query to get all the descriptions from this one from a field called CardID brain is mush, any help? tia [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: late night query ?
i love it when i make it more complicated then it really iz lol using mysql, its close but i get this error Error Executing Database Query. Syntax error or access violation: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE usercards.usersID = 1 AND usercards.cardID = tblcards.Ca The error occurred in C:\Websites\mtgotradingpos\users\myCards\mycards.cfm: line 24 22 : cfquery name=qCards datasource=#dsn# username=#un# password=#pw# 23 : SELECT usercards.cardID, tblcards.CardID 24 : WHERE usercards.usersID = cfqueryparam value=#guserID# cfsqltype=cf_sql_integer 25 : AND usercards.cardID = tblcards.CardID 26 : /cfquery -- Original Message -- From: Ricardo Russon [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Fri, 15 Oct 2004 16:24:55 +1000 dave. What database are you using? try.. SELECT usercards.cardID, tblcards.cardID WHERE usercards.cardID = cfqueryparam value=#guserID# cfsqltype=cf_sql_integer AND usercards.cardID = tblcards.cardID Ricardo. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: late night query ?
i think the killer here is that this usercards.cardID = tblcards.cardID could be 1 record or 7000, so maybe have to loop it or maybe qoq -- Original Message -- From: Ricardo Russon [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Fri, 15 Oct 2004 16:24:55 +1000 dave. What database are you using? try.. SELECT usercards.cardID, tblcards.cardID WHERE usercards.cardID = cfqueryparam value=#guserID# cfsqltype=cf_sql_integer AND usercards.cardID = tblcards.cardID Ricardo. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: late night query ?
i been working since 9am (now 1am) so my train of thought is on the booty call i shoulda went and got, lol dammit! ok, here i'll try and explain better 1st i invoke a cfc (heres the meat of it) this gets the logged in usersname and gives me their userid. cfquery name=qgetUser datasource=#dsn# username=#un# password=#pw# SELECT userID FROM users WHERE username = cfqueryparam value=#getAuthUser()# cfsqltype=cf_sql_varchar /cfquery cfreturn qgetUser from there i query a table called userscards, what this does is basically run the userID through and gets all the matches, which gives me an output of card#'s like 4434, 2234, 5567. then i need to run those through another table called tblcards and in the output match all the numbers i got from the above query, so that i can get the rest of the details out of that table ok now i am lost lol [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: late night query ?
7000 records still is peanuts, ... if ... you correctly add indexes and set the primary keys and relationships. I also execute queries with such amounts of records and they still execute beneath the 10 ms. If I hadn't added database functionality I would to have to sit and wait. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: late night query ?
Have you tried analyzing the execution plan yet (if you are using SQL Server?) to see where the bottlenecks are? Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: late night query ?
You are missing the FROM clause -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: 15 October 2004 08:35 To: CF-Talk Subject: Re: late night query ? i love it when i make it more complicated then it really iz lol using mysql, its close but i get this error Error Executing Database Query. Syntax error or access violation: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE usercards.usersID = 1 AND usercards.cardID = tblcards.Ca The error occurred in C:\Websites\mtgotradingpos\users\myCards\mycards.cfm: line 24 22 : cfquery name=qCards datasource=#dsn# username=#un# password=#pw# 23 : SELECT usercards.cardID, tblcards.CardID 24 : WHERE usercards.usersID = cfqueryparam value=#guserID# cfsqltype=cf_sql_integer 25 : AND usercards.cardID = tblcards.CardID 26 : /cfquery -- Original Message -- From: Ricardo Russon [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Fri, 15 Oct 2004 16:24:55 +1000 dave. What database are you using? try.. SELECT usercards.cardID, tblcards.cardID WHERE usercards.cardID = cfqueryparam value=#guserID# cfsqltype=cf_sql_integer AND usercards.cardID = tblcards.cardID Ricardo. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: late night query ?
sorry but that completely doesnt help like i said its mysql, i dont use any m$ crap this isnt even mine just helping, well trying to help -- Original Message -- From: Micha Schopman [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Fri, 15 Oct 2004 09:58:52 +0200 Have you tried analyzing the execution plan yet (if you are using SQL Server?) to see where the bottlenecks are? Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: late night query ?
I've been working since 9am too. Pascal PS Of course, here it's only 10am ;) -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: 15 October 2004 09:10 To: CF-Talk Subject: RE: late night query ? i been working since 9am (now 1am) so my train of thought is on the booty call i shoulda went and got, lol dammit! ok, here i'll try and explain better 1st i invoke a cfc (heres the meat of it) this gets the logged in usersname and gives me their userid. cfquery name=qgetUser datasource=#dsn# username=#un# password=#pw# SELECT userID FROM users WHERE username = cfqueryparam value=#getAuthUser()# cfsqltype=cf_sql_varchar /cfquery cfreturn qgetUser from there i query a table called userscards, what this does is basically run the userID through and gets all the matches, which gives me an output of card#'s like 4434, 2234, 5567. then i need to run those through another table called tblcards and in the output match all the numbers i got from the above query, so that i can get the rest of the details out of that table ok now i am lost lol [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: late night query ?
lol -- Original Message -- From: Pascal Peters [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Fri, 15 Oct 2004 10:05:48 +0200 I've been working since 9am too. Pascal PS Of course, here it's only 10am ;) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: late night query ?
What have you tried.. ? .. what have you indexed? .. have you checked your primary keys .. etc.. ? Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: late night query ?
ah, come on Pascal we all know thats an Urban Legend, u really dont need that!! -- Original Message -- From: Pascal Peters [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Fri, 15 Oct 2004 10:02:59 +0200 You are missing the FROM clause -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: 15 October 2004 08:35 To: CF-Talk Subject: Re: late night query ? i love it when i make it more complicated then it really iz lol using mysql, its close but i get this error Error Executing Database Query. Syntax error or access violation: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE usercards.usersID = 1 AND usercards.cardID = tblcards.Ca The error occurred in C:\Websites\mtgotradingpos\users\myCards\mycards.cfm: line 24 22 : cfquery name=qCards datasource=#dsn# username=#un# password=#pw# 23 : SELECT usercards.cardID, tblcards.CardID 24 : WHERE usercards.usersID = cfqueryparam value=#guserID# cfsqltype=cf_sql_integer 25 : AND usercards.cardID = tblcards.CardID 26 : /cfquery -- Original Message -- From: Ricardo Russon [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Fri, 15 Oct 2004 16:24:55 +1000 dave. What database are you using? try.. SELECT usercards.cardID, tblcards.cardID WHERE usercards.cardID = cfqueryparam value=#guserID# cfsqltype=cf_sql_integer AND usercards.cardID = tblcards.cardID Ricardo. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
ANNOUNCE: CF Underground VI news - Ben Forta
Ben Forta is tentatively scheduled to be at CF Underground VI on Sunday October 31st, 2004 just before MAX (aka DevCon) New Orleans LA. We expect him to talk about Blackstone (CF 7) on the panel! http://www.cfconf.com/cf_underground6/ Quotes from CF_Underground V: * Fantastic job guys!! - Dominic Plouffe, Fusetalk * Best event so far. - David Epler * Thought this was great. My first time and will definately attend next year. - Scott Young * Lots of fun! - Amy Grothaus * Good job. I attended the Underground meeting in DC. I'm very pleased with today's events. - Juan Moyer * Thanks for a great time! - Jason Clark Top international speakers: Simon Horwith (CFDJ editor): In-depth Architecture Michael Smith (TeraTech): Personas for better apps Shlomy Gantz (BlueBrick): Project Management Tips and Tricks Kai Konig (German CFUG Nordwest): CFlex: How to integrate Macromedia Flex with ColdFusion Hal Helms (Author): XP exposed Ben Forta et al: Panel Just $99 * Learn Programming from the Gurus * Network with book authors * A free drink * Lunch included * exclusive CF shot glass to take home -- Michael Smith, TeraTech Inc - Tools for Programmers(tm) TeraTech voted Best Consulting Service by CFDJ readers! CF/ASP Web, VB, Math, Access programming tools and consulting 405 E Gude Dr Ste 207, Rockville MD 20850 USA Please check out http://www.teratech.com/ - email mailto:[EMAIL PROTECTED], or call us for more information; in the USA at 1-800-447-9120, +1-301-424-3903 International, Fax 301-762-8185Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CSV import into DB
I am doing an automated insert of a CSV fileinto a MS SQL database. I am sure this has been done a million times, so I was wondering if there is a better way that upload CSV, loop through each line and insert each line one at a time into the db. Is there a better batch import method? -- Mark Drew coldfusion and cfeclipse blogged: http://cybersonic.blogspot.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CSV import into DB
Mark If you have Enterprise manager (and this is a one off task) you can run the dts wizard which allows you to Insert data into and from CSV, excels and numerous other file formats. HTH Kola _ From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: 15 October 2004 10:48 To: CF-Talk Subject: CSV import into DB I am doing an automated insert of a CSV fileinto a MS SQL database. I am sure this has been done a million times, so I was wondering if there is a better way that upload CSV, loop through each line and insert each line one at a time into the db. Is there a better batch import method? -- Mark Drew coldfusion and cfeclipse blogged: http://cybersonic.blogspot.com/ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CSV import into DB
Thanks for that this will not be a one off but a way of populating a table remotely using CSV files via an upload. Seems to me that the SQL language is very limited in the INSERT INTO department. MD On Fri, 15 Oct 2004 12:01:15 +0100, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Mark If you have Enterprise manager (and this is a one off task) you can run the dts wizard which allows you to Insert data into and from CSV, excels and numerous other file formats. HTH Kola _ From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: 15 October 2004 10:48 To: CF-Talk Subject: CSV import into DB I am doing an automated insert of a CSV fileinto a MS SQL database. I am sure this has been done a million times, so I was wondering if there is a better way that upload CSV, loop through each line and insert each line one at a time into the db. Is there a better batch import method? -- Mark Drew coldfusion and cfeclipse blogged: http://cybersonic.blogspot.com/ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CSV import into DB
DTS _ From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: 15 October 2004 11:48 To: CF-Talk Subject: CSV import into DB I am doing an automated insert of a CSV fileinto a MS SQL database. I am sure this has been done a million times, so I was wondering if there is a better way that upload CSV, loop through each line and insert each line one at a time into the db. Is there a better batch import method? -- Mark Drew coldfusion and cfeclipse blogged: http://cybersonic.blogspot.com/ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CSV import into DB
How does one execute a DTS package from CF? -- Hugo Ahlenius - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: Robertson-Ravo, Neil (RX) | [mailto:[EMAIL PROTECTED] | Sent: Friday, October 15, 2004 13:14 | To: CF-Talk | Subject: RE: CSV import into DB | | DTS | | | | _ | | From: Mark Drew [mailto:[EMAIL PROTECTED] | Sent: 15 October 2004 11:48 | To: CF-Talk | Subject: CSV import into DB | | | | I am doing an automated insert of a CSV fileinto a MS SQL database. | I am sure this has been done a million times, so I was | wondering if there is a better way that upload CSV, loop | through each line and insert each line one at a time into the | db. Is there a better batch import method? | | | -- | Mark Drew | | coldfusion and cfeclipse blogged: | http://cybersonic.blogspot.com/ | | _ | | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CSV import into DB
You can use cfexecute to run DTSRun.exe. If you search the SQL server Help, you can find out more info on the syntax to use DTSRun from command line. On Fri, 15 Oct 2004 13:26:50 +0200, Hugo Ahlenius [EMAIL PROTECTED] wrote: How does one execute a DTS package from CF? -- Hugo Ahlenius - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: Robertson-Ravo, Neil (RX) | [mailto:[EMAIL PROTECTED] | Sent: Friday, October 15, 2004 13:14 | To: CF-Talk | Subject: RE: CSV import into DB | | DTS | | | | _ | | From: Mark Drew [mailto:[EMAIL PROTECTED] | Sent: 15 October 2004 11:48 | To: CF-Talk | Subject: CSV import into DB | | | | I am doing an automated insert of a CSV fileinto a MS SQL database. | I am sure this has been done a million times, so I was | wondering if there is a better way that upload CSV, loop | through each line and insert each line one at a time into the | db. Is there a better batch import method? | | | -- | Mark Drew | | coldfusion and cfeclipse blogged: | http://cybersonic.blogspot.com/ | | _ | | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CSV import into DB
My question exactly! Especially since the DB isnt on the same server (as they generally shouldnt be!) MD [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Compare/Diff functionality
Just wanted to kick this question... Jrun seems to dislike my code, and this piece of instable enterprise level unworthy server software locks up.. and stays at 100% cpu .. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Compare/Diff functionality
We have swapped out jrun for tomcat on one server, accessing it through mod_proxy. This is a Solaris/Apache machine. The stability is excellent, we don't have to run the jrun with the interpreted/Xint flag (due to an unresolved jrun/jvm bug), and we can use mod_deflate to save huge amounts of bandwidth. -- Hugo Ahlenius - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: Micha Schopman [mailto:[EMAIL PROTECTED] | Sent: Friday, October 15, 2004 13:48 | To: CF-Talk | Subject: RE: Compare/Diff functionality | | Just wanted to kick this question... Jrun seems to dislike my | code, and this piece of instable enterprise level unworthy | server software locks up.. and stays at 100% cpu .. | Micha Schopman | Software Engineer | Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel | 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo | 39.48.05.380 | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CSV import into DB
| From: Scott Stroz [mailto:[EMAIL PROTECTED] | You can use cfexecute to run DTSRun.exe. Is it possible to run it through t-sql? ### This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. For more information, connect to http://www.F-Secure.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CSV import into DB
You can run a DTS via T-SQL using dtsrun and master..xp_cmdshell.What we do is copy the file from the server uploading to the SQL box, then run the DTS against that filethe file can be of any name as we use global variables and some VB inside of the DTS to get the connection properties etc... _ From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: 15 October 2004 12:33 To: CF-Talk Subject: Re: CSV import into DB My question exactly! Especially since the DB isnt on the same server (as they generally shouldnt be!) MD _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CSV import into DB
Here is how I do it through Coldfusion and have not had any problems with it. Basically I ask the user to sleect their file through a Form Object, and The CFFile to Upload this file and then to read the file uploaded. Next I create Objects and Reach each line into an Array. I then have a section to read the first line of the array and set variables for the specific header fields that I want to import. Last I loop over the Length of the array and Insert it into the datasource/table that I need it to go into. At 06:33 AM 10/15/2004, you wrote: My question exactly! Especially since the DB isnt on the same server (as they generally shouldnt be!) MD -- [http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [http://www.houseoffusion.com/lists.cfm/link=i:4:181581This Message] [http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=6232.5677.4Fast Unsubscribe] [http://www.houseoffusion.com/signin/User Settings] [https://www.paypal.com/cgi-bin/webscr?amount=item_name=House+of+Fusionbusiness=donations%40houseoffusion.comundefined_quantity=cmd=_xclickDonations and Support] -- http://www.houseoffusion.com/banners/view.cfm?bannerid=34 [] -- [] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CSV import into DB
You can use xp_cmdshell from the SQL server, or you can also load DTSRun.exe onto the web server(I can't remember how, but it is not difficult to find out how).DTSRun.exe can reside on any server, and access any other SQL server that allows remote connections. I have written DTS packages that reside on my web server, and pull information from a SQL server at a different location, and then insert that data into another database on a third server.That's one of the wonderful things about DTS! On Fri, 15 Oct 2004 13:33:18 +0200, Mark Drew [EMAIL PROTECTED] wrote: My question exactly! Especially since the DB isnt on the same server (as they generally shouldnt be!) MD [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CSV import into DB
Sorry, Here is the Code as I attached it before. cfif not isdefined(FORM.EventAction) table border=0 align=center width=90% cellspacing=0 cellpadding=0 STYLE=Border-Color: 00; Border-Style: solid; Border-Width: 0px; tr td Class=ErrorMsgDetailsSelect File to Upload/td /tr tr td Class=ErrorMsgDetailsnbsp;/td /tr tr td Class=ErrorMsgDetails cfoutput form action="" method=post name=UploadForm enctype=multipart/form-data input type=Hidden Name=EventAction Value=File Selected input type=file name=UploadedFile size=40 maxlength=100 input type=submit value=UPLOAD FILE/form /cfoutput /td /tr /table /cfif cfif isdefined(FORM.EventAction) cfswitch _expression_=#FORM.EventAction# cfcase value=File Selected cfset path = #GetDirectoryFromPath(GetCurrentTemplatePath())# cffile action="" filefield=Form.UploadedFile destination=#variables.path# nameconflict=OVERWRITE cffile action="" file=#variables.path#\#cffile.ClientFileName#.#cffile.ClientFileExt# variable=variables.FileContent cfset Form.Delims = #chr(13)# #chr(10)# cfset Form.FileSize = #Len(variables.FileContent)# cfset Form.FileLines = #ListLen(Variables.FileContent, Form.Delims)# cfset variables.FileContent = #Replace(variables.FileContent, ,,, , ,, all)# cfset variables.Filecontent = #Replace(variables.FileContent, ,,, , ,, all)# cfset FileContentLines = #ListToArray(variables.FileContent, Form.Delims)# cfset FileContentLength = #ArrayLen(variables.FileContentLines)# cfset FieldNameList = #variables.FileContentLines[1]# cfset FieldQnty = #ListLen(Variables.FieldNameList, ,)# cfset FieldNameArray = #ListToArray(variables.FieldNameList, ,)# !--- Set Column Name Variables to 0 --- cfset COLHeader1 = 0 cfset COLHeader2 = 0 cfset COLHeader3 = 0 cfset COLHeader4 = 0 cfset COLHeader5 = 0 cfset COLHeader6 = 0 cfset COLHeader7 = 0 cfset COLHeader8 = 0 cfset COLHeader9 = 0 cfloop index=FieldCounter from=1 to=#variables.FieldQnty# step=1 cfif #variables.FieldNameArray[variables.FieldCounter]# Contains Corp cfset COLHeader1 = #variables.FieldCounter# /cfif cfif #variables.FieldNameArray[variables.FieldCounter]# Contains SCHLNumber cfset COLHeader2 = #variables.FieldCounter# /cfif cfif #variables.FieldNameArray[variables.FieldCounter]# Contains SCHLName cfset COLHeader3 = #variables.FieldCounter# /cfif cfif #variables.FieldNameArray[variables.FieldCounter]# Contains LADDRESS cfset COLHeader4 = #variables.FieldCounter# /cfif cfif #variables.FieldNameArray[variables.FieldCounter]# Contains LCITY cfset COLHeader5 = #variables.FieldCounter# /cfif cfif #variables.FieldNameArray[variables.FieldCounter]# Contains STATE cfset COLHeader6 = #variables.FieldCounter# /cfif cfif #variables.FieldNameArray[variables.FieldCounter]# Contains LZIP cfset COLHeader7 = #variables.FieldCounter# /cfif cfif #variables.FieldNameArray[variables.FieldCounter]# Contains PHONE cfset COLHeader8 = #variables.FieldCounter# /cfif cfif #variables.FieldNameArray[variables.FieldCounter]# Contains FAX cfset COLHeader9 = #variables.FieldCounter# /cfif /cfloop cfloop index=FileProcess from=2 to=#variables.FileContentLength# step=1 cfset FieldDataArray = #ListToArray(FileContentLines[variables.FileProcess], ,)# cfset COLData1 = #FieldDataArray[variables.COLHeader1]# cfset COLData1 = #Mid(Variables.ColData1, 2, LEN(Variables.ColData1) - 2)# cfset COLData2 = #FieldDataArray[variables.COLHeader2]# cfset COLData2 = #Mid(Variables.ColData2, 2, LEN(Variables.ColData2) - 2)# cfset COLData3 = #FieldDataArray[variables.COLHeader3]# cfset COLData3 = #Mid(Variables.ColData3, 2, LEN(Variables.ColData3) - 2)# cfset COLData4 = #FieldDataArray[variables.COLHeader4]# cfset COLData4 = #Mid(Variables.ColData4, 2, LEN(Variables.ColData4) - 2)# cfset COLData5 = #FieldDataArray[variables.COLHeader5]# cfset COLData5 = #Mid(Variables.ColData5, 2, LEN(Variables.ColData5) - 2)# cfset COLData6 = #FieldDataArray[variables.COLHeader6]# cfset COLData6 = #Mid(Variables.ColData6, 2, LEN(Variables.ColData6) - 2)# cfset COLData7 = #FieldDataArray[variables.COLHeader7]# cfset COLData7 = #Mid(Variables.ColData7, 2, LEN(Variables.ColData7) - 2)# cfset COLData8 = #FieldDataArray[variables.COLHeader8]# cfset COLData8 = #Mid(Variables.ColData8, 2, LEN(Variables.ColData8) - 2)# cfset COLData9 = #FieldDataArray[variables.COLHeader9]# cfset COLData9 = #Mid(Variables.ColData9, 2, LEN(Variables.ColData9) - 2)# cfquery name=InsertRecord datasource=OnlineRegistration Insert into schoolbuildings(CorpNumber, SchoolNumber, SchoolName, SchoolAddress, SchoolCity, SchoolState, SchoolZipCode, SchoolPhone, SchoolFax) Values('#variables.COLData1#', '#variables.COLData2#', '#variables.COLData3#', '#variables.COLData4#', '#variables.COLData5#', '#variables.COLData6#', '#variables.COLData7#', '#variables.COLData8#', '#variables.COLData9#') /cfquery /cfloop /cfcase /cfswitch /cfif At 07:12 AM 10/15/2004, you wrote: Here is how I do it through Coldfusion and have not had any problems with it. Basically I
Homesite's Wizards in DW?
Hi all, There are some (arguably) handy wizards in HomeSite that I sometimes miss - particlularly the good ol' Record Viewer Wizard with it's data manipulation abilities. I was wondering if there was any way to get that functionality in DWMX. I looked in th exchange but found nothing specific, though there were some bundled solutions that I have not yet examined. Am I missing something? Sincerely, Andrew [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Homesite's Wizards in DW?
I was wondering if there was any way to get that functionality in DWMX. You should investigate the Application Objects in DW and, more in general, Server Behaviors. They aren't 100% equivalent of HS's wizards, but it may be worth a check Massimo Foti DW tools: http://www.massimocorner.com CF tools:http://www.olimpo.ch/tmt/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: How to prevent multiple logins
But if you force off the first login, that may not be the same user, but it may be a different user using the same login.You can't force someone off while they're in the app. John -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Thursday, October 14, 2004 4:42 PM To: CF-Talk Subject: Re: How to prevent multiple logins I think the biggest decision that the person who asked will have to make is the business logic for when a session that is currently logged in is no longer logged in. The only way that I have seen to do handle the scenario you are describing is to force off the first login in favor of the second. Solves the problem completely, but adds quite a bit to the complexity of your login/who's on tracking. -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Getting around Outlook 2003 Junk Email Filtering
Does anyone know the specifics of what Outlook 2003 looks for when filtering Junk Email?I have been testing some email features that I am developing via CF.Whenever I send an email, Outlook 2003 flags it as Junk Email and moves it to the folder.Anyone have any tips for what I can do to avoid Junk Email folders? John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: How to prevent multiple logins
We do this in one of our applications. If a user logs in and that user is currently logged in they (the original login) gets kicked. Works well, as it reminds our users a 1 person - 1 login, and not for sharing, On Fri, 15 Oct 2004 10:45:34 -0400, Burns, John D [EMAIL PROTECTED] wrote: But if you force off the first login, that may not be the same user, but it may be a different user using the same login.You can't force someone off while they're in the app. John -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Thursday, October 14, 2004 4:42 PM To: CF-Talk Subject: Re: How to prevent multiple logins I think the biggest decision that the person who asked will have to make is the business logic for when a session that is currently logged in is no longer logged in. The only way that I have seen to do handle the scenario you are describing is to force off the first login in favor of the second. Solves the problem completely, but adds quite a bit to the complexity of your login/who's on tracking. -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: How to prevent multiple logins
But how will that stop someone else from trying to login as one of your users while theyare logged in? On Fri, 15 Oct 2004 16:03:15 +0100, Neil Middleton [EMAIL PROTECTED] wrote: We do this in one of our applications. If a user logs in and that user is currently logged in they (the original login) gets kicked. Works well, as it reminds our users a 1 person - 1 login, and not for sharing, On Fri, 15 Oct 2004 10:45:34 -0400, Burns, John D [EMAIL PROTECTED] wrote: But if you force off the first login, that may not be the same user, but it may be a different user using the same login.You can't force someone off while they're in the app. John -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Thursday, October 14, 2004 4:42 PM To: CF-Talk Subject: Re: How to prevent multiple logins I think the biggest decision that the person who asked will have to make is the business logic for when a session that is currently logged in is no longer logged in. The only way that I have seen to do handle the scenario you are describing is to force off the first login in favor of the second. Solves the problem completely, but adds quite a bit to the complexity of your login/who's on tracking. -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: How to prevent multiple logins
At login store the users IP . ... and keep checking the IP against the one stored... on each request.. if it changes... log the current user... out and say.. someone else from another IP has logged in... Burns, John D wrote: I think the biggest decision that the person who asked will have to make is the business logic for when a session that is currently logged in is no longer logged in.For instance: If User A logs in at 10AM and is given a 60 minute session and is somehow flagged as logged in (either in DB or app structure).The user does 1 quick thing on the site and then closes the browser at 10:05AM. This user gets up and moves to another computer and attempts to log into the site.He won't be allowed until 11AM if you do it this way.Since there's no real-time checking if the client is still there (unless you use flash remoting or a ping type iframe - which I would say is overkill) then you can't really handle this type of situation without sacrificing, that once someone logs in, no one can log in with that account until the session expires (even the person who started the session...unless they're on the same machine and have a cookie or something). John -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Thursday, October 14, 2004 4:15 PM To: CF-Talk Subject: Re: How to prevent multiple logins Barney Boisvert wrote: Add a two fields to your user table: isLoggedIn and lastAccessDate. Or do it in an application structure and save yourself the db overhead. I use/maintain a 2d array to show a bunch of stuff as part of a Who's On app.When a user logs in their user ID is planted in their who's on 'record', (which defaults to zero if they are not logged in and just a visitor). Then when anyone tries to log in the array is checked to see if they are already logged in.Steps are taken from there.Those steps can vary depending on your application (i.e. force the first user off the system, deny the second user the login, kick them both off, alert the sysadmin etc.) You can find the Who's On code in the link below.Just add a few array elements to the code in the article to do what you need. http://mysecretbase.com/How_To_Build_A_Who_Is_On_Application_With_ColdFu sion.cfm And when you're done you also get a Who's On app as a byproduct. Just build something to loop over the array and display its contents. shameless plug I'm bringing out AccessMonger Pro in a couple of days and it does all this stuff and gee whiz a whole lot more. /plug -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: How to prevent multiple logins
It doesn't, apart from via inference as the users realise that if they share their user account they are likely to be forced off the system with no notice. On Fri, 15 Oct 2004 11:11:42 -0400, Scott Stroz [EMAIL PROTECTED] wrote: But how will that stop someone else from trying to login as one of your users while theyare logged in? -- Neil [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: How to prevent multiple logins
What about people whose connection changes Ips?The new NMCI setup for military bases gives users a pool of Ips that change regularly.Our company has 2 external Ips that change as needed, so the guaranteed IP connection isn't always true. John -Original Message- From: Umer Farooq [mailto:[EMAIL PROTECTED] Sent: Friday, October 15, 2004 11:33 AM To: CF-Talk Subject: Re: How to prevent multiple logins At login store the users IP . ... and keep checking the IP against the one stored... on each request.. if it changes... log the current user... out and say.. someone else from another IP has logged in... Burns, John D wrote: I think the biggest decision that the person who asked will have to make is the business logic for when a session that is currently logged in is no longer logged in.For instance: If User A logs in at 10AM and is given a 60 minute session and is somehow flagged as logged in (either in DB or app structure).The user does 1 quick thing on the site and then closes the browser at 10:05AM. This user gets up and moves to another computer and attempts to log into the site.He won't be allowed until 11AM if you do it this way. Since there's no real-time checking if the client is still there (unless you use flash remoting or a ping type iframe - which I would say is overkill) then you can't really handle this type of situation without sacrificing, that once someone logs in, no one can log in with that account until the session expires (even the person who started the session...unless they're on the same machine and have a cookie or something). John -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Thursday, October 14, 2004 4:15 PM To: CF-Talk Subject: Re: How to prevent multiple logins Barney Boisvert wrote: Add a two fields to your user table: isLoggedIn and lastAccessDate. Or do it in an application structure and save yourself the db overhead. I use/maintain a 2d array to show a bunch of stuff as part of a Who's On app.When a user logs in their user ID is planted in their who's on 'record', (which defaults to zero if they are not logged in and just a visitor). Then when anyone tries to log in the array is checked to see if they are already logged in.Steps are taken from there.Those steps can vary depending on your application (i.e. force the first user off the system, deny the second user the login, kick them both off, alert the sysadmin etc.) You can find the Who's On code in the link below.Just add a few array elements to the code in the article to do what you need. http://mysecretbase.com/How_To_Build_A_Who_Is_On_Application_With_ColdFu sion.cfm And when you're done you also get a Who's On app as a byproduct. Just build something to loop over the array and display its contents. shameless plug I'm bringing out AccessMonger Pro in a couple of days and it does all this stuff and gee whiz a whole lot more. /plug -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: How to prevent multiple logins
On Fri, 15 Oct 2004 11:37:54 -0400, Burns, John D [EMAIL PROTECTED] wrote: What about people whose connection changes Ips?The new NMCI setup for military bases gives users a pool of Ips that change regularly.Our company has 2 external Ips that change as needed, so the guaranteed IP connection isn't always true. I think the main point of this discussion is that however you decide to implement this type of functionality you are going to have to make compromises somewhere. There is no method, that I know of, that is going to work in such a way that it never inconviencences the user while at the sametime providing top notch security and preventing concurrent logins. It is an either-or situation. >From my experience, if you restrict concurrent logins you are going to cause problems for your users. The question that needs to be answered is what those problems are and what forms of problems you are willing to deal with. -- chris johnston www.fuzzylizard.com For millions of years, mankind lived just like the animals and something happened which unleashed the power of our imagination, we learned to talk. Pink Floyd [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: How to prevent multiple logins
At 11:51 AM 10/15/2004, Chris Johnston wrote: There is no method, that I know of, that is going to work in such a way that it never inconviencences the user while at the sametime providing top notch security and preventing concurrent logins. It is an either-or situation. Yes. It's not a technical problem. It's a procedural problem. After choosing the procedure, the rest is easy. Anders +===+ |Anders GreenEmail: [EMAIL PROTECTED] | |Home: 919.303.0218| |Off Road Rally Racing Team: http://linaracing.com/ | +===+ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: How to prevent multiple logins
I agree with fuzzylizard. You have to make processing decisions and have mgmt okay it. Let everyone know what may/could/would happen if they login concurrently. Once users know this, it would meet everyone's expectations. This pretty much boils down to communication (a lost skill =) LOL. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
GODaddy SSL certs
Has anybody had experience with these... any issues... cost looks good Tim Laureska 1st-String Technologies [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: GODaddy SSL certs
Tim Laureska wrote: Has anybody had experience with these... any issues... cost looks good There are loads of companies out there that do low-cost SSL certs, including one that does them for free!What you have to be concerned about, however, is whether the Certificate Authority (the organization that tells the world your cert is legit) is supported by your visitor's browser - many aren't thus your visitors get a security warning.What I recommend doing is checking to see what your browser stats are and test each one on the different certs you are considering - if they work, good, if not then avoid them.Note that there is no security difference between an expensive one versus a cheap one, the difference is the perception for your visitors - if they get a weird popup they might get scared off. -- *Damien McKenna* - Web Developer - [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 Nothing endures but change. - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: GODaddy SSL certs
ubiquity isn't up to the same standard that you get from Comodo, which I'm using.I pay $42.88 as a reseller per cert (being a reseller gets me instant issuance as well). The GoDaddy certs are about half that cost, but when I eventually unburied their actual browser stats they were worse than Comodo (InstantSSL) by a noticeable margin.Forget exactly what it was now. -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: JavaScript Validation
Hey guys, I have a form, that needs some JS help. I need a script that does two things: 1.) makes sure that at least one of 'keyword1' OR 'keyword_phrase' are not blank 2.) It somebody chooses a time period from the drop-down, that the radio button for 'timeperiod' is selected automatically. Can anybody give me some guidance?I've got the first part of the script done... It checked for keyword1 being blank.I tried just adding another notEmpty(form.keyword_phrase) to the script besides the first if... And that didn't help. THANK YOU!! *** *** *** THE SCRIPT SO FAR: *** *** *** script type=text/_javascript_ function formValidation(form){ if(notEmpty(form.keyword1)) { { return true; } } return false; } function notEmpty(elem){ var str = elem.value; if(str.length == 0){ alert(You must enter a keyword or phrase to continue.); return false; } else { return true; } } /script *** *** *** THE FORM: *** *** *** form action="" method=post name=advanced_form formValidation(this) bSearch:/b br /br / table border=0 cellpadding=2 cellspacing=0 tr tdFor the bkeywords/b:/td td input type=text name=keyword1 size=10 / select name=operator option value=ANDAND option value=NOTNOT option value=OROR /select input type=text name=keyword2 size=10 / select name=operator2 option value=ANDAND option value=NOTNOT option value=OROR /select input type=text name=keyword3 size=10 / /td /tr tr tdFor the bexact phrase/b:/td tdinput type=text name=keyword_phrase size=30 //td /tr tr tdbr /For bdocument type/b:/td td br / select name=collection option value=all_documents selectedAll Documents/option option value=annual_reportAnnual Report/option option value=bookBooks/option /select /td /tr tr td valign=topbr /From pages bcreated/b:/td td valign=top br / input type=radio name=timeperiod value=anytime checked /anytime br /input type=radio name=timeperiod value=range / select name=created option value=OneWeekone week option value=TwoWeekstwo weeks option value=OneMonthone month option value=ThreeMonthsthree months option value=OneYearone year /select ago br /input type=radio name=timeperiod value=between /between input type=text name=startdate size=10 /nbsp;a href="" 'startdate')img src="" width=16 height=16 border=0 alt=Click here to choose a date./a and input type=text name=enddate size=10 /nbsp;a href="" 'enddate')img src="" width=16 height=16 border=0 alt=Click here to choose a date./a /td /tr tr tdbr /nbsp;/td td br / input type=hidden name=action value=advanced input type=hidden name=FindMe value=FindMe input type=submit name=submit value=search /td /tr /table /form [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: GODaddy SSL certs
I bought one from thawte for $19.00, at FreeSSL.com.It works on96% of all browsers and we have never had a problem.We use it in our development environment, where who issues it isn't important.For real world stuff I always suggest a more recognized company like VeriSign or Geotrust.Though they all are just about the same, I feel that people are more comfortable when the company is one that they have heard of. David -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: Friday, October 15, 2004 12:29 PM To: CF-Talk Subject: Re: GODaddy SSL certs Tim Laureska wrote: Has anybody had experience with these... any issues... cost looks good There are loads of companies out there that do low-cost SSL certs, including one that does them for free!What you have to be concerned about, however, is whether the Certificate Authority (the organization that tells the world your cert is legit) is supported by your visitor's browser - many aren't thus your visitors get a security warning.What I recommend doing is checking to see what your browser stats are and test each one on the different certs you are considering - if they work, good, if not then avoid them.Note that there is no security difference between an expensive one versus a cheap one, the difference is the perception for your visitors - if they get a weird popup they might get scared off. -- *Damien McKenna* - Web Developer - [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 Nothing endures but change. - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CSV import into DB
I just got done finishing a project that waits around at 15-minute intervals and pulls in 10k+ line csv files for import into a cf db I used Paul Vernon's CFX_pop3 to speed up the processing (*dramatically*) of the 4-5mb file attachments, and Ryan Emerle's new java cfx_text2query to read in the data.Another huge jump forward in speed.Then I did the query loop you describe, but the time that step takes up is negligible compared to the cffile read and interpretation. I found that loop took up only a small fraction of my total job time when running in about 16000 records from a 4.7mb csv file. DTS would have been nice but it wasn't a sql server job. -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: GODaddy SSL certs
This is what they (god Daddy) shows on their site: QUOTE: Our root certificate - the Valicert Class 2 Policy Validation Authority - is installed in the following browser versions . Internet Explorer 5.01 and higher . AOL 5 and higher . Netscape 4.7 and higher . Opera 7.5 and higher. . Safari on Mac OS X 10.3.4 or higher . Mozilla (all versions) . Firefox (all versions) . Konqueror (all versions) That equals 99% total browser ubiquity END QUOTE -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Friday, October 15, 2004 12:31 PM To: CF-Talk Subject: Re: GODaddy SSL certs ubiquity isn't up to the same standard that you get from Comodo, which I'm using.I pay $42.88 as a reseller per cert (being a reseller gets me instant issuance as well). The GoDaddy certs are about half that cost, but when I eventually unburied their actual browser stats they were worse than Comodo (InstantSSL) by a noticeable margin.Forget exactly what it was now. -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: GODaddy SSL certs
GoDaddy's a fairly well know name... yes, primarily domain name registrations but.. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 15, 2004 12:39 PM To: CF-Talk Subject: RE: GODaddy SSL certs I bought one from thawte for $19.00, at FreeSSL.com.It works on96% of all browsers and we have never had a problem.We use it in our development environment, where who issues it isn't important.For real world stuff I always suggest a more recognized company like VeriSign or Geotrust. Though they all are just about the same, I feel that people are more comfortable when the company is one that they have heard of. David -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: Friday, October 15, 2004 12:29 PM To: CF-Talk Subject: Re: GODaddy SSL certs Tim Laureska wrote: Has anybody had experience with these... any issues... cost looks good There are loads of companies out there that do low-cost SSL certs, including one that does them for free!What you have to be concerned about, however, is whether the Certificate Authority (the organization that tells the world your cert is legit) is supported by your visitor's browser - many aren't thus your visitors get a security warning.What I recommend doing is checking to see what your browser stats are and test each one on the different certs you are considering - if they work, good, if not then avoid them.Note that there is no security difference between an expensive one versus a cheap one, the difference is the perception for your visitors - if they get a weird popup they might get scared off. -- *Damien McKenna* - Web Developer - [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 Nothing endures but change. - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: How to prevent multiple logins
John wrote: But if you force off the first login, that may not be the same user, but it may be a different user using the same login.You can't force someone off while they're in the app. Oh yes you can, and depending on your business rules maybe you should. If only one user is supposed to use that login at any one time for terms-of-service reasons (i.e. a paid unique subscriber) then the bumped user gets what they deserve, or at least they get diminished utility from their stolen/misused login.If its an innocent thing they know they aren't supposed to be doing its a lesson learned and a discouragement of the forbidden behavior. If its a business user who is also beholden to company policy that says one login per person, then you are protecting that single user's ability to keep using the system.If a co-worker comes to their desk after they have forgotten to log out then this is a back-handed way of helping to protect the user from their own poor practices. Hopefully if going this route you are also logging the duplicate login attempts for managerial review. If its a mission-critical app of some sort that dictates a user must complete their session no matter what then I would argue you shouldn't be enforcing unique logins in the first place as the real world will get in the way without some controls, as was mentioned earlier in the thread.For that you need a system that can expressly allow unique logins, perhaps again with managerial log review so your admins are at least aware of the occurrences. -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Compare/Diff functionality
How about just CFEXECUTE on the `diff` command?You'll have to write the strings to temp files, but that should be faster than your setup if you're complaining about performance. cheers, barneyb On Thu, 14 Oct 2004 22:33:16 +0200, Micha Schopman [EMAIL PROTECTED] wrote: Does anyone found any usefull resources implementing code which shows the differences between two strings (compare versions, show appended, modified and removed words) ? I have build one myself using the Lebensthein algorithm but the algorithm is pretty CPU intensive under ColdFusion. It is very hard to find any resources on the web for this, so I was hoping on experiences. -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/blog/ I currently have 4 GMail invites for the taking [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: How to prevent multiple logins
I wrote: ...For that you need a system that can expressly allow unique logins... Oops.I meant 'duplicate logins' --Matt-- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: JavaScript Validation
Can anybody give me some guidance?I've got the first part of the script done... It checked for keyword1 being blank.I tried just adding another notEmpty(form.keyword_phrase) to the script besides the first if... And that didn't help. If you want to ask an OR question, use the || operator. The operator is for AND questions. 2.) It somebody chooses a time period from the drop-down, that the radio button for 'timeperiod' is selected automatically. Add an onchange event handler to your SELECT which sets the appropriate radio button's checked property to true: select ... > I'm assuming you want the second one checked. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: GODaddy SSL certs
And Comodo claims better compatibility (below).I don't pay much attention to percentage claims, as thats all they are with all of these guys:IE 5.00 is the default for a bare win2k install and I've seen a disturbing amount of traffic using it.Same with older NN's. The Opera stuff is just gravy.Only a fraction of a percent in toto anyway across all versions. It wound up being maybe a 1-2 point pop based on my global stats. Remember also that GoDaddy has 25% 'revenue sharing' over a certain price point, so that may add to the real price you pay if you are a reseller.I worked it out and the difference was like 15 bucks for a cert I charge an installed fee of $130 for.Not worth messing with to shave a couple bucks. Internet Explorer 5.00 and above Netscape 4.x and above AOL 5 and above Opera 5 and above Root Certificate comes pre-installed with: Windows 98SE Windows ME Windows 2000 Windows XP Mac OS 8.5 Mac OS 9.x Mac OS X -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: How to prevent multiple logins
But what if the login information is lost accidentally?I agree that the app may dictate anything, but it seems the helpdesk overhead with handling issues of I got logged out for no reason would outweigh the need for one login per user.Especially because that negates having 2 browsers open with the same app. That would personally drive me crazy. John -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Friday, October 15, 2004 12:50 PM To: CF-Talk Subject: Re: How to prevent multiple logins John wrote: But if you force off the first login, that may not be the same user, but it may be a different user using the same login.You can't force someone off while they're in the app. Oh yes you can, and depending on your business rules maybe you should. If only one user is supposed to use that login at any one time for terms-of-service reasons (i.e. a paid unique subscriber) then the bumped user gets what they deserve, or at least they get diminished utility from their stolen/misused login.If its an innocent thing they know they aren't supposed to be doing its a lesson learned and a discouragement of the forbidden behavior. If its a business user who is also beholden to company policy that says one login per person, then you are protecting that single user's ability to keep using the system.If a co-worker comes to their desk after they have forgotten to log out then this is a back-handed way of helping to protect the user from their own poor practices. Hopefully if going this route you are also logging the duplicate login attempts for managerial review. If its a mission-critical app of some sort that dictates a user must complete their session no matter what then I would argue you shouldn't be enforcing unique logins in the first place as the real world will get in the way without some controls, as was mentioned earlier in the thread.For that you need a system that can expressly allow unique logins, perhaps again with managerial log review so your admins are at least aware of the occurrences. -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Compare/Diff functionality
The 100% cpu was not the direct result of the code, it was the result of using cfdump on a large array, but unfortunately Jrun kept using 100%. I modified the code and it runs perfectly now. Still I am interested in others experiences. I also looked at those possibilities but diff is only available on Linux, where it has been integrated. For the time being I use my custom build solution. A more extensive search learned me almost every diff utility (and spell checker) has been based on the levenshtein algorithm. From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Fri 10/15/2004 6:53 PM To: CF-Talk Subject: Re: Compare/Diff functionality How about just CFEXECUTE on the `diff` command?You'll have to write the strings to temp files, but that should be faster than your setup if you're complaining about performance. cheers, barneyb On Thu, 14 Oct 2004 22:33:16 +0200, Micha Schopman [EMAIL PROTECTED] wrote: Does anyone found any usefull resources implementing code which shows the differences between two strings (compare versions, show appended, modified and removed words) ? I have build one myself using the Lebensthein algorithm but the algorithm is pretty CPU intensive under ColdFusion. It is very hard to find any resources on the web for this, so I was hoping on experiences. -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/blog/ I currently have 4 GMail invites for the taking [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: How to prevent multiple logins
There's not reason you have to just kill the first user's session. Give them a nice message that says someone else logged in with their credendials, and they need to do something about it. The 2 browser issue isn't an issue if they're instances of the same browser, becaue they'll share a session, not be two separate logins. Same browser meaning a single load of the executable by the OS, not just both IE or both FF. cheers, barneyb On Fri, 15 Oct 2004 13:04:47 -0400, Burns, John D [EMAIL PROTECTED] wrote: But what if the login information is lost accidentally?I agree that the app may dictate anything, but it seems the helpdesk overhead with handling issues of I got logged out for no reason would outweigh the need for one login per user.Especially because that negates having 2 browsers open with the same app. That would personally drive me crazy. John -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/blog/ I currently have 4 GMail invites for the taking [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Compare/Diff functionality
Micha Schopman wrote: I also looked at those possibilities but diff is only available on Linux, where it has been integrated. Not just Linux, every POSIX OS. I believe it is available from Microsoft in the SFU package (formerly known as Interix). Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: How to prevent multiple logins
Not sure I get what you mean by lost accidentally. Adding an onscreen note to the logged-off individual effectively takes care of help desk issues. You have been logged off because another user has logged on with your credentials at another workstation.You may wish to call Security, or your mommy, or both Then the admins, if informed of the dupe login, can use their who's on viewer to see where the other workstation is, or force them off the system immediately themselves via an administrative logoff. Thats assuming a high-security environment.Generally it just means the user says 'oops', or comes back to their previous wkstn and says 'oops' and closes the window. As for 2-browsers-one-login, that shouldn't be a problem.You just open a link in a new window (or your app does it automatically).A user still has his/her identical cfid and cftoken per workstation, be it a stored or session cookie (unless they close all windows, in which case they have a new problem).I dropped using session cookies from my system default for this reason.Too much of a pain, but I let the developer select it if they are a glutton for punishment. You ought to look at a tabbed browser for multiple windows.Been using NetCaptor for years, but MaxThon is arguably better and free, and then there's FireFox. -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: GODaddy SSL certs
Tim Laureska wrote: Our root certificate - the Valicert Class 2 Policy Validation Authority - is installed in the following browser versions Just as a warning, I've seen some sites state that and then end up with some visitors getting security warnings.Just be careful and double-check their stats if it is important to you. -- *Damien McKenna* - Web Developer - [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 Nothing endures but change. - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: How to prevent multiple logins
Barney Boisvert wrote: Give them a nice message that says someone else logged in with their credendials, and they need to do something about it. I think it all depends on what you want from your app.For some, like a commercial membership site, that would probably be undesirable. Others may want the second login refused flat-out, with security alerts going out to all points. -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: How to prevent multiple logins
My argument isn't for me, but for the average user.They don't know the different between opening another instance of IE versus a new window of the same instance. John -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Friday, October 15, 2004 1:29 PM To: CF-Talk Subject: Re: How to prevent multiple logins Not sure I get what you mean by lost accidentally. Adding an onscreen note to the logged-off individual effectively takes care of help desk issues. You have been logged off because another user has logged on with your credentials at another workstation.You may wish to call Security, or your mommy, or both Then the admins, if informed of the dupe login, can use their who's on viewer to see where the other workstation is, or force them off the system immediately themselves via an administrative logoff. Thats assuming a high-security environment.Generally it just means the user says 'oops', or comes back to their previous wkstn and says 'oops' and closes the window. As for 2-browsers-one-login, that shouldn't be a problem.You just open a link in a new window (or your app does it automatically).A user still has his/her identical cfid and cftoken per workstation, be it a stored or session cookie (unless they close all windows, in which case they have a new problem).I dropped using session cookies from my system default for this reason.Too much of a pain, but I let the developer select it if they are a glutton for punishment. You ought to look at a tabbed browser for multiple windows.Been using NetCaptor for years, but MaxThon is arguably better and free, and then there's FireFox. -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
SOT: Functional roles on web application team
I have lost my bookmark to a page on MM's site that described the different functional roles needed on a team that develops web applications. If I remember correctly they defined about 13 distinct roles and what their responsibilities are. This was in the context of an article on overall web application development. I have spent a couple of hours searching and browsing MM's site but I cannot find it. I did find http://www.macromedia.com/v1/Handlers/index.cfm?ID=17578Method=Full that has similar information but it's not the one I am looking for. Does anyone recognize the article I described and maybe have the URL? Or maybe have another reference that contains similar information?:-) Thanks! George [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Functional roles on web application team
Are you looking for information regarding workflow in content management systems, and terms like author, editor, approver, reviewer, etc. ? :) From: Earl, George [mailto:[EMAIL PROTECTED] Sent: Fri 10/15/2004 8:00 PM To: CF-Talk Subject: SOT: Functional roles on web application team I have lost my bookmark to a page on MM's site that described the different functional roles needed on a team that develops web applications. If I remember correctly they defined about 13 distinct roles and what their responsibilities are. This was in the context of an article on overall web application development. I have spent a couple of hours searching and browsing MM's site but I cannot find it. I did find http://www.macromedia.com/v1/Handlers/index.cfm?ID=17578Method=Full that has similar information but it's not the one I am looking for. Does anyone recognize the article I described and maybe have the URL? Or maybe have another reference that contains similar information?:-) Thanks! George [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Trouble switching JVMs on Linux
Hi all, A server of ours had been having trouble where it would hang frequently (sometimes twice a day, sometimes not for days) with the unexpected signal 11 error as described here: http://www.talkingtree.com/blog/index.cfm?data=""> After a lot of research the general consensus seemed to be that switch JVMs might aleviate the problem and IBM's jvm was among those recommended.I installed the IBMJava2-SDK-1.4.2-0.0.i386.rpm as recommended and changed the jvm.config file to point to /opt/IBMJava2-142/jre/. When I tried to restart the server however I got the following: Error: no `server' JVM at `/opt/IBMJava2-142/jre/bin/server/libjvm.so'. I've switched everything back to using the HotSpot JVM that comes with CFMX but I need to do something about this asap since these crashes will keep happening.I'm assuming there's something in the configuration that I am doing wrong but after trying a few different things it's still honestly beyond me. Any help would be hugely appreciated.Thanks in advance. -martin [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Functional roles on web application team
Micha said: Are you looking for information regarding workflow in content management systems, and terms like author, editor, approver, reviewer, etc. ? :) No, I'm looking for information regarding functional roles on a team of people who build web applications. I'm thinking of roles such as requirements analyst, database modeler, screen designer, graphics designer, usability designer, programmer/coder, etc. The MM article was geared specifically to the web environment and, if I remember correctly, had about 13 distinct roles listed . . . George [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Trouble switching JVMs on Linux
Martin, My blog entry actually recommends using the -Xint JVM argument to disable the Sun JVM HotSpot runtime optimizer.It doesn't recommend using a different JVM. Anyway, the problem you're running into is because while you changed the jvm.config JVM, you probably left the -server switch in the JVM args list. The Sun JVM 1.4 comes with server jvm.dll and a client jvm.dll, and the -server switch tells the JVM to use the server one which is more suited towards applications that are up a long time and load a lot into memory. And BTW, I think this is the primary link to the Sun bug on their Bug Parade: http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=4946706 http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=4946706 -Steve _ From: Martin Olson [mailto:[EMAIL PROTECTED] Sent: Friday, October 15, 2004 2:45 PM To: CF-Talk Subject: Trouble switching JVMs on Linux Hi all, A server of ours had been having trouble where it would hang frequently (sometimes twice a day, sometimes not for days) with the unexpected signal 11 error as described here: http://www.talkingtree.com/blog/index.cfm?data=""> After a lot of research the general consensus seemed to be that switch JVMs might aleviate the problem and IBM's jvm was among those recommended.I installed the IBMJava2-SDK-1.4.2-0.0.i386.rpm as recommended and changed the jvm.config file to point to /opt/IBMJava2-142/jre/. When I tried to restart the server however I got the following: Error: no `server' JVM at `/opt/IBMJava2-142/jre/bin/server/libjvm.so'. I've switched everything back to using the HotSpot JVM that comes with CFMX but I need to do something about this asap since these crashes will keep happening.I'm assuming there's something in the configuration that I am doing wrong but after trying a few different things it's still honestly beyond me. Any help would be hugely appreciated.Thanks in advance. -martin [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
PayPal and But it Now buttons
Ive never used PayPal on a site but guess what now I dont have an option. I see a lot of PayPal stores and buy it now buttons all over the web so I figured someone here has done what I need somewhere down the line. There is absolutely no need for a cart in what I have. Registered users will only be buying one product at a time (limited to one) I had hoped to do simple Buy It Now buttons and pass what I need to PayPal that way. That much was easy. But Im not sure if PayPal confirms a transaction in a way that I can decide rather or not the order went through. Anybody know of any tags? Documentation on but it now? How to test it without it actually having to transfer money between PayPal accounts? Any help at all would be great --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.775 / Virus Database: 522 - Release Date: 10/8/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.775 / Virus Database: 522 - Release Date: 10/8/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Functional roles on web application team
Hi George, Are you looking for this article? http://www.macromedia.com/resources/techniques/ Ketan Patel _ From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 15, 2004 2:53 PM To: CF-Talk Subject: Re: Functional roles on web application team Micha said: Are you looking for information regarding workflow in content management systems, and terms like author, editor, approver, reviewer, etc. ? :) No, I'm looking for information regarding functional roles on a team of people who build web applications. I'm thinking of roles such as requirements analyst, database modeler, screen designer, graphics designer, usability designer, programmer/coder, etc. The MM article was geared specifically to the web environment and, if I remember correctly, had about 13 distinct roles listed . . . George _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: PayPal and But it Now buttons
its pretty easy if ur using dw there are a few extensions for it, u just need to tweak it abitfor dynamic content. pablo has a tut on www.easycfm.com about using there notification upon purchase feature. there are also some test scripts out there u can use with fake transactions and paypal, at least used to have a bit of info on using them on the site -- Original Message -- From: Ewok [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Fri, 15 Oct 2004 15:18:23 -0400 Ive never used PayPal on a site but guess what now I dont have an option. I see a lot of PayPal stores and buy it now buttons all over the web so I figured someone here has done what I need somewhere down the line. There is absolutely no need for a cart in what I have. Registered users will only be buying one product at a time (limited to one) I had hoped to do simple Buy It Now buttons and pass what I need to PayPal that way. That much was easy. But Im not sure if PayPal confirms a transaction in a way that I can decide rather or not the order went through. Anybody know of any tags? Documentation on but it now? How to test it without it actually having to transfer money between PayPal accounts? Any help at all would be great --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.775 / Virus Database: 522 - Release Date: 10/8/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.775 / Virus Database: 522 - Release Date: 10/8/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Functional roles on web application team
I think you mean this one. scroll down halfway http://www.macromedia.com/resources/techniques/define/plan.html [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Functional roles on web application team
the resources section has some good info as well. hope this helps everyone... [EMAIL PROTECTED] 10/15/2004 12:23:54 PM I think you mean this one. scroll down halfway http://www.macromedia.com/resources/techniques/define/plan.html [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: How to prevent multiple logins
If you use session variables to log them in, you can read all information stored in the session scope and compare the login names with whats already in the session. I used something just like this to count how many users were logged in, who was logged in, how many were administrators, how many were normal users. And how many people were just looking at the page but not logged in. Look into coldfusion.runtime.SessionTracker _ From: Tim Do [mailto:[EMAIL PROTECTED] Sent: Thursday, October 14, 2004 3:32 PM To: CF-Talk Subject: How to prevent multiple logins How would I go about preventing multiple logins w/ the same username and password?I'm currently using client variables for this.I tried checking the data field in CDATA but not having any luck.If a user does not log out and just closes the window or the session is timed out, there is still a record in CFDATA w/ the user's username.How do other sites prevent this?? Thanks _ [HYPERLINK http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [HYPERLINK http://www.houseoffusion.com/lists.cfm/link=i:4:181520This Message] [HYPERLINK http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [HYPERLINK http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=678.598.4Fast Unsubscribe] [HYPERLINK http://www.houseoffusion.com/signin/User Settings] [HYPERLINK https://www.paypal.com/cgi-bin/webscr?amount=item_name=House+of+Fusionbus iness=donations%40houseoffusion.comundefined_quantity=cmd=_xclickDonation s and Support] _ HYPERLINK http://www.houseoffusion.com/banners/view.cfm?bannerid=38 \n --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.775 / Virus Database: 522 - Release Date: 10/8/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.775 / Virus Database: 522 - Release Date: 10/8/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: GODaddy SSL certs
Where can you go to check their stats? -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: Friday, October 15, 2004 1:38 PM To: CF-Talk Subject: Re: GODaddy SSL certs Tim Laureska wrote: Our root certificate - the Valicert Class 2 Policy Validation Authority - is installed in the following browser versions Just as a warning, I've seen some sites state that and then end up with some visitors getting security warnings.Just be careful and double-check their stats if it is important to you. -- *Damien McKenna* - Web Developer - [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 Nothing endures but change. - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Trouble switching JVMs on Linux
On Fri, 15 Oct 2004 15:00:14 -0400, Steven Erat [EMAIL PROTECTED] wrote: My blog entry actually recommends using the -Xint JVM argument to disable the Sun JVM HotSpot runtime optimizer.It doesn't recommend using a different JVM. Steve, thanks for writing back and you're correct of course regarding your post. The general consensus I was referring to was I found elsewhere after researching the problem further.The bug parade entry you link for example has a few folks saying they stopped the signal 11 errors by switching to Jrockit.I considered the -Xint workaround you had mentioned but was hoping to avoid the performance hit you mentioned and as mentioned in the comments to your post. Anyway, the problem you're running into is because while you changed the jvm.config JVM, you probably left the -server switch in the JVM args list. The Sun JVM 1.4 comes with server jvm.dll and a client jvm.dll, and the -server switch tells the JVM to use the server one which is more suited towards applications that are up a long time and load a lot into memory. Actually I tried removing the -server switch and coldfusion seemingly started without error, but when I hitting a page I got the following error: error There is no web application configured to service your request I'm probably just missing something here as well? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: GODaddy SSL certs
Tim Laureska wrote: Where can you go to check their stats? Double-check them yourself, as I suggested in a previous email. -- *Damien McKenna* - Web Developer - [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 Nothing endures but change. - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: late night query ?
this was the answer the from statements usually does help eh! and of course naming the db tables correctly cfquery name=qCards datasource=#dsn# username=#un# password=#pw# SELECT * FROM userscards, tblcards WHERE userscards.usersID = '#qgetUser.userID#' AND userscards.cardID = tblcards.CardID /cfquery thanks guys [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: GODaddy SSL certs
Yeah, I know what you said in the previous email... but where do you check stats like that ... is there a web site that tracks this or how would you determine their stats other than relying on what they say in their web site? -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: Friday, October 15, 2004 3:37 PM To: CF-Talk Subject: Re: GODaddy SSL certs Tim Laureska wrote: Where can you go to check their stats? Double-check them yourself, as I suggested in a previous email. -- *Damien McKenna* - Web Developer - [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 Nothing endures but change. - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: GODaddy SSL certs
Tim Laureska wrote: Yeah, I know what you said in the previous email... but where do you check stats like that ... is there a web site that tracks this or how would you determine their stats other than relying on what they say in their web site? I don't know of any off hand.I would say that if a base install of IE 5.0 (e.g. Windows 2000) can't support them then you might consider something else. -- *Damien McKenna* - Web Developer - [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 Nothing endures but change. - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CF_ColoredCode
Does anyone have (or know where I can download) the latest version of Dain Anderson's CF_ColoredCode?cfcomet.com is down... Thanks, Brad [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF_ColoredCode
http://charlie.griefer.com/coloredcode.zip On Fri, 15 Oct 2004 15:50:33 -0400, Brad Roberts [EMAIL PROTECTED] wrote: Does anyone have (or know where I can download) the latest version of Dain Anderson's CF_ColoredCode?cfcomet.com is down... Thanks, Brad [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF_ColoredCode
Just curious...what is it? Ray At 03:50 PM 10/15/2004, you wrote: Does anyone have (or know where I can download) the latest version of Dain Anderson's CF_ColoredCode?cfcomet.com is down... Thanks, Brad [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF_ColoredCode
You're the man!Thanks for the quick response. -Brad - Original Message - From: Charlie Griefer To: CF-Talk Sent: Friday, October 15, 2004 3:55 PM Subject: Re: CF_ColoredCode http://charlie.griefer.com/coloredcode.zip On Fri, 15 Oct 2004 15:50:33 -0400, Brad Roberts [EMAIL PROTECTED] wrote: Does anyone have (or know where I can download) the latest version of Dain Anderson's CF_ColoredCode?cfcomet.com is down... Thanks, Brad [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF_ColoredCode
I bet it colour codes code that is output on apage (i.e. code examples) Years ago...Duncan Campbell that runs/ran asite called www.defusion.com wrote a similar tag...it may still be available there Cheers 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: [EMAIL PROTECTED] web: www.electricedgesystems.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF_ColoredCode
outputs your code to the screen color-coded (a la HomeSite or Dreamweaver).useful if you want to share your code with others. On Fri, 15 Oct 2004 16:02:19 -0400, Ray Champagne [EMAIL PROTECTED] wrote: Just curious...what is it? Ray At 03:50 PM 10/15/2004, you wrote: Does anyone have (or know where I can download) the latest version of Dain Anderson's CF_ColoredCode?cfcomet.com is down... Thanks, Brad [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: GODaddy SSL certs
Tim, Maybe what you should do is check the stats of the sites you propose to install these certs for.Do it for a 1-yr period.If you see an IE5.0 visit percentage, and NN4 (or whatever else that is visible that doesn't conform to GoDaddy's capabilities) then you can expect that percentage of users to be disenfranchised. Respectfully, let me again mention we're talking like ten or fifteen bucks here, assuming reseller accts on both services.Its not a big decision to have to make.You'll lose more than that in time fielding one phone call from a cranky client. One thing I'd also like to counterpoint from an earlier post is that customers are generally ignorant of where the cert comes from (i.e. verisign, getrust etc.) other than to know it came from you and you get the call if it doesn't work perfectly. We'd probably better start winding this up as it is WOT. -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: PayPal and But it Now buttons
You may want to sign up as a PayPal developer, which allows you to use test account. http://developer.paypal.com -Brad - Original Message - From: dave To: CF-Talk Sent: Friday, October 15, 2004 3:23 PM Subject: Re: PayPal and But it Now buttons its pretty easy if ur using dw there are a few extensions for it, u just need to tweak it abitfor dynamic content. pablo has a tut on www.easycfm.com about using there notification upon purchase feature. there are also some test scripts out there u can use with fake transactions and paypal, at least used to have a bit of info on using them on the site -- Original Message -- From: Ewok [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Fri, 15 Oct 2004 15:18:23 -0400 I've never used PayPal on a site but guess what. now I don't have an option. I see a lot of PayPal stores and buy it now buttons all over the web so I figured someone here has done what I need somewhere down the line. There is absolutely no need for a cart in what I have. Registered users will only be buying one product at a time (limited to one) I had hoped to do simple Buy It Now buttons and pass what I need to PayPal that way. That much was easy. But I'm not sure if PayPal confirms a transaction in a way that I can decide rather or not the order went through. Anybody know of any tags? Documentation on but it now? How to test it without it actually having to transfer money between PayPal accounts? Any help at all would be great --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.775 / Virus Database: 522 - Release Date: 10/8/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.775 / Virus Database: 522 - Release Date: 10/8/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: PayPal and But it Now buttons
That will definitely help, thanks a lot _ From: Brad Roberts [mailto:[EMAIL PROTECTED] Sent: Friday, October 15, 2004 4:09 PM To: CF-Talk Subject: Re: PayPal and But it Now buttons You may want to sign up as a PayPal developer, which allows you to use test account. http://developer.paypal.com -Brad - Original Message - From: dave To: CF-Talk Sent: Friday, October 15, 2004 3:23 PM Subject: Re: PayPal and But it Now buttons its pretty easy if ur using dw there are a few extensions for it, u just need to tweak it abitfor dynamic content. pablo has a tut on www.easycfm.com about using there notification upon purchase feature. there are also some test scripts out there u can use with fake transactions and paypal, at least used to have a bit of info on using them on the site -- Original Message -- From: Ewok [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Fri, 15 Oct 2004 15:18:23 -0400 I've never used PayPal on a site but guess what. now I don't have an option. I see a lot of PayPal stores and buy it now buttons all over the web so I figured someone here has done what I need somewhere down the line. There is absolutely no need for a cart in what I have. Registered users will only be buying one product at a time (limited to one) I had hoped to do simple Buy It Now buttons and pass what I need to PayPal that way. That much was easy. But I'm not sure if PayPal confirms a transaction in a way that I can decide rather or not the order went through. Anybody know of any tags? Documentation on but it now? How to test it without it actually having to transfer money between PayPal accounts? Any help at all would be great --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.775 / Virus Database: 522 - Release Date: 10/8/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.775 / Virus Database: 522 - Release Date: 10/8/2004 _ [HYPERLINK http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [HYPERLINK http://www.houseoffusion.com/lists.cfm/link=i:4:181646This Message] [HYPERLINK http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [HYPERLINK http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=678.598.4Fast Unsubscribe] [HYPERLINK http://www.houseoffusion.com/signin/User Settings] [HYPERLINK https://www.paypal.com/cgi-bin/webscr?amount=item_name=House+of+Fusionbus iness=donations%40houseoffusion.comundefined_quantity=cmd=_xclickDonation s and Support] _ HYPERLINK http://www.houseoffusion.com/banners/view.cfm?bannerid=36 \n --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.775 / Virus Database: 522 - Release Date: 10/8/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.775 / Virus Database: 522 - Release Date: 10/8/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Multiple Table Query
Am I going about selecting from two tables in the right manner? 1. Select all email addresses (variable Email) from Table condensed. ID2 is the index 2. Then the entire record for theemail addresses ((variable Email2) table mailistthat match the email addresses in Table condensed Code: CFQUERY NAME=OuterLoop DATASOURCE=BusinessDB#DBTYPE=ODBC SELECT * FROM condensed, maillist WHEREID2 = ID2 AND Email = '#Email2#' /CFQUERY Thanks, Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Multiple Table Query
SELECT maillist.* FROM condensed INNER JOIN maillist ON condensed.email = maillist.email2 That says select everything from the maillist table, where the maillist.email2 field is equal to the condensed.email field.You don't need to select the condensed.email field, because it's guarenteed to be identical to the maillist.email2 field, which is already included in the everything from the maillist table. Note that doing the join on a char field is going to be quite inefficient (read: hella slow). cheers, barneyb On Fri, 15 Oct 2004 16:54:42 -0500, Nick Baker [EMAIL PROTECTED] wrote: Am I going about selecting from two tables in the right manner? 1. Select all email addresses (variable Email) from Table condensed. ID2 is the index 2. Then the entire record for theemail addresses ((variable Email2) table mailistthat match the email addresses in Table condensed Code: CFQUERY NAME=OuterLoop DATASOURCE=BusinessDB#DBTYPE=ODBC SELECT * FROM condensed, maillist WHEREID2 = ID2 AND Email = '#Email2#' /CFQUERY Thanks, Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Multiple Table Query
At 05:54 PM 10/15/2004, Nick Baker wrote: Am I going about selecting from two tables in the right manner? 1. Select all email addresses (variable Email) from Table condensed. ID2 is the index 2. Then the entire record for theemail addresses ((variable Email2) table mailistthat match the email addresses in Table condensed Code: CFQUERY NAME=OuterLoop DATASOURCE=BusinessDB#DBTYPE=ODBC SELECT * FROM condensed, maillist WHEREID2 = ID2 AND Email = '#Email2#' /CFQUERY I think you'll want a JOIN here: CFQUERY NAME=OuterLoop DATASOURCE=BusinessDB#DBTYPE=ODBC SELECT * FROM condensed c JOIN maillist m ON c.ID2 = m.ID2 AND c.Email = '#Email2#' /CFQUERY (assumes you have maillist info for every condensed entry) Cheers, Anders +===+ |Anders GreenEmail: [EMAIL PROTECTED] | |Home: 919.303.0218| |Off Road Rally Racing Team: http://linaracing.com/ | +===+ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Need a Mail Server Solution Pronto!
Hi, all... Here's the deal...I've just now begun to send too much email for clients through CF and I've bumped into a ceiling for daily emails through my ISP's mail server, so I have to get my own running. Still using CF 4.5...Windows 2000 Server...No plans to upgrade CF. Buying another server to function as a mail server is not an option at this time, so I've got to run the mail server for the immediate future on the same box that's serving my websites. Anyone have recommendations for a mail server...as inexpensive as possible? (Can you tell funds are low at the moment?:o) I searched the threads for awhile, but didn't find a discussion of different packages, so I just though I'd ask the question again, especially since I'm still talking CF 4.5.2... Thanks for your suggestions... Rick -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.280 / Virus Database: 264.11.0 - Release Date: 10/14/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Need a Mail Server Solution Pronto!
Rick Faircloth wrote: Anyone have recommendations for a mail server...as inexpensive as possible? (Can you tell funds are low at the moment?:o) IIS SMTP? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Laszlo decision to open source pays a dividend
Apparently Laszlo's decision to open source their software has paid a dividend already.They just raised a further five million dollars in venture capital. http://dbusinessnews.com/shownews.php?type_news=latestnewsid=2506 Haven't downloaded Laszlo yet, but I thought it was kind of interesting. Rick Mason [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Multiple Table Query
Am I going about selecting from two tables in the right manner? 1. Select all email addresses (variable Email) from Table condensed. ID2 is the index 2. Then the entire record for theemail addresses ((variable Email2) table mailistthat match the email addresses in Table condensed Code: CFQUERY NAME=OuterLoop DATASOURCE=BusinessDB#DBTYPE=ODBC SELECT * FROM condensed, maillist WHEREID2 = ID2 AND Email = '#Email2#' /CFQUERY I'm not exactly sure what you're doing with those two tables, but you're not specifying which fields come from which tables in your WHERE clause. Do both tables have a field called ID2? Is it the primary key for one of the tables? Is it the foreign key for the other table? If you want to select all the email addresses from the condensed table, why are you filtering by email address in your query? It sounds to me like you'd be better served with this: SELECT c.Email, m.* FROMcondensed c, maillist m WHEREc.ID2 = m.ID2 Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Need a Mail Server Solution Pronto!
Mercury - FREE www.pmail.com www.coolfusion.com IMS SE? - Original Message - From: Rick Faircloth To: CF-Talk Sent: Friday, October 15, 2004 5:07 PM Subject: Need a Mail Server Solution Pronto! Hi, all... Here's the deal...I've just now begun to send too much email for clients through CF and I've bumped into a ceiling for daily emails through my ISP's mail server, so I have to get my own running. Still using CF 4.5...Windows 2000 Server...No plans to upgrade CF. Buying another server to function as a mail server is not an option at this time, so I've got to run the mail server for the immediate future on the same box that's serving my websites. Anyone have recommendations for a mail server...as inexpensive as possible? (Can you tell funds are low at the moment?:o) I searched the threads for awhile, but didn't find a discussion of different packages, so I just though I'd ask the question again, especially since I'm still talking CF 4.5.2... Thanks for your suggestions... Rick -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.280 / Virus Database: 264.11.0 - Release Date: 10/14/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Laszlo decision to open source pays a dividend
well good then maybe they can get it updated to work with flash past version 5 -- Original Message -- From: Rick Mason [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Fri, 15 Oct 2004 18:03:59 -0400 Apparently Laszlo's decision to open source their software has paid a dividend already.They just raised a further five million dollars in venture capital. http://dbusinessnews.com/shownews.php?type_news=latestnewsid=2506 Haven't downloaded Laszlo yet, but I thought it was kind of interesting. Rick Mason [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Securing the ColdFusion Administrator...
All, I was wondering it there was a way to secure the ColdFusion Adminstrator with Apache's DirectoryMatch Directive. I can't seem to get it to work. For example, if my URL is http://hostname.com/app1/CFIDE/administrator/ This works: DirectoryMatch app1.../DirectoryMatch This does not work: DirectoryMatch CFIDE.../DirectoryMatch I have mulitple instances of ColdFusion running on this system and wanted to use Regex to secure them all. I wonder if this has something to do with the way Apache/JRun works together. Thanks, Troy -- Troy Simpson Applications Analyst/Programmer, OCPDBA, MCSE, SCSA North Carolina State University Libraries Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 E-mail: [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Securing the ColdFusion Administrator...
All, Additionally, this also does not work. Directory /jrunserver/app1/cfusion-ear/cfusion-war/CFIDE/administrator.../Directory But this does work: LocationMatch CFIDE/administrator.../LocationMatch Any ideas why? Thanks, Troy Troy Simpson wrote: All, I was wondering it there was a way to secure the ColdFusion Adminstrator with Apache's DirectoryMatch Directive. I can't seem to get it to work. For example, if my URL is http://hostname.com/app1/CFIDE/administrator/ This works: DirectoryMatch app1.../DirectoryMatch This does not work: DirectoryMatch CFIDE.../DirectoryMatch I have mulitple instances of ColdFusion running on this system and wanted to use Regex to secure them all. I wonder if this has something to do with the way Apache/JRun works together. Thanks, Troy -- Troy Simpson Applications Analyst/Programmer, OCPDBA, MCSE, SCSA North Carolina State University Libraries Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 E-mail: [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]