Re: [OT] Generic Database Design Opinions?

[Jochem van Dieten]

Jim Davis wrote:
>  
> Right now there is a proposal on the table to truly genericize the 
> consolidated table.  Instead of (say) columns like “PolicyNumber”, 
> “ArchiveID” and “SSN” the new table might have “Key1”, 
> “Key2”, “Key3”, etc.  Each of these columns would be open, 
> essentially, to any data type and what appeared in them would depend on the 
> source archive of the record.

This is generally known as an Entity-Attribute-Value model:
http://en.wikipedia.org/wiki/Entity-Attribute-Value_model


> Current structure:
>  
> IDSourceFName   LName   PolicyNumber  AccountCode  SSN
> --
> 1   A   Jim Davis     null null
> 2   B   nullnull2 231234-d 123456789
>  
> Would become:
>  
> IDSource   Attribute Value
> --
> 1 AFName Jim
> 1 ALName Davis
> 1 APolicyNumber  
> 2 BPolicyNumber  2
> 2 BAccountCode   231234-d
> 2 BSSN   123456789
>  
> Of course this would “stretch” the tables (our 5-6 million rows might 
> become 40 million) but it would allow for complete control when adding new 
> search criteria or fields.  (Of course the system would probably be 
> normalized with a separate “Attributes” table with the main table joined 
> to it).  I'm not sure how performance would suffer (obivously every column 
> but "value" would be indexed).

You are not indexing value? Not even a composite index on both attribute 
and value? Then how is "WHERE Attribute = 'LName' AND Value = 'Davis'" 
going to perform?


> Any thoughts?  Comments?  Resources you’d like to share?  Have I even made 
> myself clear?

Moving from your current model to an EAV is so simple that my 
recommendation would be to just try it. It shouldn't take more then half 
an hour + processing time. When you have done that, try to run some of 
your current searches against the new model to see if you can get the 
data that you need in the time that you need it. Some things to include 
in your tests are queries you used to express as:
- where A = X and B <> Y
- where A = X and B NOT IN (Y, Z)
- queries with typecasting
   - order by X (where X was numeric but is now stored as a string)
   - where A = B with both floats

Jochem


~|
ColdFusion MX7 and Flex 2 
Build sales & marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275919
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: cfscript and javascript

[Dan G. Switzer, II]

>biggest difference is that cfscript uses CFML comparison operators...

I would argue the biggest difference is that  executes on the
server while  executes in the browser. This also means your
 is actually being compiled down to Java byte code.

-Dan


~|
Create Web Applications With ColdFusion MX7 & Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275922
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Client-side validation or Server-side Validation?

[Rick Faircloth]

Les...

Was this info helpful to you in solving your problems
with clients who don't have JS turned on?

Rick

-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, April 18, 2007 10:46 PM
To: CF-Talk
Subject: RE: Client-side validation or Server-side Validation?

It's a very good method, Les... although I can't take credit for it.
It was passed on to me a long time ago.  No client-side validation at all.

Here's a code sample involving two form fields, First_Name & Last_Name.
The page, Name_Form.cfm contains the validation code, error messages
display,
form and inputs.

Page:  Name_Form.cfm











 
 





 

  

  


 

  

  


 







 
 

 

  








 

 "I'm sorry, but there are problems with your required entries.  Please
check your entries, make necessary corrections, and re-submit."
 






 





 
  
   #Form_Errors.First_Name#
  
 



 
  
   First Name (required)
  
 

 
  
   

   

   
  
 

 

 
  
   #Form_Errors.First_Name#
 
 

 
  
   Last Name (required)
  
 

 
  
   

   

   
  
 

 
  
   
  
 











Page:  Form_Submission_Success.cfm








The Name Form has been successfully submitted!







And that's a basic layout of the code...

I've attached the two pages involved.  You can run them on a server and
study them
or you can view them at work at
http://bodaford.whitestonemedia.com/html/Name_Form.cfm

Let me know if this helps or what doesn't make sense...

Rick






-Original Message-
From: Les Mizzell [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, April 18, 2007 5:48 PM
To: CF-Talk
Subject: Re: Client-side validation or Server-side Validation?

What you're doing below sounds exactly like what I need for some 
specific forms that seem to have  lot of business users with no JS. I 
haven't completely wrapped my head around what you're doing though.

Is there a good reference for your method somewhere on the web I can 
study, or do you mind going a little deeper into detail?

Thanks, LGM








~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275923
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: OnSessionEnd runnning TWICE

[Cutter (CFRelated)]

Julio,

Check out Aaron West's "ColdFusion MX 7 Login Security" tutorial in the 
Tutorials section of his site (http://www.trajiklyhip.com). It has solid 
code and examples/explanations about how to go about this task. He also 
has a tutorial for CF 6 as well.

Steve "Cutter" Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
_
http://blog.cutterscrossing.com

Julio Cesar Lima wrote:
> Hi guys,
> 
> I'm trying to count the number of sessions, and I'm getting crazy with this.
> 
> I have the following code on my onApplicationStart:
> 
> 
> 
> 
> then I have this on my OnSessionStart:
> 
> 
> 
> 
> 
> and finally I have this on my onSessionEnd:
> 
> 
> 
> 
> 
> 
> The onSessionEnd is executed twice. SO if I have numSessions = 4, if one 
> sessions expires, instead I have 3, I will have 2. :(. I place a cflog, and 
> logs twice. There are not cflocks nested on anything like it.
> 
> I hope you guys can help me
> 
> Thank you
> 
> JC
> 
> 

~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275931
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Date Not Formatting Correctly

[Claude Schneegans]

 >>cf datetime objects are decimal days since 31-dec-1899

Gee, I didn't know CF was that old!
(sorry, just couldn't resist ;-)

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275920
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Broadcasting RSS from your site

[Pete Ruckelshaus]

I just wrote ann app that does this yesterday.  I'm using a CFC that gets
both arguments and a query passed in, and it spits out RSS.  I consider the
code to be "working" as opposed to "working, with an elegant
implementation".  It's still under development, so there's a lot of
"localhost" stuff in there, but this will give you a shove in the right
direction.

The CFC:



 
 
 
 
  
  http://#CGI.server_name#/"
required="No" type="String">
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  




 
  #arguments.channel_title#
  #arguments.channel_link#
  #arguments.channel_description#
  #arguments.channel_language#
  #arguments.channel_copyright#
  
#arguments.channel_managingEditor#
  #arguments.channel_webMaster#
  #arguments.channel_pubDate#
  #arguments.channel_lastBuildDate#
  #arguments.channel_category#
  #arguments.channel_generator#
  #arguments.channel_docs#
  #arguments.channel_cloud#
  #arguments.channel_ttl#
  #arguments.channel_image#
  #arguments.channel_rating#


 
  title = replace(qryRSS.title[i], "<", "<", "ALL");
  description = replace(qryRSS.description[i], "<", "<", "ALL");
  description = replace(description, "&", "&", "ALL");
  description = replace(description, "'", "''", "ALL");
  author = replace(qryRSS.author[i], "<", "<", "ALL");
  author_email = replace(qryRSS.author_email[i], "at>", "@", "ALL");
  author_email = replace(author_email, "<", "<", "ALL");
  date = dateFormat(qryRSS.date[i], "ddd, dd mmm ");
  time = timeformat(qryRSS.date[i], "HH:mm:ss") & " EST";
  guid = qryRSS.guid[i];
 

 #title#
 #description#
 #author_email#
(#author#)
 #date# #time#
 #guid#






  
 




And here's the CFM page that calls the above CFC:




 
  
   SELECT  C.vchContentTitle AS title, C.vchContentBody AS description,
C.dteDatePublished AS date,
  '' AS author, '[EMAIL PROTECTED]' as author_email,
  'http://localhost/?id=' + CAST(C.intContentID AS varchar(20)) AS guid
   FROM  tblContent C
   WHERE  C.dteDatePublished <= getdate() AND
  C.bitVisible = 1
  
  
 


 
 http://localhost/";>
 
 
 


#trim(rss)#



~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275921
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: [OT] Generic Database Design Opinions?

[Jim Davis]

> -Original Message-
> From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
> Sent: Friday, April 20, 2007 7:41 AM
> To: CF-Talk
> Subject: Re: [OT] Generic Database Design Opinions?
> 
> Jim Davis wrote:
> >
> > Right now there is a proposal on the table to truly genericize the
> consolidated table.  Instead of (say) columns like “PolicyNumber”,
> “ArchiveID” and “SSN” the new table might have 
> “Key1”,
> “Key2”, “Key3”, etc.  Each of these columns would be 
> open,
> essentially, to any data type and what appeared in them would depend on
> the source archive of the record.
> 
> This is generally known as an Entity-Attribute-Value model:
> http://en.wikipedia.org/wiki/Entity-Attribute-Value_model

Great!  I knew it had a name but I couldn't find it.

No maybe I can do some usable research on it.  ;^)

> You are not indexing value? Not even a composite index on both
> attribute
> and value? Then how is "WHERE Attribute = 'LName' AND Value = 'Davis'"
> going to perform?

That's true.  My thinking (when I wrote that) was that since "Value" could (and 
would) be essentially any datatype an index wouldn't be all that useful - but 
yes, that's obviously wrong.

> > Any thoughts?  Comments?  Resources you’d like to share?  Have I
> even made myself clear?
> 
> Moving from your current model to an EAV is so simple that my
> recommendation would be to just try it. It shouldn't take more then
> half
> an hour + processing time.

I hope to try... if I can get space in the MainFrame region (due to costs our 
development and integration regions don't have the capability to store the 
complete dataset - not even a significant chunk of it).  I'm not a DBA or admin 
on these systems - NOTHING is simple when dealing with corporate infrastructure 
 teams.  ;^)

Still, even if I could get a small comparison set - perhaps a few hundred 
thousand records.  That would at least tell us whether it's worth it to pursue 
on a larger scale.

As an aside, I'm not being asked to look at this as a database expert - because 
I'm not a database expert (not even close, especially at these scales). Rather 
as the new person on the team I'm being asked to provide an unbiased impression 
of the current system and offer ideas of where we might go. Just a "hey, you've 
been around systems like this for a long time, whatcha think?" kind of thing.

Jim Davis


~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275924
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: [OT] Generic Database Design Opinions?

[Jim Davis]

> -Original Message-
> From: Gert Franz [mailto:[EMAIL PROTECTED]
> Sent: Friday, April 20, 2007 2:19 AM
> To: CF-Talk
> Subject: Re: [OT] Generic Database Design Opinions?
> 
> Hi Jim,
> 
> it is an every day problem. Like Deanna said. Materialize your query
> table into a new (maybe even in an other database) table. The thing is,
> that this table would be generated eg. once every night. Then on this
> new table generate all kinds of indexes. Since it is not subject to a
> lot of changes (only once a night).
> So your new table is not represented by a view or 'on the fly' query
> but
> by a physical table with primary key, clustered and non clustered
> indexes.

Right now I don't think that would fly - I'm not sure what the acceptance
level for stale data actually is, but I know that it's much less than a day.
I know that Live would be preferred, but my impression (I'm new to the team)
is that not more than 10 minutes or so is the requirement. 

For a little more background:

The various business unit archives are actually generated by a mainframe
vendor application.  We have no control over it in that respect - it creates
the archives as it does.  But the vendor app itself doesn't support
searching over multiple archives, thus our consolidation table.  That table,
now, is populated (live) via triggers on the individual archive tables (my
understanding is that updates are regular, but not over-whelming: perhaps
several hundred new documents per day... although that could be per
archive).

To initial goal is to improve the time-to-market for new business unit
archives and reducing (or eliminating) modifications needed to the
consolidated table is a big part of that.  So we're looking at options. 

Jim Davis


~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275925
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

OnSessionEnd runnning TWICE

[Julio Cesar Lima]

Hi guys,

I'm trying to count the number of sessions, and I'm getting crazy with this.

I have the following code on my onApplicationStart:




then I have this on my OnSessionStart:





and finally I have this on my onSessionEnd:






The onSessionEnd is executed twice. SO if I have numSessions = 4, if one 
sessions expires, instead I have 3, I will have 2. :(. I place a cflog, and 
logs twice. There are not cflocks nested on anything like it.

I hope you guys can help me

Thank you

JC

~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275926
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Broadcasting RSS from your site

[Dawson, Michael]

I can't think of a specific article, but here is my entire code.
Actually, it's quite simple to produce a feed.  All you gotta do is
follow a particular XML format.

M!ke


SELECT
vacancyID
,vacancyTitle
,vacancyType
,vacancyStartDate
,vacancyDesc
,lastModified
FROM
EmpVacancy





University of Evansville Employment Opportunities
http://www.evansville.edu/aboutue/employment.asp
University of Evansville's current open employment
opportunities
Human Resources
#year(now())# University of
Evansville.  All rights reserved.



http://www.evansville.edu/aboutue/employment.asp?vactype=All
vacancy#xmlFormat(jobs.vacancyID)#
#dateFormat(dateConvert("local2utc",
jobs.lastModified), "ddd, d mmm ")#
#timeFormat(dateConvert("local2utc", jobs.lastModified), "HH:mm:ss")#
GMT




 

-Original Message-
From: Adrian Wagner [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 19, 2007 10:07 PM
To: CF-Talk
Subject: RE: Broadcasting RSS from your site

Interesting. Can you elaborate on that a bit - or point to a good
article. Would be interested in techy side of doing it.
 
Adrian

~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275927
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Broadcasting RSS from your site

[Dawson, Michael]

In my case, our job openings feed probably isn't getting hit as much as
most other feeds.  So, I feel it's OK to have it generated dynamically.

Personally, I would start with a dynamic feed, then, if site traffic
requires so, I would then rewrite it to save a static file.

If you have CF Enterprise, you could dedicate an instance to the feed so
that it doesn't affect the rest of your site, of course.

Let me end by saying I'm not an RSS feed pro.  I just found an example,
then put some CF tags around it.

M!ke 

-Original Message-
From: Les Mizzell [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 19, 2007 11:04 PM
To: CF-Talk
Subject: Re: Broadcasting RSS from your site

> Why write the file?  Why not dynamically generate the feed when it's 
> requested by a reader?

Point me to an example of this somewhere? Would like to evaluate the
best way to do this based on the material the client wants to publish.

Thanks,

Les

~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275928
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: cfscript and javascript

[Charlie Griefer]

On 4/20/07, Dan G. Switzer, II <[EMAIL PROTECTED]> wrote:
> >biggest difference is that cfscript uses CFML comparison operators...
>
> I would argue the biggest difference is that  executes on the
> server while  executes in the browser. This also means your
>  is actually being compiled down to Java byte code.

Aye, but he was asking for syntax differences :)


-- 
Charlie Griefer


"...All the world shall be your enemy, Prince with a Thousand Enemies,
and whenever they catch you, they will kill you. But first they must catch
you, digger, listener, runner, prince with a swift warning.
Be cunning and full of tricks and your people shall never be destroyed."

~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275930
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: OnSessionEnd runnning TWICE

[Peterson, Chris]

Julio,

There is a much easier way to count sessions, here is some simple code
=)




sessiontrackerObj=
createObject("java","coldfusion.runtime.SessionTracker");
activesessions =
sessiontrackerObj.getSessionCollection(application.applicationname);
nosessions=ListLen(structkeyList(activeSessions));


Total Sessions : #nosessions#



 - Chris Peterson

~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275929
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Something to think about

[Bruce Sorge]

I am sure that some of you know about this, but google collects and saves
your search history. I just read this (
http://news.com.com/8301-10784_3-9710855-7.html?part=rss&subj=news&tag=2547-1_3-0-5).
I installed the Google Web History product, and it goes back as far as 9/06.
The other part of the story is that they are partnering with a major
advertising company, DoubleClick. Of course there is a way to turn this
feature off, but for the less tech savvy folks out there, their on-line life
is out there.


-- 
Bruce Sorge

"I'm a mawg: half man, half dog. I'm my own best friend!"


~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275933
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Something to think about

[Bruce Sorge]

Sorry, meant to send this to cf-community. Apoligies. I will move it to
there.


> Bruce Sorge
>
> "I'm a mawg: half man, half dog. I'm my own best friend!"


~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275934
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: reversal?

[Sam Farmer]

Isn't there a Friends episode where they discuss why on a scale of
1-10 that 10 is the highest?  I think you are going to run into that
issue here.

My suggestion would be to reverse your results via a mapping in a
structure that would take take 1 and make it 10 and 10 and make it 1.
Or perhaps making it negative and messing with the scale.

Just thinking out loud.

HTH,

Sam Farmer

On 4/19/07, Will Tomlinson <[EMAIL PROTECTED]> wrote:
> I have a ranking system in which items are scored, say 1-3. 1 being the 
> highest ranking.
>
> I'm displaying these in a bar chart, but the item with the highest ranking is 
> lowest on the chart, which is correct, but misleading at first glance. The 
> chart naturally pushes the item with the highest value to the top.
>
> Is there a way to force the lowest ranked bar to the top. I tried to scale 
> from 3 to 1 but it didn't work.
>
> Thanks,
> Will
>
> 

~|
Create Web Applications With ColdFusion MX7 & Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275932
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Decimal field

[Richard Cooper]

Hi all,

I have two pratically identical SQL statements. The only difference is this 
line:

AND RP.productID = 

When this line is included the output of the decimal field RP.options changes 
from 2.50 to 2

Here are the two statements:

==
Statement 1
==


SELECT  RP.productID
,RP.productTitle
,RP.bookingcode
,RP.priority
,RP.options
,count(RI.itemTitle) as numbItems
,RI.itemID
,RI.itemTitle
,RI.bookingcode as bookingcode2
,RI.itemstartdate 
,RI.itemenddate 
FROMreg_products as RP
LEFT OUTER JOIN
reg_products_list as RPL
ON  RP.productID = RPL.productID
AND RP.productID = 
LEFT OUTER JOIN
reg_items as RI
ON  RPL.itemID = RI.itemID
WHERE   RP.active = '1'
AND RP.eventID = '#theEventID#'
AND RP.lingo = '#theLingo#'
GROUP BY RP.productID
,RI.itemID
,RP.productTitle
,RP.bookingcode
,RP.priority
,RI.itemTitle
,RI.bookingcode
,RI.itemstartdate 
,RI.itemenddate 
,RP.options
ORDER BY RP.priority


==
Statement 2
==


SELECT  RP.productID
,RP.productTitle
,RP.bookingcode
,RP.priority
,RP.options
,count(RI.itemTitle) as numbItems
,RI.itemID
,RI.itemTitle
,RI.bookingcode as bookingcode2
,RI.itemstartdate 
,RI.itemenddate 
FROMreg_products as RP
LEFT OUTER JOIN
reg_products_list as RPL
ON  RP.productID = RPL.productID
LEFT OUTER JOIN
reg_items as RI
ON  RPL.itemID = RI.itemID
WHERE   RP.active = '1'
AND RP.eventID = '#theEventID#'
AND RP.lingo = '#theLingo#'
GROUP BY RP.productID
,RP.productTitle
,RI.itemID
,RP.bookingcode
,RP.priority
,RI.itemTitle
,RI.bookingcode
,RI.itemstartdate 
,RI.itemenddate 
,RP.options
ORDER BY RP.priority


Any ideas how to fix this problem?

~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275935
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Is there a CF equivalent to this?

[Rick Faircloth]

HTTP_X_ REQUESTED_WITH  ?

GetHTTPRequestData ?

Or something else (compatible with CF 4.5 or is
GetHTTPRequestData at post-CF 4.5 function?)

Rick



~|
ColdFusion MX7 and Flex 2 
Build sales & marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275936
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Decimal field

[Jochem van Dieten]

Richard Cooper wrote:
> 
> I have two pratically identical SQL statements. The only difference is this 
> line:
> 
> AND   RP.productID =  cfsqltype="cf_sql_integer" />
> 
> When this line is included the output of the decimal field RP.options changes 
> from 2.50 to 2

Use cf_sql_decimal as the cfsqltype.

Jochem

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275937
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: manipulating array values

[Steve Brownlee]

The problem is the Evaluate function you have in the REReplace call.
Get rid of that and it should work fine.


Steve Brownlee
http://www.fusioncube.net/


> -Original Message-
> From: Scott Stewart [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, April 19, 2007 4:59 PM
> To: CF-Talk
> Subject: manipulating array values
> 
> Hey all
> 
>  
> 
> Can somebody tell me why this doesn't work

~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275938
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: OnSessionEnd runnning TWICE

[Dana Kowalski]

I'm the only one accessing my development equipment at the moment (only one in 
2 days to have as well), and the below code shows 3 connected sessions.


>Julio,
>
>There is a much easier way to count sessions, here is some simple code
>=)
>
>
>
>
>sessiontrackerObj=
>createObject("java","coldfusion.runtime.SessionTracker");
>activesessions =
>sessiontrackerObj.getSessionCollection(application.applicationname);
>nosessions=ListLen(structkeyList(activeSessions));
>
>
>Total Sessions : #nosessions#
>
>
>
> - Chris Peterson

~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275939
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Base64 to File

[Bobby Schuchert]

I am trying to convert (or at least display on the screen) the value of the 
cgi.client_cert_encoded variable.

I have tried using tostring() to convert it so I can output a text file or show 
it on the screen. 

Can anyone tell me what I need to do to view it or use it in cffile?

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275940
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Decimal field

[Richard Cooper]

Why would that work? URL.productID is an integer and the PK of the that table 
productID being decimal or integer shouldn't affect the option field, surely?

~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275941
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Broadcasting RSS from your site

[Rick Root]

big fan of Ray's cfrss project (rss.cfc)

http://cfrss.riaforge.org/

~|
Create Web Applications With ColdFusion MX7 & Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275942
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Testing Database Connection within Application

[Scott Stewart]

I think 

Select null
>From table

Is less taxing, and produces the same results

-- 
Scott Stewart
ColdFusion Developer
 
SSTWebworks
7241 Jillspring Ct.
Springfield, Va. 22152
(703) 220-2835
 
http://www.sstwebworks.com
-Original Message-
From: Brian Polackoff [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 20, 2007 1:02 PM
To: CF-Talk
Subject: RE: Testing Database Connection within Application

Rob,
This may sound simple, maybe too simple, but how long does your application
take to error on a cfquery if the table isn't available? 

I useed a different approach, rather then testing to see if the DSN was
valid, I simply tried to query from it.

I have just ran into this problem myself and here's how if configured the
application.  Hope it helps.

In application.cfm in the login code as I create all the session variables do
a..





Select * from testdsConn










Again, hope it helps and sorry if this answer in some form has already been
given,

Brian

-Original Message-
From: Rob O'Brien [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 19, 2007 5:17 PM
To: CF-Talk
Subject: RE: Testing Database Connection within Application

>I tested shutting down my datasource, and it retured false in about 1-2
>seconds in my local environment.

This looks like exactly what I'm looking for and I really appreciate the
effort.

I tested the same way. I stop the SQL Server service and then refresh the
script. 

Unfortunately, this still takes 16-18 seconds to return False (tested
locally). If you're reporting 1-2 seconds, I'm thinking there's another
factor involved. Any ideas?

Rob






~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275944
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: OnSessionEnd runnning TWICE

[Josh Nathanson]

I don't know that this is a situation where you need to lock.  Are you 
experiencing race conditions?  I would try it without the locks and see if 
that makes a difference.

Also in this code:

> 
>
> 

If that is in onSessionEnd, and you are counting active sessions, shouldn't 
it be *minus* 1 rather than plus 1?  Maybe I'm not clear on what you're 
going for.

-- Josh


- Original Message - 
From: "Julio Cesar Lima" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Friday, April 20, 2007 7:16 AM
Subject: OnSessionEnd runnning TWICE


> Hi guys,
>
> I'm trying to count the number of sessions, and I'm getting crazy with 
> this.
>
> I have the following code on my onApplicationStart:
>
> 
>
> 
> then I have this on my OnSessionStart:
>
> 
>
> 
>
> and finally I have this on my onSessionEnd:
>
> 
> 
>
> 
>
> The onSessionEnd is executed twice. SO if I have numSessions = 4, if one 
> sessions expires, instead I have 3, I will have 2. :(. I place a cflog, 
> and logs twice. There are not cflocks nested on anything like it.
>
> I hope you guys can help me
>
> Thank you
>
> JC
>
> 

~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275945
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: reversal?

[Will Tomlinson]

One thing I did to make it LOOK better at least is turn them into horizontal 
bars instead of vertical. 

That makes the item that scored highest on top. As it loses ranking, it moves 
down the chart. 

Thanks,
Will

~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275946
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

How do I set this variable, then...

[Rick Faircloth]

How do I set a variable in Javascript,
then check for its value in CF?





var JS;
  JS = "true";





do something



do something else





Rick



~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275947
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: How do I set this variable, then...

[Charlie Griefer]

you can't use CF to check for the existence of a JS variable.  one of
them is server side and one is client side.

the JS variable is set after the page reaches the browser, at which
point CF has done its job.

On 4/20/07, Rick Faircloth <[EMAIL PROTECTED]> wrote:
> How do I set a variable in Javascript,
> then check for its value in CF?
>
> 
>
> 
>
> var JS;
>   JS = "true";
>
> 
>
> 
>
> do something
>
> 
>
> do something else
>
> 
>
> 
>
> Rick
>
>
>
> 

~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275948
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

URL Stop and then Redirect

[John Cox]

Hi all,

I am a little stuck on a little problem, and times like these are when there
is an obvious solution from a non-interested party.  I am writing a dirty
import script to move thousands of items from one architecture to another.
What I am doing is basically getting all the information from the old
database and converting it to the new database (is not a one-to-one
relationship) structure.  I am just grabbing one item at a time and then
redirecting back to the script.

What I would like to do is stop and then redirect so I don't end up in an
infinite loop, but the cflocation tag, doesn't really seem to behave quite
the way I want.  Is there another tag that would do what I am thinking or
can someone think of an alternative?  I have about 25k items to do, so I'd
like to just start the script this afternoon and run it through the night
tonight.

Thanks for any suggestions!

jc


~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275949
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Testing Database Connection within Application

[Brian Polackoff]

Rob,
This may sound simple, maybe too simple, but how long does your application
take to error on a cfquery if the table isn't available? 

I useed a different approach, rather then testing to see if the DSN was
valid, I simply tried to query from it.

I have just ran into this problem myself and here's how if configured the
application.  Hope it helps.

In application.cfm in the login code as I create all the session variables do
a..





Select * from testdsConn










Again, hope it helps and sorry if this answer in some form has already been
given,

Brian

-Original Message-
From: Rob O'Brien [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 19, 2007 5:17 PM
To: CF-Talk
Subject: RE: Testing Database Connection within Application

>I tested shutting down my datasource, and it retured false in about 1-2
>seconds in my local environment.

This looks like exactly what I'm looking for and I really appreciate the
effort.

I tested the same way. I stop the SQL Server service and then refresh the
script. 

Unfortunately, this still takes 16-18 seconds to return False (tested
locally). If you're reporting 1-2 seconds, I'm thinking there's another
factor involved. Any ideas?

Rob




~|
ColdFusion MX7 and Flex 2 
Build sales & marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275943
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: How do I set this variable, then...

[Andy Matthews]

You'd have to use some form of behind the scenes processing. 

-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 20, 2007 12:31 PM
To: CF-Talk
Subject: How do I set this variable, then...

How do I set a variable in Javascript,
then check for its value in CF?





var JS;
  JS = "true";





do something



do something else





Rick





~|
Create Web Applications With ColdFusion MX7 & Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275950
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: URL Stop and then Redirect

[John Cox]

Duh, nevermind;)

Meta redirect works exactly as I want.  Sorry for the mail clutter.

jc

On 4/20/07, John Cox <[EMAIL PROTECTED]> wrote:
>
> Hi all,
>
> I am a little stuck on a little problem, and times like these are when
> there is an obvious solution from a non-interested party.  I am writing a
> dirty import script to move thousands of items from one architecture to
> another.  What I am doing is basically getting all the information from the
> old database and converting it to the new database (is not a one-to-one
> relationship) structure.  I am just grabbing one item at a time and then
> redirecting back to the script.
>
> What I would like to do is stop and then redirect so I don't end up in an
> infinite loop, but the cflocation tag, doesn't really seem to behave quite
> the way I want.  Is there another tag that would do what I am thinking or
> can someone think of an alternative?  I have about 25k items to do, so I'd
> like to just start the script this afternoon and run it through the night
> tonight.
>
> Thanks for any suggestions!
>
> jc
>


~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275951
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: URL Stop and then Redirect

[Ken Wexel]

Done this exact things many times using the META redir tag...nice
little fudged CF automation :)

On 4/20/07, John Cox <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I am a little stuck on a little problem, and times like these are when there
> is an obvious solution from a non-interested party.  I am writing a dirty
> import script to move thousands of items from one architecture to another.
> What I am doing is basically getting all the information from the old
> database and converting it to the new database (is not a one-to-one
> relationship) structure.  I am just grabbing one item at a time and then
> redirecting back to the script.
>
> What I would like to do is stop and then redirect so I don't end up in an
> infinite loop, but the cflocation tag, doesn't really seem to behave quite
> the way I want.  Is there another tag that would do what I am thinking or
> can someone think of an alternative?  I have about 25k items to do, so I'd
> like to just start the script this afternoon and run it through the night
> tonight.
>
> Thanks for any suggestions!
>
> jc
>
>
> 

~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275952
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Strange - Jrun crashing on uploading jpg?

[Peterson, Chris]

In my cfusion-err.log, I get this message:

Empty JPEG image (DNL not supported)

The page uses the MX_Kollection 3.0 to allow upload of several jpg
images to be stored on the server.  What is DNL?  Why in the world would
an upload actually force the Coldfusion processes to stop and re-start!

Chris

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275953
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: URL Stop and then Redirect

[Andy Matthews]

Might it not be better to perform a query of your file system using cffile?

Then you can loop over that and move things where they need to be. 

-Original Message-
From: John Cox [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 20, 2007 1:08 PM
To: CF-Talk
Subject: Re: URL Stop and then Redirect

Duh, nevermind;)

Meta redirect works exactly as I want.  Sorry for the mail clutter.

jc

On 4/20/07, John Cox <[EMAIL PROTECTED]> wrote:
>
> Hi all,
>
> I am a little stuck on a little problem, and times like these are when 
> there is an obvious solution from a non-interested party.  I am 
> writing a dirty import script to move thousands of items from one 
> architecture to another.  What I am doing is basically getting all the 
> information from the old database and converting it to the new 
> database (is not a one-to-one
> relationship) structure.  I am just grabbing one item at a time and 
> then redirecting back to the script.
>
> What I would like to do is stop and then redirect so I don't end up in 
> an infinite loop, but the cflocation tag, doesn't really seem to 
> behave quite the way I want.  Is there another tag that would do what 
> I am thinking or can someone think of an alternative?  I have about 
> 25k items to do, so I'd like to just start the script this afternoon 
> and run it through the night tonight.
>
> Thanks for any suggestions!
>
> jc
>




~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275954
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: How do I set this variable, then...

[Jake Pilgrim]

AJAX

~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275955
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Strange - Jrun crashing on uploading jpg?

[Peterson, Chris]

Ugh, as soon as I posted this I figured out what was causing the error.
There was an included file that tried to re-size these uploaded images
(CFX_GIFGD)  I have re-sizing elsewhere, so I nixed this, and works
beautiful =)

Chris 

-Original Message-
From: Peterson, Chris [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 20, 2007 2:14 PM
To: CF-Talk
Subject: Strange - Jrun crashing on uploading jpg?

In my cfusion-err.log, I get this message:

Empty JPEG image (DNL not supported)

The page uses the MX_Kollection 3.0 to allow upload of several jpg
images to be stored on the server.  What is DNL?  Why in the world would
an upload actually force the Coldfusion processes to stop and re-start!

Chris



~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275956
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: coldfusion based blogs

[Peter Boughton]

Um, you appear to have a noindex robots metatag.

Doesn't that mean robots (ie: search engines) are not going to index the page?


>I know. I'm not sure why. I made www.blogcfc.com have, what I thought,
>was a very nice keyword heavy title.
>
>p.s. Thanks for all the recommendations guys.
>
>On 4/18/07, Rick Root <[EMAIL PROTECTED]> wrote:
>>

~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275957
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: URL Stop and then Redirect

[Rick Root]

On 4/20/07, Ken Wexel <[EMAIL PROTECTED]> wrote:
> Done this exact things many times using the META redir tag...nice
> little fudged CF automation :)

I did that just a few weeks ago when I built an import process for a
client... I wanted to make sure the page actually redirected to itself
but passed different arguments so it would know which step it was
performing

Rick

~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275958
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: coldfusion based blogs

[Rick Root]

On 4/20/07, Peter Boughton <[EMAIL PROTECTED]> wrote:
> Um, you appear to have a noindex robots metatag.
>
> Doesn't that mean robots (ie: search engines) are not going to index the page?

Yes, but he appears to use "index" on the subpages.. like this:

http://www.blogcfc.com/index.cfm/2006/12/8/Test

I guess if you don't want your home page indexed

~|
ColdFusion MX7 and Flex 2 
Build sales & marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275959
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: coldfusion based blogs

[Raymond Camden]

It shouldn't be on the home page, it should be on some of the links.
This was done to direct Google into some links but not dupes. Rob
Brooks-Bilson did most of this work.


On 4/20/07, Peter Boughton <[EMAIL PROTECTED]> wrote:
> Um, you appear to have a noindex robots metatag.
>
> Doesn't that mean robots (ie: search engines) are not going to index the page?
>
>
> >I know. I'm not sure why. I made www.blogcfc.com have, what I thought,
> >was a very nice keyword heavy title.
> >
> >p.s. Thanks for all the recommendations guys.
> >
> >On 4/18/07, Rick Root <[EMAIL PROTECTED]> wrote:
> >>
>
> 

~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275960
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Decimal field

[Jochem van Dieten]

Richard Cooper wrote:
> Why would that work? URL.productID is an integer and the PK of the that table 
> productID being decimal or integer shouldn't affect the option field, surely?

It shouldn't work :) I just know it did with some old Oracle versions.

Jochem

~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275961
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: How do I set this variable, then...

[Ian Skinner]

You can't.  JS is client side and CF is server side, and never the two
shall meet.

You will have to send the JS value to the server with some kind of
request.  Either in the request of an entire page, as an URL value for
example.  Or with AJAX as a separate request.


~|
Create Web Applications With ColdFusion MX7 & Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275962
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: How do I set this variable, then...

[Rick Root]

Well can can cause coldfusion to set javascript variables based on
coldfusion variables







alert(foo["bar1"]);


but the only way coldfusion will ever know what's in a javascript
variable is via some kind of http request (like an AJAX call)

And that won't occur until after the page has been completely
processed by coldfusion.

rick

~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275963
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Struggling with MX Collection code

[Peterson, Chris]

Here is my 2nd issue I'm not sure how to fix today (short of re-writing
the procedure, and since I am billing the customer, I am hesitant to do
that)

I have a site that uses some of the MX Collection of code to perform SQL
inserts, CSV imports, etc.  This code imports a CSV file, but any ' or "
characters the customer has in their fields are getting stuck into the
database as question marks ?  Is there a way to escape those out so they
are inserted properly?  Follows is some of the code.




// Make a transaction dispatcher instance
tNGs = Request.tNG_CreateObject("tNG_dispatcher");
tNGs.init("");


// Start trigger
formValidation =
Request.tNG_CreateObject("triggers.tNG_FormValidation");
formValidation.init();
formValidation.addField("csvfile1", true, "", "", "", "", "");
tNGs.prepareValidation(formValidation);
// End trigger


// Make a CVS Import transaction instance
csv_items = Request.tNG_CreateObject("tNG_CSVImport");
csv_items.init("1800lastbid");
tNGs.addTransaction(csv_items);
// Register triggers
csv_items.registerTrigger("STARTER", "Trigger_Default_Starter", 1,
"POST", "KT_Insert1");
csv_items.registerTrigger("BEFORE", "Trigger_Default_FormValidation",
10, formValidation);
csv_items.registerTrigger("END", "Trigger_Default_Redirect", 99,
"auctionimportdone.cfm");
// Add columns
csv_items.setTable("items");
csv_items.addColumn("itemnum", "NUMERIC_TYPE", "CSV", "Itemnum");
csv_items.addColumn("status", "NUMERIC_TYPE", "CSV", "Status");
csv_items.addColumn("title", "STRING_TYPE", "CSV", "Title");
csv_items.addColumn("description", "STRING_TYPE", "CSV", "Description");
.. Lots more in here...
csv_items.setPrimaryKey("ID", "NUMERIC_TYPE");
csv_items.setSource("FILES", "csvfile1");
csv_items.setHeader(true);
csv_items.setDelimiter(",");
csv_items.setEnclosure();
csv_items.setHandleDuplicates(""); 
csv_items.setCSVUniqueKey("");


// Execute all the registered transactions
tNGs.executeTransactions();



Thanks in advance,

Chris Peterson

~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275964
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: How do I set this variable, then...

[Rick Faircloth]

Thanks for the responses, everyone!

Rick

-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 20, 2007 3:54 PM
To: CF-Talk
Subject: Re: How do I set this variable, then...

Well can can cause coldfusion to set javascript variables based on
coldfusion variables







alert(foo["bar1"]);


but the only way coldfusion will ever know what's in a javascript
variable is via some kind of http request (like an AJAX call)

And that won't occur until after the page has been completely
processed by coldfusion.

rick



~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275965
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: How do I set this variable, then...

[Ian Skinner]

Well can can cause coldfusion to set javascript variables based on
coldfusion variables


I like to describe this as building Dynamic JavaScript with CFML, just
like CFML makes Dynamic HTML.  It helps keep it clear in my mind that CF
is building the JavaScript and once it is completely done it sends the
whole kit and caboodle to the client.



~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275966
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Client-side validation or Server-side Validation?

[Les Mizzell]

> Was this info helpful to you in solving your problems
> with clients who don't have JS turned on?


While I still have to study it a bit and figure out how to work it into 
the quasi Fusebox framework I'm using ... yes, very helpful!  I'm 
positive this will solve the problems I've been facing!

Thanks very much!

~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275967
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Client-side validation or Server-side Validation?

[Rick Faircloth]

No problem... glad to help.

Let me know if you any more help!  :o)

Rick

-Original Message-
From: Les Mizzell [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 20, 2007 5:47 PM
To: CF-Talk
Subject: Re: Client-side validation or Server-side Validation?

> Was this info helpful to you in solving your problems
> with clients who don't have JS turned on?


While I still have to study it a bit and figure out how to work it into 
the quasi Fusebox framework I'm using ... yes, very helpful!  I'm 
positive this will solve the problems I've been facing!

Thanks very much!



~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275968
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: form data not being inserted into mssql database

[John P]

Thanks all. 

Carl, does cfparam as you described discretely tell CF and SQL that the insert 
is a numerical data type? In what instances is that advised? Why is it 
necessary?

I've isolated the issue to a server memory problem, I believe, and solved it (I 
hope)
by restarting the server. 

Thank you all for your help.


>John,
>
>You might want to try using CFQUERYPARAM in your insert query.  Something like:
>
>INSERT INTO STUDENT_ACADEMICS (CUM_GPA)
>VALUES ()
>
>Set the CFSQLTYPE to the appropriate type to match the data type of the SQL 
>field.
>
>HTH,
>Carl
>
>
>> Form code:
>> 
> 
>> > required="Yes" size="8">...
>> 
>> Insert:
>> 
>   
>> INSERT INTO STUDENT_ACADEMICS (CUM_GPA)
>   
>>>

~|
ColdFusion MX7 and Flex 2 
Build sales & marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275969
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: form data not being inserted into mssql database

[Dave Watts]

> Carl, does cfparam as you described discretely tell CF and 
> SQL that the insert is a numerical data type? In what 
> instances is that advised? Why is it necessary?

http://www.adobe.com/devnet/coldfusion/articles/cfqueryparam.html

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

This email has been processed by SmoothZap - www.smoothwall.net


~|
Create Web Applications With ColdFusion MX7 & Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275970
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4