poll - How many MS should it take to load a site's home page?

2008-01-20 Thread Nate Willard
Looking forward to hearing everyone's thoughts. How many milliseconds should it take for a site's home page to load? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial

Re: poll - How many MS should it take to load a site's home page?

2008-01-20 Thread s. isaac dealey
IIRC when Macromedia had launched their new website a few years ago (Dylan I think they called it), they published a few articles that described web-wide averages as well as their own targets (the research they'd done during the planning phase). They hit their target of having pages load

Re: CFFile Hangs ColdFusion

2008-01-20 Thread Richard Steele
Hi Azadi, Something in the system is causing the temp folder to be deleted. So I instituted the hack until I can figure out the cause of the unexpected deletions. I'm suspecting that the unexpected deletion of the temp folder is due to not using cflock around either the CFFILE Upload or Move

Re: Coldfusion Tutorial Collections (web_based tutorials)

2008-01-20 Thread Ali Majdzadeh
http://learncf.com These are all new tutorials, all published last year and I have about 6 to publish. The quantity isn't that high, but it's a new site. Great site: Thanks. It looks to be a good start. With a better categorization it will a great tutorial collection.

date problem

2008-01-20 Thread Richard White
Hi, i have been playing around with date formats for ages and still encountering problems. i am in the uk and have set the following code when someone logs in: cfset SetLocale(English (UK)) i have dates stored in a mysql db which is in the format /mm/dd when i try to get data out of the

RE: poll - How many MS should it take to load a site's home page?

2008-01-20 Thread Bobby Hartsfield
I believe users are generally okay with waiting a little longer for pages that are returning data dynamically from a search for example Well, the kind of users who visited MM may be a good basis for that but the average user doesn't know or care that there is a database even involved. They

Re: date problem

2008-01-20 Thread Richard White
hi, i have just tried it by using dateformat instead of lsdateformat and it worked fine. i dont understand, does anyone know what the lsdateformat really does and why the lsdateformat would now work but the dateformat did thanks

Re: date problem

2008-01-20 Thread Claude Schneegans
i have just tried it by using dateformat instead of lsdateformat and it worked fine. Again, WHERE does is work, and WHERE doesn'it ? If it is in an UPDATE or INSERT SQL statement, it may work, or not, depending of the way CF will interpret the data as a date. In SQL, you should always use

Re: Coldfusion Tutorial Collections (web_based tutorials)

2008-01-20 Thread Azadi Saryev
Peter Donahue wrote: Good afternoon everyone, And tutorials that are displayed on one page in their entirety and free of advertisements. I can't stand viewing tutorials that make you select a, Next link to view additional sections. Reference and Named anchors would most of them do

Re: date problem

2008-01-20 Thread Claude Schneegans
i have dates stored in a mysql db which is in the format /mm/dd First of all, unless your date field has text type and you store the date as a string, the db format is not /mm/dd. It is some floating value specific to the database. Some early db systems would store it as a string

Re: date problem

2008-01-20 Thread Richard White
Hi Claude, we use mysql 5.0 and it does store the date as /mm/dd. we run a query to get the date out. then its just the following piece of code that doesnt work: cfset dateOfBirth = lsdateformat(queryName.dateofbirth,dd/mm/) it 'spits' out the error stated above 'invalid date format

RE: poll - How many MS should it take to load a site's home page?

2008-01-20 Thread Jim Davis
-Original Message- From: Nate Willard [mailto:[EMAIL PROTECTED] Sent: Sunday, January 20, 2008 3:35 AM To: CF-Talk Subject: poll - How many MS should it take to load a site's home page? Looking forward to hearing everyone's thoughts. How many milliseconds should it take for a

RE: poll - How many MS should it take to load a site's home page?

2008-01-20 Thread Jim Davis
-Original Message- From: s. isaac dealey [mailto:[EMAIL PROTECTED] Sent: Sunday, January 20, 2008 5:06 AM To: CF-Talk Subject: Re: poll - How many MS should it take to load a site's home page? IIRC when Macromedia had launched their new website a few years ago (Dylan I think they

RE: poll - How many MS should it take to load a site's home page?

2008-01-20 Thread Dave Francis
Slightly different scenario, but back in the days of big iron (CICS and 3270? terminals), IBM came up with a study that stated that anything over a 2sec response time caused anxiety in the user. -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Sunday, January 20, 2008

RE: date problem

2008-01-20 Thread Dave Watts
then its just the following piece of code that doesnt work: cfset dateOfBirth = lsdateformat(queryName.dateofbirth,dd/mm/) it 'spits' out the error stated above 'invalid date format 01/16/1990' it is saved in the db as 1990/01/16, im not telling it to put it in the format

RE: setting up testing server for dummies...

2008-01-20 Thread Dave Watts
will it move iis settings and such. what about macros that may interact with current sql server, that i may NOT be aware of since i am no dba... VMware Converter creates a complete copy of the individual machine from which you run it. Dave Watts, CTO, Fig Leaf Software

Re: date problem

2008-01-20 Thread Claude Schneegans
we use mysql 5.0 and it does store the date as /mm/dd. This this actually how your database will *display* the date, but internally, it is stored as a 3 bytes integer value. (see http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html ) But are you sure the field is defined as a

RE: date problem

2008-01-20 Thread Jim Davis
-Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Sunday, January 20, 2008 3:03 PM To: CF-Talk Subject: Re: date problem But are you sure the field is defined as a *date* type, or as a string? Anyway, CF should be able to recognize the format even if it

Re: database structure for tagging

2008-01-20 Thread Kay Smoljak
On Jan 18, 2008 6:39 PM, Assistenza Sito [EMAIL PROTECTED] wrote: http://www.petefreitag.com/item/396.cfm http://www.whatspop.com/blog/2005/12/my-coldfusion-tagging-enginelibrary.cfm http://www.whatspop.com/blog/2006/01/setting-up-database-for-tagging.cfm Thanks Luca. Pete Freitag's post had

SCOPE_IDENTITY() not returning real column name?

2008-01-20 Thread Kay Smoljak
I have a site that uses an SQL Server database. I'm pretty sure this was working before but now it's not (shared hosting database, so I have no control over that part). Usually to return the last inserted ID, I run a select after an insert like so: cfquery datasource=#dsn# name=qry SET NOCOUNT

Re: SCOPE_IDENTITY() not returning real column name?

2008-01-20 Thread Kay Smoljak
On Jan 21, 2008 7:39 AM, s. isaac dealey [EMAIL PROTECTED] wrote: Likely what happened is they changed or updated the driver for their SQL Server databases (or possibly MDAC or some other modification to the server itself - I'm not sure offhand if MDAC is omitted with Java drivers or not) and

Re: SCOPE_IDENTITY() not returning real column name?

2008-01-20 Thread Kay Smoljak
On Jan 21, 2008 7:29 AM, Michael Traher [EMAIL PROTECTED] wrote: HI Kay, It looks to me like the select should be select scope_identity() as formatid from format i.e. the 'as' refers to the column rather than the table which is how I read your sql. Haha - all I can say is d'oh!. The reason

Re: SCOPE_IDENTITY() not returning real column name?

2008-01-20 Thread s. isaac dealey
Likely what happened is they changed or updated the driver for their SQL Server databases (or possibly MDAC or some other modification to the server itself - I'm not sure offhand if MDAC is omitted with Java drivers or not) and the new or updated driver, etc. just isn't supporting that syntax...

Re: SCOPE_IDENTITY() not returning real column name?

2008-01-20 Thread Michael Traher
HI Kay, It looks to me like the select should be select scope_identity() as formatid from format i.e. the 'as' refers to the column rather than the table which is how I read your sql. On Jan 20, 2008 10:01 PM, Kay Smoljak [EMAIL PROTECTED] wrote: I have a site that uses an SQL Server

Re: date problem

2008-01-20 Thread Claude Schneegans
I think that the dateFormat() functions will consider any string passed as a numerical representation of the date unless it's quoted. All CF function will take ANYTHING, strings, numerics or dates (which are float values anyway), if it can be converted to a date, CF will convert it prior

Re: SCOPE_IDENTITY() not returning real column name?

2008-01-20 Thread s. isaac dealey
Thanks Isaac, that's interesting... I'd never really thought about how I used that code at all, I just pasted in the example from MSDN and it had the right end result so I ran with it. You're right about it returning multiple rows - that's inefficient. So it is actually returning multiples?

Re: SCOPE_IDENTITY() not returning real column name?

2008-01-20 Thread Kay Smoljak
On Jan 21, 2008 8:27 AM, s. isaac dealey [EMAIL PROTECTED] wrote: So it is actually returning multiples? And MSDN gave you that as the example... heh... that's kinda funny. It's been a little while since I worked with scope_identity() -- at my day job currently we're using mostly MS variety of

RE: cfwindow again

2008-01-20 Thread Andrew Scott
Not sure of the exact problem, without seeing some code. But make sure all JS is in the head tags. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613  9015 8628 Mobile: 0404 998 273 -Original Message- From: Don L [mailto:[EMAIL PROTECTED] Sent:

cfwindow again

2008-01-20 Thread Don L
I'm not sure if I'm kind of stretching cfwindow tag or simply not knowing its intricacy with javascripts enough. In essence, I have the core of an app running within a cfwindow (let's called it AppCore.cfm, function-wise, within it, cfcs,modules are being called etc. etc... reasonably

Re: cfwindow again

2008-01-20 Thread Azadi Saryev
what's the problem exactly? --- Azadi Saryev Sabai-dee.com http://www.sabai-dee.com Don L wrote: I'm not sure if I'm kind of stretching cfwindow tag or simply not knowing its intricacy with javascripts enough. In essence, I have the core of an app running within a cfwindow (let's called

RE: date problem

2008-01-20 Thread Jim Davis
-Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Sunday, January 20, 2008 6:21 PM To: CF-Talk Subject: Re: date problem I think that the dateFormat() functions will consider any string passed as a numerical representation of the date unless it's quoted.

Re: date problem

2008-01-20 Thread Azadi Saryev
if it is same for dateformat() and lsdateformat(), why would they return different results then? --- Azadi Saryev Sabai-dee.com http://www.sabai-dee.com Jim Davis wrote: This is what I was remembering - from the docs for lsdateformat and dateformat: When passing date/time value as a

Re: cfwindow again

2008-01-20 Thread Don L
Interesting thought, Andrew, I intend to place js inside header tag. Yes, they are all inside header for this app as well. For those who might use cfwindow, js needs to be placed at root level (where cfwindow is launched, at least that's my experience). Please see my response to Azadi for

Re: cfwindow again

2008-01-20 Thread Don L
Azadi, Let me try to describe it as follows: With cfdebug on, a) when the the AppCore.cfm is lauched, it defaults to the {main} tab, debugging window indicates everything is ok. and function-wise, everyting function is working fine. b) when the {help} tab is clicked, debugging window has the

Re: date problem

2008-01-20 Thread Claude Schneegans
So it definitely seems like CF treats the input differently somehow. Not really. CF is a typeless language. It is SGML compliant and HTML compatible. So by definition, EVERYTHING is passed as a string in attributes, even if there is no quotation mark. For function calls, it is a bit

Re: cfwindow again

2008-01-20 Thread Azadi Saryev
can you post your code? as usual, it can be a million different things at play here... --- Azadi Saryev Sabai-dee.com http://www.sabai-dee.com Don L wrote: Azadi, Let me try to describe it as follows: With cfdebug on, a) when the the AppCore.cfm is lauched, it defaults to the {main} tab,

Re: cfwindow again

2008-01-20 Thread Don L
typo of b) set var s for selected without opposite value of var uState , meant, b) set var s for selected with opposite value of var uState ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release

Re: cfwindow again

2008-01-20 Thread Don L
a) when the the AppCore.cfm is lauched, it defaults to the {main} tab, debugging window indicates everything is ok. and function-wise, everyting function is working fine. b) when the {help} tab is clicked, debugging window has the following err msg: Oh, I forgot to add, c) after some

Re: cfwindow again

2008-01-20 Thread Don L
can you post your code? as usual, it can be a million different things at play here... ok, streamline them into two bare minimal: TopLevel: cfajaximport tags=cflayout-tab,cfform,CFDIV,CFINPUT-AUTOSUGGEST,cftooltip html xmlns=http://www.w3.org/1999/xhtml; head titlebla bla app/title meta

RE: date problem

2008-01-20 Thread Jim Davis
-Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Sunday, January 20, 2008 10:48 PM To: CF-Talk Subject: Re: date problem So it definitely seems like CF treats the input differently somehow. Not really. CF is a typeless language. It is SGML

Re: date problem

2008-01-20 Thread Claude Schneegans
so I assume it differs somehow. Well, there is actually a difference: If you pass the date as a date to dateformat(), ie: dateFormat(now()...), there is no ambiguity. It will always work. However, if you pass it as a string, CF will have to convert it, and if you work with dates in ISO format,

Re: Cookie Question - Is this implementation even a good performance/technical Idea?

2008-01-20 Thread Nate Willard
james, Thanks for the reply. My hesitation with using cf client variables is that I'd need to enable clientmanagement, which I currently don't have enabled. Wouldn't that add a lot of extra overhead for this one feature I'd like to add? Also, doesn't clientmanagement then append a CFID to the

RE: Cookie Question - Is this implementation even a good performa nce/technical Idea?

2008-01-20 Thread Dave Watts
Thanks for the reply. My hesitation with using cf client variables is that I'd need to enable clientmanagement, which I currently don't have enabled. Wouldn't that add a lot of extra overhead for this one feature I'd like to add? If you're using session management, there's no need to

Re: cfwindow again

2008-01-20 Thread Andrew Scott
Why do you have the cfwindow in a table? On 1/21/08, Don L [EMAIL PROTECTED] wrote: typo of b) set var s for selected without opposite value of var uState , meant, b) set var s for selected with opposite value of var uState

Re: SCOPE_IDENTITY() not returning real column name?

2008-01-20 Thread s. isaac dealey
Cheers for your help Isaac. Any time. :) Your description of why you use ColdFusion pretty well sums up my reasons in addition to my reasons for creating the framework. heh :) I was just updating the wikipedia article the other day because the mods had marked it as a stub and went so far as