Re: CF 8 Shared hosting w/o Java 6 Class Loader bug

[Mark Mandel]

Took this from a Transfer post:

--
It's scheduled to come out with 6u10, according to this:

http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=6566201

It's out in beta, but not expected for full release until 3rd quarter 08.

https://jdk6.dev.java.net/6u10ea.html

How it was considered a priority 3 (medium) is beyond me.
--

So now you know as much as I do.

Mark

On Wed, Apr 23, 2008 at 3:00 PM, Matthew Levine
<[EMAIL PROTECTED]> wrote:
> >Just out of curiosity, but what sort of time is your app taking to load up?
>
>  The main issue is at start up, it can take up to two minutes. However, once 
> it's up and running you can reload it rather quickly, around 5 seconds, which 
> is about what it takes on CF 7 and Railo 2.
>
>
>
>  >Are you finding you are getting random slowdowns at all, during the
>  >app lifecycle?
>
>  Yes, once it's up it does have random slow downs that are not associated 
> with the app instantiation.  I think that they may be associated to inactive 
> periods on the site, but I did some testing and the app is definitely not 
> rebuilding itself. I'm pretty darn sure that it's all due to the dreaded java 
> 6 class loading bottle neck.
>
>  I'm also pretty sure that no host will will do anything about it because 
> downgrading the jvm will also downgrade some of the performance gains that 
> non-framework based apps are currently experiencing on the same shared 
> servers.
>
>  It's just disappointing.
>
>  Matt
>
>
>  

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

JavaScript & cftextarea with rich text

[Steve Sequenzia]

I am trying to check whether or not a rich text textarea has a value in 
JavaScript. On a normal textarea box I can just use the elementname.value == '' 
but that is not working when I have rich text turned on.

Anyone have any ideas how to check it when rich text is on?

Thanks! 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Problem with cfdocument and CF8.0.1 (64bit on XServe)

[Aaron Bodell]

My server stopped generating pdf's when I "clean" installed CF8.0.1 Below is 
the stack trace. Hoping someone can help.

Thanks in advance!

Aaron

Stack Trace
at 
cfbuildPDF2ecfm1760911841.runPage(/Library/WebServer/Documents/standardadmin/buildPDF.cfm:63)
 at 
cfbuildPDF2ecfm1760911841.runPage(/Library/WebServer/Documents/standardadmin/buildPDF.cfm:63)
 

java.lang.NullPointerException
at javax.swing.MultiUIDefaults.getUIError(MultiUIDefaults.java:117)
at javax.swing.UIDefaults.getUI(UIDefaults.java:721)
at javax.swing.UIManager.getUI(UIManager.java:868)
at javax.swing.JPanel.updateUI(JPanel.java:104)
at javax.swing.JPanel.(JPanel.java:64)
at javax.swing.JPanel.(JPanel.java:87)
at javax.swing.JPanel.(JPanel.java:95)
at coldfusion.document.DocumentFrame.(DocumentFrame.java:42)
at 
coldfusion.document.DocumentProcessor$DocumentViewportCallback.createTopLevelContainer(DocumentProcessor.java:400)
at ice.storm.CallbackAdapter$BoxedCallback.run(CallbackAdapter.java:231)
at 
ice.util.security.jdk12.SecurityKit_jdk12.doPrivilegedImpl(SecurityKit_jdk12.java:87)
at ice.util.security.SecurityKit.doPrivileged(SecurityKit.java:71)
at ice.storm.StormBase.configureViewport(StormBase.java:1473)
at ice.storm.StormBase.newTopLevelViewport(StormBase.java:1073)
at ice.storm.StormBase.prepare_viewport(StormBase.java:1117)
at ice.storm.StormBase.renderContent(StormBase.java:907)
at 
coldfusion.document.DocumentProcessor.processContent(DocumentProcessor.java:251)
at 
coldfusion.document.DocumentProcessor.processContent(DocumentProcessor.java:163)
at 
coldfusion.tagext.lang.DocumentSectionTag.processContent(DocumentSectionTag.java:510)
at 
coldfusion.tagext.lang.DocumentSectionTag._processContent(DocumentSectionTag.java:455)
at 
coldfusion.tagext.lang.DocumentSectionTag.doAfterBody(DocumentSectionTag.java:428)
at 
cfbuildPDF2ecfm1760911841.runPage(/Library/WebServer/Documents/standardadmin/buildPDF.cfm:63)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at 
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279)
at 
coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
at 
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at 
coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:126)
at coldfusion.CfmServlet.service(CfmServlet.java:175)
at 
coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
at 
coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at 
coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
at jrun.servlet.FilterChain.service(FilterChain.java:101)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at 
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
at 
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
at 
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
at 
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
at 
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
at 
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

RE: OT - what is this? ""

[Hugo Ahlenius]

| All very weird. These are scattered through text here and 
| there and seem 
| almost pointless. My example below, for example - in the 
| sentence it's 
| St. Paul's church - not St. Paul the city.

It is not that you see some left over of this "Smart Tags" that
Microsoft introduced in Office a couple of years ago. I have it turned
off on my computers, so I don't know how it works...

With those e.g. word tries to locate place names and people in the text
and give them some special hyperlink.



/Hugo

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: CF 8 Shared hosting w/o Java 6 Class Loader bug

[Matthew Levine]

>Just out of curiosity, but what sort of time is your app taking to load up?

The main issue is at start up, it can take up to two minutes. However, once 
it's up and running you can reload it rather quickly, around 5 seconds, which 
is about what it takes on CF 7 and Railo 2.


>Are you finding you are getting random slowdowns at all, during the
>app lifecycle?

Yes, once it's up it does have random slow downs that are not associated with 
the app instantiation.  I think that they may be associated to inactive periods 
on the site, but I did some testing and the app is definitely not rebuilding 
itself. I'm pretty darn sure that it's all due to the dreaded java 6 class 
loading bottle neck.

I'm also pretty sure that no host will will do anything about it because 
downgrading the jvm will also downgrade some of the performance gains that 
non-framework based apps are currently experiencing on the same shared servers.

It's just disappointing.

Matt


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: cfquery options and connection pooling

[Jon Clausen]

Maureen,

I had something similar happen on a machine running SUSE 9/CF7  
connecting to a PostgreSQL database with a third-party driver.

My understanding, as I've read it, is that connections are only pooled  
across the length of the request so if your code throws a database  
error somewhere in the request, there's a possibilty that the  
connection will "stick" open.   In our case it was a non-superuser  
limit on concurrent connections we were hitting with PostgreSQL so the  
problem was snowballing since the database errors were causing stuck  
connections and the number of connections was increasing - causing  
more database errors.

We upped the max-allowed connections in our pg config files and, as  
Dave suggested, we added a max allowed connections to the datasource  
and that seems to have solved the problem by forcing CF to re-use the  
connection.

We're looking at upgrading that server to CF8 in the not-too-distant  
future and I'm looking forward to seeing if that solves the problem  
between the CF and JVM upgrades involved.

Also, if the above and Dave's suggestions don't solve the problem, you  
might try see if there is a way to use the Oracle   
oracle.jdbc.pool.OracleConnectionPoolDataSource class ()directly 
(http://download.oracle.com/docs/cd/B10500_01/java.920/a96654/connpoca.htm 
) to  clean up the pool periodically.

HTH,
Jon

On Apr 21, 2008, at 1:43 PM, Maureen Barger wrote:

> I am trying to figure out the technical ramifications of defining the
> username and password for a specific DSN in a separate text file and  
> how it
> may relate to connection pooling v. supplying the user/pass directly  
> in the
> DSN. Once the file is loaded, user and password are passed to  
> cfqueries
> using application variables.
>
> If the user/pass is defined externally, can connections in the same  
> pool be
> re-used?
> If the user/pass is added to the DSN, the user/pass removed from the
> external text file and the cfquery strings still contain the  
> Application
> variables for them, what happens to the connection pool?
>
> The reason I am trying to wrap my head around this is that our  
> datasource
> (Oracle) has an increasing number of connections that are never  
> released.
> Over time, the application becomes sluggish. It also uses stored  
> procs.
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: OT - what is this? ""

[Les Mizzell]

All very weird. These are scattered through text here and there and seem 
almost pointless. My example below, for example - in the sentence it's 
St. Paul's church - not St. Paul the city.

This site started as a simple Coldfusion site done by myself. At some 
point, somebody else took it over and converted it to Ruby on Rails, 
though I don't know why as it was a fairly simple site with no database.
I think maybe just to see if they could do it. It went from a fairly 
simple structure to a confusing mish mash of code that took me forever 
to figure out (with *no* visable changes on the site itself) - and 
there's just weird "stuff" like the below here and there that I'm 
cleaning up now...


> These are actually Microsoft Smart Tags for use in Sharepoint Web Parts:
>>  
>> 
>>St. Paul
>> 
>>  


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: CF 8 Shared hosting w/o Java 6 Class Loader bug

[Mark Mandel]

Mathew,

Just out of curiosity, but what sort of time is your app taking to load up?

Are you finding you are getting random slowdowns at all, during the
app lifecycle?

Mark

On Wed, Apr 23, 2008 at 1:24 PM, Matthew Levine
<[EMAIL PROTECTED]> wrote:
> I will most likely just band aid it by extending the timeout with cfsetting, 
> because once it's up everything work fine.
>
>
>  Matt Levine
>  Blue River Interactive Group 1
>  2150 Tributary Point Dr., Suite 140
>  Gold River, CA  95670
>
>
>  

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: Need some advice on speeding up query...

[James Holmes]

Did you try the UNION ALL as suggested by Rizal? This might make it a
little quicker as the DB won't have to scan for duplicates.

On Wed, Apr 23, 2008 at 11:03 AM, Rick Faircloth
<[EMAIL PROTECTED]> wrote:
> If I had set up the original db that's providing the
>  data, it would have definitely been set up differently.

-- 
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: CF 8 Shared hosting w/o Java 6 Class Loader bug

[Matthew Levine]

I will most likely just band aid it by extending the timeout with cfsetting, 
because once it's up everything work fine.

Matt Levine 
Blue River Interactive Group 1
2150 Tributary Point Dr., Suite 140 
Gold River, CA  95670


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

RE: Need some advice on speeding up query...

[Rick Faircloth]

If I had set up the original db that's providing the
data, it would have definitely been set up differently.

However, I'm pulling data from a data provider and inserting
that in MySQL.  I'm not sure how the tables could be set up much
differently since, while they do have data in common, all the tables
have quite a few differences because of the different property types.

Unfortunately, the data vendor didn't use the mls number as a primary key
for their tables (there's no keys specified, actually), so I just added
a "property_id" field as an auto-incrementing primary key to each table
when I transferred the data.

Please advise if I'm missing something helpful!

Anyway, as far as indexing the mls_number fields in the property tables
(non-photo) tables... I did that and it did shave another 1-2 seconds
off the time it takes for the results to appear, down from 3-4 seconds, so
that was a good move!

I've got to get this site live asap, so redesigning the db at this point
isn't possible.  The performance of the query for this part is good, so with
the indexing, I don't think I'll have any performance problems with the
search page, either.

But again, if you've got any more ideas, let me know!

Thanks for the help!

Rick




> -Original Message-
> From: James Holmes [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 22, 2008 9:27 PM
> To: CF-Talk
> Subject: Re: Need some advice on speeding up query...
> 
> Well, apart from a DB redesign so that you can do 1 query instead of a
> union of 5, lets look at the first query as an example:
> 
> select sa.street_number as prop_street_number, sa.street_name as
> prop_street_name,
>   sa.city as prop_city, sa.public_remarks_01 as 
> prop_public_remarks_01,
>   sa.public_remarks_02 as prop_public_remarks_02,
> sa.list_price as prop_list_price,
>   (select sap.photo_filename from smlc_acr_photos sap where
> sap.photo_mls_number =
> sa.mls_number limit 1) as prop_photo_filename
> 
> Since you're joining smlc_acr_photos.photo_mls_number to
> smlc_acr.mls_number, put an index on each column. Hopefully
> smlc_acr.mls_number is a primary key and is already indexed. Repeat
> for the other tables.



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: Need some advice on speeding up query...

[James Holmes]

Well, apart from a DB redesign so that you can do 1 query instead of a
union of 5, lets look at the first query as an example:

select sa.street_number as prop_street_number, sa.street_name as
prop_street_name,
  sa.city as prop_city, sa.public_remarks_01 as prop_public_remarks_01,
  sa.public_remarks_02 as prop_public_remarks_02,
sa.list_price as prop_list_price,
  (select sap.photo_filename from smlc_acr_photos sap where
sap.photo_mls_number =
sa.mls_number limit 1) as prop_photo_filename

Since you're joining smlc_acr_photos.photo_mls_number to
smlc_acr.mls_number, put an index on each column. Hopefully
smlc_acr.mls_number is a primary key and is already indexed. Repeat
for the other tables.

On Wed, Apr 23, 2008 at 7:21 AM, Rick Faircloth
<[EMAIL PROTECTED]> wrote:
> Hi, all...
>
>  Up till now, my db's have been relatively small
>  and fairly quick when being queried.  I've never had to bother
>  with indexes or other methods of optimizing queries.
>
>  However, I've now got a db of about 6400 real estate properties.
>
>  I've put together a "Browse Properties" page, which returns
>  20 records at a time and displays pagination.
>
>  The query is pretty slow.
>
>  Would indexes or perhaps another approach to this query
>  make it quicker?
>
>  Here's the code that pulls together records from the tables
>  containing the various property types...
>
>  
>
> select sa.street_number as prop_street_number, sa.street_name as 
> prop_street_name,
>sa.city as prop_city, sa.public_remarks_01 as 
> prop_public_remarks_01,
>sa.public_remarks_02 as prop_public_remarks_02, sa.list_price as 
> prop_list_price,
>(select sap.photo_filename from smlc_acr_photos sap where 
> sap.photo_mls_number =
>  sa.mls_number limit 1) as prop_photo_filename
>   from smlc_acr sa
>  union
> select sc.street_number as prop_street_number, sc.street_name as 
> prop_street_name,
>sc.city as prop_city, sc.public_remarks_01 as 
> prop_public_remarks_01,
>sc.public_remarks_02 as prop_public_remarks_02, sc.list_price as 
> prop_list_price,
>(select scp.photo_filename from smlc_com_photos scp where 
> scp.photo_mls_number =
>  sc.mls_number limit 1) as prop_photo_filename
>   from smlc_com sc
>  union
> select sl.street_number as prop_street_number, sl.street_name as 
> prop_street_name,
>sl.city as prop_city, sl.public_remarks_01 as 
> prop_public_remarks_01,
>sl.public_remarks_02 as prop_public_remarks_02, sl.list_price as 
> prop_list_price,
>(select slp.photo_filename from smlc_lot_photos slp where 
> slp.photo_mls_number =
>  sl.mls_number limit 1) as prop_photo_filename
>   from smlc_lots sl
>  union
> select sr.street_number as prop_street_number, sr.street_name as 
> prop_street_name,
>sr.city as prop_city, sr.public_remarks_01 as 
> prop_public_remarks_01,
>sr.public_remarks_02 as prop_public_remarks_02, sr.list_price as 
> prop_list_price,
> (select srp.photo_filename from smlc_ren_photos srp where 
> srp.photo_mls_number =
>  sr.mls_number limit 1) as prop_photo_filename
>   from smlc_ren sr
>  union
> select sres.street_number as prop_street_number, sres.street_name as 
> prop_street_name,
>sres.city as prop_city, sres.public_remarks_01 as 
> prop_public_remarks_01,
>sres.public_remarks_02 as prop_public_remarks_02, sres.list_price 
> as prop_list_price,
>(select sresp.photo_filename from smlc_res_photos sresp where 
> sresp.photo_mls_number =
>  sres.mls_number limit 1) as prop_photo_filename
>   from smlc_res sres
>
>  
>
>
>  

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

RE: Need some advice on speeding up query...

[Rick Faircloth]

Wow, Rizal...

I had my doubts about how much putting indexes
on just the photo_mls_number fields in the photo tables
would help, but the speed is greatly improved!

I figured with the complexity of the query that just those
indexes wouldn't make much difference, but they did!

Thanks!

Rick

> -Original Message-
> From: Rizal Firmansyah [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 22, 2008 9:18 PM
> To: CF-Talk
> Subject: Re: Need some advice on speeding up query...
> 
> Hi Rick,
> index will speed up the query if used correctly.
> 
> I think you can put index on these tables
> smlc_acr_photos -> photo_mls_number
> smlc_com_photos  -> photo_mls_number
> smlc_lot_photos  -> photo_mls_number
> smlc_ren_photos  -> photo_mls_number
> smlc_res_photos  -> photo_mls_number
> 
> Also if the content of smlc_acr, smlc_com,
> smlc_lots, smlc_ren, smlc_res are different
> try using "union all" instead of "union"
> 
> Rizal
> 
> At 06:21 AM 4/23/2008, you wrote:
> >Hi, all...
> >
> >Up till now, my db's have been relatively small
> >and fairly quick when being queried. I've never had to bother
> >with indexes or other methods of optimizing queries.
> >
> >However, I've now got a db of about 6400 real estate properties.
> >
> >I've put together a "Browse Properties" page, which returns
> >20 records at a time and displays pagination.
> >
> >The query is pretty slow.
> >
> >Would indexes or perhaps another approach to this query
> >make it quicker?
> >
> >Here's the code that pulls together records from the tables
> >containing the various property types...
> >
> >
> >
> >select sa.street_number as
> > prop_street_number, sa.street_name as prop_street_name,
> >   sa.city as prop_city,
> > sa.public_remarks_01 as prop_public_remarks_01,
> >   sa.public_remarks_02 as
> > prop_public_remarks_02, sa.list_price as prop_list_price,
> >   (select sap.photo_filename from
> > smlc_acr_photos sap where sap.photo_mls_number =
> >sa.mls_number limit 1) as prop_photo_filename
> >  from smlc_acr sa
> > union
> >select sc.street_number as
> > prop_street_number, sc.street_name as prop_street_name,
> >   sc.city as prop_city,
> > sc.public_remarks_01 as prop_public_remarks_01,
> >   sc.public_remarks_02 as
> > prop_public_remarks_02, sc.list_price as prop_list_price,
> >   (select scp.photo_filename from
> > smlc_com_photos scp where scp.photo_mls_number =
> >sc.mls_number limit 1) as prop_photo_filename
> >  from smlc_com sc
> > union
> >select sl.street_number as
> > prop_street_number, sl.street_name as prop_street_name,
> >   sl.city as prop_city,
> > sl.public_remarks_01 as prop_public_remarks_01,
> >   sl.public_remarks_02 as
> > prop_public_remarks_02, sl.list_price as prop_list_price,
> >   (select slp.photo_filename from
> > smlc_lot_photos slp where slp.photo_mls_number =
> >sl.mls_number limit 1) as prop_photo_filename
> >  from smlc_lots sl
> > union
> >select sr.street_number as
> > prop_street_number, sr.street_name as prop_street_name,
> >   sr.city as prop_city,
> > sr.public_remarks_01 as prop_public_remarks_01,
> >   sr.public_remarks_02 as
> > prop_public_remarks_02, sr.list_price as prop_list_price,
> >(select srp.photo_filename from
> > smlc_ren_photos srp where srp.photo_mls_number =
> >sr.mls_number limit 1) as prop_photo_filename
> >  from smlc_ren sr
> > union
> >select sres.street_number as
> > prop_street_number, sres.street_name as prop_street_name,
> >   sres.city as prop_city,
> > sres.public_remarks_01 as prop_public_remarks_01,
> >   sres.public_remarks_02 as
> > prop_public_remarks_02, sres.list_price as prop_list_price,
> >   (select sresp.photo_filename from
> > smlc_res_photos sresp where sresp.photo_mls_number =
> >sres.mls_number limit 1) as prop_photo_filename
> >  from smlc_res sres
> >
> >
> >
> >
> >
> 
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: Need some advice on speeding up query...

[Rizal Firmansyah]

Hi Rick,
index will speed up the query if used correctly.

I think you can put index on these tables
smlc_acr_photos -> photo_mls_number
smlc_com_photos  -> photo_mls_number
smlc_lot_photos  -> photo_mls_number
smlc_ren_photos  -> photo_mls_number
smlc_res_photos  -> photo_mls_number

Also if the content of smlc_acr, smlc_com, 
smlc_lots, smlc_ren, smlc_res are different
try using "union all" instead of "union"

Rizal

At 06:21 AM 4/23/2008, you wrote:
>Hi, all...
>
>Up till now, my db's have been relatively small
>and fairly quick when being queried. I've never had to bother
>with indexes or other methods of optimizing queries.
>
>However, I've now got a db of about 6400 real estate properties.
>
>I've put together a "Browse Properties" page, which returns
>20 records at a time and displays pagination.
>
>The query is pretty slow.
>
>Would indexes or perhaps another approach to this query
>make it quicker?
>
>Here's the code that pulls together records from the tables
>containing the various property types...
>
>
>
>select sa.street_number as 
> prop_street_number, sa.street_name as prop_street_name,
>   sa.city as prop_city, 
> sa.public_remarks_01 as prop_public_remarks_01,
>   sa.public_remarks_02 as 
> prop_public_remarks_02, sa.list_price as prop_list_price,
>   (select sap.photo_filename from 
> smlc_acr_photos sap where sap.photo_mls_number =
>sa.mls_number limit 1) as prop_photo_filename
>  from smlc_acr sa
> union
>select sc.street_number as 
> prop_street_number, sc.street_name as prop_street_name,
>   sc.city as prop_city, 
> sc.public_remarks_01 as prop_public_remarks_01,
>   sc.public_remarks_02 as 
> prop_public_remarks_02, sc.list_price as prop_list_price,
>   (select scp.photo_filename from 
> smlc_com_photos scp where scp.photo_mls_number =
>sc.mls_number limit 1) as prop_photo_filename
>  from smlc_com sc
> union
>select sl.street_number as 
> prop_street_number, sl.street_name as prop_street_name,
>   sl.city as prop_city, 
> sl.public_remarks_01 as prop_public_remarks_01,
>   sl.public_remarks_02 as 
> prop_public_remarks_02, sl.list_price as prop_list_price,
>   (select slp.photo_filename from 
> smlc_lot_photos slp where slp.photo_mls_number =
>sl.mls_number limit 1) as prop_photo_filename
>  from smlc_lots sl
> union
>select sr.street_number as 
> prop_street_number, sr.street_name as prop_street_name,
>   sr.city as prop_city, 
> sr.public_remarks_01 as prop_public_remarks_01,
>   sr.public_remarks_02 as 
> prop_public_remarks_02, sr.list_price as prop_list_price,
>(select srp.photo_filename from 
> smlc_ren_photos srp where srp.photo_mls_number =
>sr.mls_number limit 1) as prop_photo_filename
>  from smlc_ren sr
> union
>select sres.street_number as 
> prop_street_number, sres.street_name as prop_street_name,
>   sres.city as prop_city, 
> sres.public_remarks_01 as prop_public_remarks_01,
>   sres.public_remarks_02 as 
> prop_public_remarks_02, sres.list_price as prop_list_price,
>   (select sresp.photo_filename from 
> smlc_res_photos sresp where sresp.photo_mls_number =
>sres.mls_number limit 1) as prop_photo_filename
>  from smlc_res sres
>
>
>
>
>

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

CF 8 Shared hosting w/o Java 6 Class Loader bug

[Matthew Levine]

Does anyone know of a CF 8 host that offers shared hosting not on Java 6 or 
more specifically on a version that does not contain the bug described in this 
blog post

http://www.compoundtheory.com/?action=displayPost&ID=270

We recently released our cms as open source (gosava.com) and are trying to see 
if we can have a recommended shared hosting provider.  However, it’s a 
frameworks based application that suffers greatly from the above mentioned bug. 
 My guess is that we’re out of luck, but I thought I might check in on this 
list to see if anyone knows anything.

Any suggestions would be appreciated.

Matt Levine
Blue River Interactive Group
12150 Tributary Point Dr., Suite 140
Gold River, CA  95670

 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304031
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 - what is this? ""

[James Holmes]

These are actually Microsoft Smart Tags for use in Sharepoint Web Parts:

http://msdn2.microsoft.com/en-us/library/aa188446(office.10).aspx

On Wed, Apr 23, 2008 at 7:04 AM, Les Mizzell <[EMAIL PROTECTED]> wrote:
> Didn't know where else to ask - and I'll probably get blasted for not
>  knowing
>
>  I just inherited a site with stuff like:
>
>  
> 
>St. Paul
> 
>  
>
>  Some sort of accessibility code I've not seen before, right? Anybody got
>  a link to an article?
>
>  TIA ...
>
>  

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Need some advice on speeding up query...

[Rick Faircloth]

Hi, all...

Up till now, my db's have been relatively small
and fairly quick when being queried.  I've never had to bother
with indexes or other methods of optimizing queries.

However, I've now got a db of about 6400 real estate properties.

I've put together a "Browse Properties" page, which returns
20 records at a time and displays pagination.

The query is pretty slow.

Would indexes or perhaps another approach to this query
make it quicker?

Here's the code that pulls together records from the tables
containing the various property types...



select sa.street_number as prop_street_number, sa.street_name as 
prop_street_name,
   sa.city as prop_city, sa.public_remarks_01 as prop_public_remarks_01,
   sa.public_remarks_02 as prop_public_remarks_02, sa.list_price as 
prop_list_price,
   (select sap.photo_filename from smlc_acr_photos sap where 
sap.photo_mls_number =
sa.mls_number limit 1) as prop_photo_filename
  from smlc_acr sa
 union   
select sc.street_number as prop_street_number, sc.street_name as 
prop_street_name,
   sc.city as prop_city, sc.public_remarks_01 as prop_public_remarks_01,
   sc.public_remarks_02 as prop_public_remarks_02, sc.list_price as 
prop_list_price,
   (select scp.photo_filename from smlc_com_photos scp where 
scp.photo_mls_number =
sc.mls_number limit 1) as prop_photo_filename
  from smlc_com sc
 union
select sl.street_number as prop_street_number, sl.street_name as 
prop_street_name,
   sl.city as prop_city, sl.public_remarks_01 as prop_public_remarks_01,
   sl.public_remarks_02 as prop_public_remarks_02, sl.list_price as 
prop_list_price,
   (select slp.photo_filename from smlc_lot_photos slp where 
slp.photo_mls_number =
sl.mls_number limit 1) as prop_photo_filename
  from smlc_lots sl
 union 
select sr.street_number as prop_street_number, sr.street_name as 
prop_street_name,
   sr.city as prop_city, sr.public_remarks_01 as prop_public_remarks_01,
   sr.public_remarks_02 as prop_public_remarks_02, sr.list_price as 
prop_list_price,
(select srp.photo_filename from smlc_ren_photos srp where 
srp.photo_mls_number =
sr.mls_number limit 1) as prop_photo_filename
  from smlc_ren sr
 union
select sres.street_number as prop_street_number, sres.street_name as 
prop_street_name,
   sres.city as prop_city, sres.public_remarks_01 as 
prop_public_remarks_01,
   sres.public_remarks_02 as prop_public_remarks_02, sres.list_price as 
prop_list_price,
   (select sresp.photo_filename from smlc_res_photos sresp where 
sresp.photo_mls_number =
sres.mls_number limit 1) as prop_photo_filename
  from smlc_res sres
  



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

re: OT - what is this? ""

[Jake Churchill]

This is making use of a namespace.  It's used in XML and MXML quite a bit.  I 
see it less often in CF but here's what you have...

Somewhere you're gonna have a cfimport tag that looks like this:



That enables you to call any file in the directory specified in the taglib="" 
as a module like this:





So, in the directory specified in the taglib there is going to probably be a 
cfm file called place.cfm which does the work.  

--

Jake Churchill 
 Team Leader
11204 Davenport, Ste. 100
Omaha, NE  68154 
http://www.cfwebtools.com   
 402-408-3733 x103 



From: Les Mizzell <[EMAIL PROTECTED]>
Sent: Tuesday, April 22, 2008 6:05 PM
To: CF-Talk 
Subject: OT - what is this? "" 

Didn't know where else to ask - and I'll probably get blasted for not 
knowing

I just inherited a site with stuff like:

St. Paul

Some sort of accessibility code I've not seen before, right? Anybody got 
a link to an article?

TIA ...



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304028
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 - what is this? ""

[Phillip Vector]

Google ""

Looks like a kind of Blogger code. www.blogger.com can probably help ya.

On Tue, Apr 22, 2008 at 4:04 PM, Les Mizzell <[EMAIL PROTECTED]> wrote:
> Didn't know where else to ask - and I'll probably get blasted for not
> knowing
>
> I just inherited a site with stuff like:
>
> 
>
>   St. Paul
>
> 
>
> Some sort of accessibility code I've not seen before, right? Anybody got
> a link to an article?
>
> TIA ...
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

OT - what is this? ""

[Les Mizzell]

Didn't know where else to ask - and I'll probably get blasted for not 
knowing

I just inherited a site with stuff like:



   St. Paul



Some sort of accessibility code I've not seen before, right? Anybody got 
a link to an article?

TIA ...

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: Cffile and cfdirectory in CF 8

[Tim Lancaster]

I have tried that and I can access the drive, create, modify and delete as per 
the given rights.  This has been an issue with any drive that is mapped to 
share on another server, none of them work anymore with CF 8.

>> Yes I have setup a user account with all appropriate right to 
>> run CF and access the shares.  And interestingly, the UNC 
>> path does work.  Do you know of a reason why mapped drives 
>> wouldn't work when they did in CF 7 and earlier?
>
>Perhaps the mapping isn't available for that user. Try logging in
>interactively as that user, and see if you can access the drive mapping.
>
>Dave Watts, CTO, Fig Leaf Software
>http://www.figleaf.com/
>
>Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
>http://training.figleaf.com/
>
>WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
>http://www.webmaniacsconference.com/ 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Writing content to a cfwindow from JavaScript

[Steve Sequenzia]

I am creating a cfwindow from JS with this:

ColdFusion.Window.create('testwindow', 'This is a test');

I also need to be able to write content to the window from JavaScript. That 
will include JavaScript variables. I have tried doing it with this:

elementName_body.innerHTML='This is the body';

I cannot get it to work at all. It pops the window up but noting in the content.

Anyone have any ideas?

Thanks in advance for any help. 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: Security Problem w IIS when using CFINVOKE or CFHTTP

[Alan Rother]

Awesome, that is what I wanted to hear.

I also checked with a .net friend of mine who says he wouldn't be able
to access the web service either behind the WA

Now I can force them to "switch" to the other security.

Thanks Dave



-- 
Alan Rother
Adobe Certified Advanced ColdFusion MX 7 Developer
Manager, Phoenix Cold Fusion User Group, AZCFUG.org

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

RE: Cffile and cfdirectory in CF 8

[Dave Watts]

> Yes I have setup a user account with all appropriate right to 
> run CF and access the shares.  And interestingly, the UNC 
> path does work.  Do you know of a reason why mapped drives 
> wouldn't work when they did in CF 7 and earlier?

Perhaps the mapping isn't available for that user. Try logging in
interactively as that user, and see if you can access the drive mapping.

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

Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
http://training.figleaf.com/

WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
http://www.webmaniacsconference.com/

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: Binding to a CFGrid from tabs

[Michael Brennan-White]

Gary,

Thanks for the reply.  

I wasn't before because I had already used them in the main index page.  I 
tried running the grid/tabs page by itself after adding cfajaximport tags for 
cfform and cfgrid.  

The page ran in Firefox (2.0.0.14) without a problem but failed in IE7.  

If I get rid of the source attribute in the cflayoutarea and place the tab code 
in the  tags the code works in both Firefox and 
IE.  

>Michael,
>
>Are you using cfajaimport in your tab cfm pages?  If you have ajax code in
>your tab source pages you have to use the cfajaximport on those pages too.
>since you are binding stuff in those souce pages to your form you probably
>need to do an 
>
>Give that a try...
>
>-- 
>Gary Gilbert
>http://www.garyrgilbert.com/blog 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

RE: Security Problem w IIS when using CFINVOKE or CFHTTP

[Dave Watts]

> I dont care which way I have to go (CFHTTP or CFINVOKE) or 
> I'm will to explore other CF methods. I have to be able to 
> access these webservices and I don't know for sure if I am 
> going to be able to talk them into lowering the security. 
> Despite the fact we are going over SSL and I'm willing to be 
> locked down by IP address.

If you're using SSL, Basic Authentication is just as secure as Windows
Authentication. So, they won't be lowering security.

To the best of my knowledge, most web service clients don't support Windows
Authentication. It's not a standard.

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

Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
http://training.figleaf.com/

WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
http://www.webmaniacsconference.com/

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Adult Websites

[Phillip Vector]

Sorry.. Didn't mean to hijack the thread. Google Mail apparently
doesn't allow changing of subjects when replying without clicking a
link. Sorry again. :)

On Tue, Apr 22, 2008 at 3:25 PM, Phillip Vector
<[EMAIL PROTECTED]> wrote:
> Does anyone know a hosting company that allows hosting of adult sites
> that also run ColdFusion? Low cost if possible, but I'll take whatever
> you got. :)
>

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: URLs being appended to query string

[Phillip Vector]

Does anyone know a hosting company that allows hosting of adult sites
that also run ColdFusion? Low cost if possible, but I'll take whatever
you got. :)

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: Cffile and cfdirectory in CF 8

[Tim Lancaster]

Dave,
Thanks for the reply,
Yes I have setup a user account with all appropriate right to run CF and access 
the shares.  And interestingly, the UNC path does work.  Do you know of a 
reason why mapped drives wouldn't work when they did in CF 7 and earlier?

Tim

>> Actually I misstated that I upgraded, it is a completely new 
>> installation.  I have a mapped drive in widows pointing to a 
>> share on another server.
>
>Are you sure you configured the new installation to run as the appropriate
>user instead of SYSTEM?
>
>If you use a UNC path instead of a mapped drive, does that work?
>
>Dave Watts, CTO, Fig Leaf Software
>http://www.figleaf.com/
>
>Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
>http://training.figleaf.com/
>
>WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
>http://www.webmaniacsconference.com/ 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Security Problem w IIS when using CFINVOKE or CFHTTP

[Alan Rother]

Ok, in a nutshell here is the dilemma I am faced with. I have a
customer who works with a 3rd party vendor. This vendor hosts all of
their data. We are rebuilding their website and have to integrate with
the data on the 3rd party's server. I've gotten the vendor to agree to
build webservices and provide me access to them. They obliged and set
them up using .net on a Win2003 server running IIS6. We're all good so
far. They gave me access to the webservices and even provided me with
a way to test the webservices within the system, some nice built in
tools...

The problem, they used IIS's "Integrated Windows authentication" to
protect the webservices. As far as my testing has shown, I can't
validate a login against them. I re-created the problem on one of the
web servers I control, by setting it's Directory Security up to
"Integrated Windows authentication" and sure enough, same problem. If
I lower it to "Basic authentication (password is sent in clear text)"
CFHTTP and CFINVOKE have no problem getting passed it.

Is there anyway I can get CF to authenticate when IIS is using this
type of security?

I dont care which way I have to go (CFHTTP or CFINVOKE) or I'm will to
explore other CF methods. I have to be able to access these
webservices and I don't know for sure if I am going to be able to talk
them into lowering the security. Despite the fact we are going over
SSL and I'm willing to be locked down by IP address.

Anyone been through this?

I have pictures of the IIS menu in question. The first one shows the
security set to "Basic authentication (password is sent in clear
text)"  (Working) and the second one is of "Integrated Windows
authentication"  (no worky)

http://azcfug.app02.i-sites.com/IIS%5FProblem/

Thanks All

=]
-- 
Alan Rother
Adobe Certified Advanced ColdFusion MX 7 Developer
Manager, Phoenix Cold Fusion User Group, AZCFUG.org

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

RE: Storing Records Weekly in the database - Ideas on how to record the week

[Dawson, Michael]

I would create a calendar table that can be joined to your weekly table.
The tables would be joined by the date fields.

The calendar table would have a record for each date from the beginning
of your data until way in the future.

Also, each record would have a week number, quarter, year, month, etc.
Add any other data fields that would be helpful when querying your data.

m!ke 

-Original Message-
From: Nate Willard [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 22, 2008 1:58 PM
To: CF-Talk
Subject: Re: Storing Records Weekly in the database - Ideas on how to
record the week

Ian,


Great point about the years, I feel silly for not think of that. 


Can anyone recommend a way to obtain the current week's DateFormat for
inserting into the DB?


Thanks

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

RE: Cffile and cfdirectory in CF 8

[Dave Watts]

> Actually I misstated that I upgraded, it is a completely new 
> installation.  I have a mapped drive in widows pointing to a 
> share on another server.

Are you sure you configured the new installation to run as the appropriate
user instead of SYSTEM?

If you use a UNC path instead of a mapped drive, does that work?

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

Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
http://training.figleaf.com/

WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
http://www.webmaniacsconference.com/

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

RE: Storing Records Weekly in the database - Ideas on how to record the week

[Bobby Hartsfield]

I'd suggest storing the full date and time which is basically 'all of the
above' in this case. You can pull any of the other information out of the
date if you need to later.

..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com


-Original Message-
From: Nate Willard [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 22, 2008 2:26 PM
To: CF-Talk
Subject: Storing Records Weekly in the database - Ideas on how to record the
week

Hello,


I'm working to build a system that stores a set of records every week. Can
anyone offer suggestions on how to best save these records in the DB?


Should I have a column 'datetime' and have the result be the Sunday of the
week, for example this week's records all with the datetime: 4/20/2008


or Should I use CF's Week() function and store the week number, which I
believe is currently 17.


I'm looking for your advice to prevent issues when I want to access the data
later down the road. 


Thanks
N





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: Storing Records Weekly in the database - Ideas on how to record the week

[Nate Willard]

Interesting idea.


Perhaps its best to store the current date, and then when I need the data, 
query for the top set of records for the given week? 

- Original Message 
From: Barney Boisvert <[EMAIL PROTECTED]>
To: CF-Talk 
Sent: Tuesday, April 22, 2008 12:27:33 PM
Subject: Re: Storing Records Weekly in the database - Ideas on how to record 
the week

Why not just store 4/22, and then do the date computation on the other
(recall) side?  It'll potentially be a little slower, but unless you
have a crapton of data, its probably irrelevant.

cheers,
barneyb

On Tue, Apr 22, 2008 at 12:24 PM, Nate Willard <[EMAIL PROTECTED]> wrote:
> Greg,
>
>
>  I think its more complicated than that, but I might be over thinking this...
>
>
>  If I want to records weekly and lets say I ran those records today
>
>
>  Todays date is 4/22/2008
>
>
>  But, I would need to insert those records into the database as 4/20/2008 
> since 4/20 is the start of this week.
>
>
>  right?

-- 
Barney Boisvert
[EMAIL PROTECTED]
http://www.barneyb.com/

Got Gmail? I have 100 invites.



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

RE: Reading data from a website

[Bobby Hartsfield]

I'll take one! :-)

..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com

-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED] 

http://tinyurl.com/5holdg





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: Storing Records Weekly in the database - Ideas on how to record the week

[Barney Boisvert]

Why not just store 4/22, and then do the date computation on the other
(recall) side?  It'll potentially be a little slower, but unless you
have a crapton of data, its probably irrelevant.

cheers,
barneyb

On Tue, Apr 22, 2008 at 12:24 PM, Nate Willard <[EMAIL PROTECTED]> wrote:
> Greg,
>
>
>  I think its more complicated than that, but I might be over thinking this...
>
>
>  If I want to records weekly and lets say I ran those records today
>
>
>  Todays date is 4/22/2008
>
>
>  But, I would need to insert those records into the database as 4/20/2008 
> since 4/20 is the start of this week.
>
>
>  right?

-- 
Barney Boisvert
[EMAIL PROTECTED]
http://www.barneyb.com/

Got Gmail? I have 100 invites.

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: Storing Records Weekly in the database - Ideas on how to record the week

[Nate Willard]

Greg,


I think its more complicated than that, but I might be over thinking this...


If I want to records weekly and lets say I ran those records today


Todays date is 4/22/2008


But, I would need to insert those records into the database as 4/20/2008 since 
4/20 is the start of this week.


right?

- Original Message 
From: Greg Morphis <[EMAIL PROTECTED]>
To: CF-Talk 
Sent: Tuesday, April 22, 2008 12:07:17 PM
Subject: Re: Storing Records Weekly in the database - Ideas on how to record 
the week

What do you mean?
current week's dateformat?
now() grabs the date and time..
dateformat() formats the date in whatever way you want.. I've always
saved formatting for the output..


On Tue, Apr 22, 2008 at 1:58 PM, Nate Willard <[EMAIL PROTECTED]> wrote:
> Ian,
>
>
>  Great point about the years, I feel silly for not think of that.
>
>
>  Can anyone recommend a way to obtain the current week's DateFormat for 
> inserting into the DB?
>
>
>  Thanks
>
>
>  - Original Message 
>  From: Ian Skinner <[EMAIL PROTECTED]>
>  To: CF-Talk 
>  Sent: Tuesday, April 22, 2008 11:32:33 AM
>  Subject: Re: Storing Records Weekly in the database - Ideas on how to record 
> the week
>
>
>  Nate Willard wrote:
>  > Hello,
>  >
>  >
>  > I'm working to build a system that stores a set of records every week. Can 
> anyone offer suggestions on how to best save these records in the DB?
>  >
>  >
>  > Should I have a column 'datetime' and have the result be the Sunday of the 
> week, for example this week's records all with the datetime: 4/20/2008
>  >
>  >
>  > or Should I use CF's Week() function and store the week number, which I 
> believe is currently 17.
>  >
>  >
>  > I'm looking for your advice to prevent issues when I want to access the 
> data later down the road.
>  >
>  >
>  > Thanks
>  > N
>
>
> My feeling would be to store the date as a date.  That allows you the
>  most latitude in accessing this data as requirements change over time.
>  If you store the week you would also need to store a year assuming you
>  will eventually have data from more then one 'week 17' as the years go by.
>
>
>
>
>
>  



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: Binding to a CFGrid from tabs

[gary gilbert]

Michael,

Are you using cfajaimport in your tab cfm pages?  If you have ajax code in
your tab source pages you have to use the cfajaximport on those pages too.
since you are binding stuff in those souce pages to your form you probably
need to do an 

Give that a try...

-- 
Gary Gilbert
http://www.garyrgilbert.com/blog


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: Reading data from a website

[Charlie Griefer]

On Tue, Apr 22, 2008 at 7:31 AM, James Smith <[EMAIL PROTECTED]> wrote:
> >  >>below is the link to the website that contains the data I require.
>  >
>  >  Ok, you definitely need CF_REextract:
>  >  http://www.contentbox.com/claude/customtags/REextract/testREextract.cfm

http://tinyurl.com/5holdg

-- 
Evelyn the dog, having undergone further modification pondered the
significance of short-person behaviour in pedal depressed,
pan-chromatic resonance, and other highly ambient domains. "Arf," she
said.

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: Storing Records Weekly in the database - Ideas on how to record the week

[Greg Morphis]

What do you mean?
current week's dateformat?
now() grabs the date and time..
dateformat() formats the date in whatever way you want.. I've always
saved formatting for the output..


On Tue, Apr 22, 2008 at 1:58 PM, Nate Willard <[EMAIL PROTECTED]> wrote:
> Ian,
>
>
>  Great point about the years, I feel silly for not think of that.
>
>
>  Can anyone recommend a way to obtain the current week's DateFormat for 
> inserting into the DB?
>
>
>  Thanks
>
>
>  - Original Message 
>  From: Ian Skinner <[EMAIL PROTECTED]>
>  To: CF-Talk 
>  Sent: Tuesday, April 22, 2008 11:32:33 AM
>  Subject: Re: Storing Records Weekly in the database - Ideas on how to record 
> the week
>
>
>  Nate Willard wrote:
>  > Hello,
>  >
>  >
>  > I'm working to build a system that stores a set of records every week. Can 
> anyone offer suggestions on how to best save these records in the DB?
>  >
>  >
>  > Should I have a column 'datetime' and have the result be the Sunday of the 
> week, for example this week's records all with the datetime: 4/20/2008
>  >
>  >
>  > or Should I use CF's Week() function and store the week number, which I 
> believe is currently 17.
>  >
>  >
>  > I'm looking for your advice to prevent issues when I want to access the 
> data later down the road.
>  >
>  >
>  > Thanks
>  > N
>
>
> My feeling would be to store the date as a date.  That allows you the
>  most latitude in accessing this data as requirements change over time.
>  If you store the week you would also need to store a year assuming you
>  will eventually have data from more then one 'week 17' as the years go by.
>
>
>
>
>
>  

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: Cffile and cfdirectory in CF 8

[Tim Lancaster]

Actually I misstated that I upgraded, it is a completely new installation.  I 
have a mapped drive in widows pointing to a share on another server.

>Are you by chance using a path relative to the old installation of CF7?
>
>~Brad
>
>I just upgraded from CF7 Standard to CF8 Enterprise.  I have several
>scheduled tasks that run everyday that dump files to mapped network
>shares.  Since upgrading, I only get errors to the effect of the path
>cannot be found or make sure the directory doesn't exist.  I have the CF
>service using a domain account with full permissions on the share.  What
>else am I missing?  I installed CF8 on another server just to test and I
>get the same errors.  I am trying to use cfdirectory action="create"
>and all cffile actions that move or copy files to the shares.  I am on
>windows 2003 with IIS6. 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: Storing Records Weekly in the database - Ideas on how to record the week

[Nate Willard]

Greg,


Great questions. The system will be entirely CF and client time does not 
matter. 

- Original Message 
From: Greg Morphis <[EMAIL PROTECTED]>
To: CF-Talk 
Sent: Tuesday, April 22, 2008 11:43:54 AM
Subject: Re: Storing Records Weekly in the database - Ideas on how to record 
the week

Depends.. will this be entirely CF and does the client's time matter?
We have a Flex/Java/Oracle schedule app that at first used dates/times
but trying to work with clients time versus the server's time was a
headache..
Anyways we switched pretty quickly to having a year column, weeknbr
column, day column (day of week) and then the starttime and endtimes
were numbers e.g. 13.5 would be 1:30pm.. then we didnt have to worry
about client/server times..


On Tue, Apr 22, 2008 at 1:25 PM, Nate Willard <[EMAIL PROTECTED]> wrote:
> Hello,
>
>
>  I'm working to build a system that stores a set of records every week. Can 
> anyone offer suggestions on how to best save these records in the DB?
>
>
>  Should I have a column 'datetime' and have the result be the Sunday of the 
> week, for example this week's records all with the datetime: 4/20/2008
>
>
>  or Should I use CF's Week() function and store the week number, which I 
> believe is currently 17.
>
>
>  I'm looking for your advice to prevent issues when I want to access the data 
> later down the road.
>
>
>  Thanks
>  N
>
>
>
>  



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: Embedded YouTube movies

[Torrent Girl]

>You have too much stuff in there. Lose the "&hl=en&rel=0"
>
Actually replacing the double quotes with single quotes (as someone suggested) 
enabled my to use the link as a variable.

Thanks 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: Storing Records Weekly in the database - Ideas on how to record the week

[Nate Willard]

Ian,


Great point about the years, I feel silly for not think of that. 


Can anyone recommend a way to obtain the current week's DateFormat for 
inserting into the DB?


Thanks


- Original Message 
From: Ian Skinner <[EMAIL PROTECTED]>
To: CF-Talk 
Sent: Tuesday, April 22, 2008 11:32:33 AM
Subject: Re: Storing Records Weekly in the database - Ideas on how to record 
the week

Nate Willard wrote:
> Hello,
>
>
> I'm working to build a system that stores a set of records every week. Can 
> anyone offer suggestions on how to best save these records in the DB?
>
>
> Should I have a column 'datetime' and have the result be the Sunday of the 
> week, for example this week's records all with the datetime: 4/20/2008
>
>
> or Should I use CF's Week() function and store the week number, which I 
> believe is currently 17.
>
>
> I'm looking for your advice to prevent issues when I want to access the data 
> later down the road. 
>
>
> Thanks
> N

My feeling would be to store the date as a date.  That allows you the 
most latitude in accessing this data as requirements change over time.  
If you store the week you would also need to store a year assuming you 
will eventually have data from more then one 'week 17' as the years go by.





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: Storing Records Weekly in the database - Ideas on how to record the week

[Greg Morphis]

Depends.. will this be entirely CF and does the client's time matter?
We have a Flex/Java/Oracle schedule app that at first used dates/times
but trying to work with clients time versus the server's time was a
headache..
Anyways we switched pretty quickly to having a year column, weeknbr
column, day column (day of week) and then the starttime and endtimes
were numbers e.g. 13.5 would be 1:30pm.. then we didnt have to worry
about client/server times..


On Tue, Apr 22, 2008 at 1:25 PM, Nate Willard <[EMAIL PROTECTED]> wrote:
> Hello,
>
>
>  I'm working to build a system that stores a set of records every week. Can 
> anyone offer suggestions on how to best save these records in the DB?
>
>
>  Should I have a column 'datetime' and have the result be the Sunday of the 
> week, for example this week's records all with the datetime: 4/20/2008
>
>
>  or Should I use CF's Week() function and store the week number, which I 
> believe is currently 17.
>
>
>  I'm looking for your advice to prevent issues when I want to access the data 
> later down the road.
>
>
>  Thanks
>  N
>
>
>
>  

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: URLs being appended to query string

[Claude Schneegans]

 >>The
frequency of the occurrences, and the constantly changing URL and client IP,
suggests a bot.

Exact, and also the fact that the user agent is always the same:
Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; 
..NET CLR 1.1.4322)

The fact that the IP address changes, suggests it is some kind of worms 
or virus acting from individual PC
it has infected.

I have added some code in my templates that checks for url parameters 
that contains either
the string "http://";, (link injection) or "user" (SQL injection) and if yes,
the IP address is instantly banned for a few days.

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


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: Storing Records Weekly in the database - Ideas on how to record the week

[Ian Skinner]

Nate Willard wrote:
> Hello,
>
>
> I'm working to build a system that stores a set of records every week. Can 
> anyone offer suggestions on how to best save these records in the DB?
>
>
> Should I have a column 'datetime' and have the result be the Sunday of the 
> week, for example this week's records all with the datetime: 4/20/2008
>
>
> or Should I use CF's Week() function and store the week number, which I 
> believe is currently 17.
>
>
> I'm looking for your advice to prevent issues when I want to access the data 
> later down the road. 
>
>
> Thanks
> N

My feeling would be to store the date as a date.  That allows you the 
most latitude in accessing this data as requirements change over time.  
If you store the week you would also need to store a year assuming you 
will eventually have data from more then one 'week 17' as the years go by.



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Storing Records Weekly in the database - Ideas on how to record the week

[Nate Willard]

Hello,


I'm working to build a system that stores a set of records every week. Can 
anyone offer suggestions on how to best save these records in the DB?


Should I have a column 'datetime' and have the result be the Sunday of the 
week, for example this week's records all with the datetime: 4/20/2008


or Should I use CF's Week() function and store the week number, which I believe 
is currently 17.


I'm looking for your advice to prevent issues when I want to access the data 
later down the road. 


Thanks
N



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

flash

[Paul Ihrig]

ok. i have a problem
i can get cfselct to sow current selction in a cfoutput query.
but when i try to do the same thing in a flash form with a repeater.
i cant get the selction to be preselected.
{getAscList.currentItem.titleID} shows the id i want to match.
i cant do it with a bind because i get an error about using a query
and a bind in a select



selected="{getAscList.currentItem.titleID}"

should work...

thanks
-paul

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

RE: Cffile and cfdirectory in CF 8

[Brad Wood]

Are you by chance using a path relative to the old installation of CF7?

~Brad

-Original Message-
From: Tim Lancaster [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 22, 2008 12:43 PM
To: CF-Talk
Subject: Cffile and cfdirectory in CF 8

I just upgraded from CF7 Standard to CF8 Enterprise.  I have several
scheduled tasks that run everyday that dump files to mapped network
shares.  Since upgrading, I only get errors to the effect of the path
cannot be found or make sure the directory doesn't exist.  I have the CF
service using a domain account with full permissions on the share.  What
else am I missing?  I installed CF8 on another server just to test and I
get the same errors.  I am trying to use cfdirectory action="create"
and all cffile actions that move or copy files to the shares.  I am on
windows 2003 with IIS6. 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Cffile and cfdirectory in CF 8

[Tim Lancaster]

I just upgraded from CF7 Standard to CF8 Enterprise.  I have several scheduled 
tasks that run everyday that dump files to mapped network shares.  Since 
upgrading, I only get errors to the effect of the path cannot be found or make 
sure the directory doesn't exist.  I have the CF service using a domain account 
with full permissions on the share.  What else am I missing?  I installed CF8 
on another server just to test and I get the same errors.  I am trying to use 
cfdirectory action="create"  and all cffile actions that move or copy files to 
the shares.  I am on windows 2003 with IIS6. 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

RE: URLs being appended to query string

[Bobby Hartsfield]

The solution would be to validate your url variables so that passing such a
string wouldn't generate an error.

You could of course also just ignore errors within your error template when
cgi.query_string contains http://

 
send the email 


..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com

-Original Message-
From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 22, 2008 12:26 PM
To: CF-Talk
Subject: RE: URLs being appended to query string

Mark Gaulin wrote:
> This is probably an attempt to generate link spam.  It sucks, but other
> than taking measures to reduce the error notifications there may not be
> much you can actually do about it.

Paul Vernon wrote:
> You aren't alone. We're seeing exactly the same and have been for a couple
of months.
> Not sure what the purpose of it is. It could be F***wits trying to inject
URLs into
> site content I guess to increase their back-links to game the Search
Engines.

Mark, Paul:

I had figured as much but was hoping there'd be some way around it.  We
launched a site about 2 weeks back and within 2 days or so, started
receiving notifications from that site as well.  None of these sites have
world-editable pages so I'm not sure what they're trying to do here.  The
frequency of the occurrences, and the constantly changing URL and client IP,
suggests a bot.

Thanks for the help.  As much as it sucks, it's "good" to hear this is
happening elsewhere as well.  I'll have to revamp the error notification
system to ignore this sort of error.

Thanks.

--
Mosh Teitelbaum
evoch, LLC
WWW: http://www.evoch.com/






~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: CFDiv, CFTree sync help

[C. Hatton Humphrey]

Found the solution...

Had to make use of the @change modifier in the bind attribute of the
CFDiv tag... wish those modifiers were better documented!

Hatton

On Tue, Apr 22, 2008 at 11:11 AM, C. Hatton Humphrey
<[EMAIL PROTECTED]> wrote:
> I'm working on a system where I have a CFForm with two elements - a
>  CFTree tag and a CFDiv.  The CFTree is using the CF8 AJAX to populate
>  and that is working just fine.  I need to synchronize the CFDIV
>  contents to the selected element on the CFTree, and that is driving me
>  somewhat batty.
>
>  In this instance I'm working with a folder listing on one side and
>  need the files on the right.  It could be any scenario, though -
>  tables and contents, people and details, etc.  I know the answer is
>  out there (starts humming the X-Files theme) but I'm not searching for
>  the right words.
>
>  So how *do* I update the contents of a CFDiv that is populated using
>  the bind tag (right now bind="cfc:cfc.files.getFiles({folder})")?
>
>  Thanks!
>  Hatton
>

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: URLs being appended to query string

[Josh Nathanson]

Yeah I get tons of these too.  Also form posts with urls in the values.  My 
cfqueryparams catch them all, but I get all the error notifications. 
Sometimes dozens a minute.

-- Josh


- Original Message - 
From: "Paul Vernon" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Tuesday, April 22, 2008 9:07 AM
Subject: RE: URLs being appended to query string


>> http://www.client.com/somePage.cfm?someParam=http://www.zlotow.biz/radi
>> omari
>> ana2/rawi/ayutuqi/
>>
>
> You aren't alone. We're seeing exactly the same and have been for a couple
> of months. Not sure what the purpose of it is. It could be F***wits trying
> to inject URLs into site content I guess to increase their back-links to
> game the Search Engines.
>
> Paul
>
>
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

RE: URLs being appended to query string

[Mosh Teitelbaum]

Mark Gaulin wrote:
> This is probably an attempt to generate link spam.  It sucks, but other
> than taking measures to reduce the error notifications there may not be
> much you can actually do about it.

Paul Vernon wrote:
> You aren't alone. We're seeing exactly the same and have been for a couple
of months.
> Not sure what the purpose of it is. It could be F***wits trying to inject
URLs into
> site content I guess to increase their back-links to game the Search
Engines.

Mark, Paul:

I had figured as much but was hoping there'd be some way around it.  We
launched a site about 2 weeks back and within 2 days or so, started
receiving notifications from that site as well.  None of these sites have
world-editable pages so I'm not sure what they're trying to do here.  The
frequency of the occurrences, and the constantly changing URL and client IP,
suggests a bot.

Thanks for the help.  As much as it sucks, it's "good" to hear this is
happening elsewhere as well.  I'll have to revamp the error notification
system to ignore this sort of error.

Thanks.

--
Mosh Teitelbaum
evoch, LLC
WWW: http://www.evoch.com/




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

RE: URLs being appended to query string

[Paul Vernon]

> http://www.client.com/somePage.cfm?someParam=http://www.zlotow.biz/radi
> omari
> ana2/rawi/ayutuqi/
> 

You aren't alone. We're seeing exactly the same and have been for a couple
of months. Not sure what the purpose of it is. It could be F***wits trying
to inject URLs into site content I guess to increase their back-links to
game the Search Engines.

Paul




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

RE: URLs being appended to query string

[Gaulin, Mark]

This is probably an attempt to generate link spam.  It sucks, but other
than taking measures to reduce the error notifications there may not be
much you can actually do about it.
Thanks
Mark


-Original Message-
From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 22, 2008 12:00 PM
To: CF-Talk
Subject: URLs being appended to query string

All:

 

Lately I've been noticing a lot of errors being generated from client
sites (the sites are setup to notify me of any errors that occur)
because of URLs to non-associated websites being appended to the URL as
in:

 

 
http://www.client.com/somePage.cfm?someParam=http://www.zlotow.biz/radio
mari
ana2/rawi/ayutuqi/

 

somePage.cfm and someParam are legitimate but the value supplied for
someParam is not.  This URL changes constantly and they tend to be
submitted in bursts of about 20-30 in a 1-2 minute time span.  This has
been happening on a number of my clients sites, not just a single one.
So far, none of these have managed to actually do anything other than
generate a ridiculous amount of error notifications but I'm curious
what's going on here.  I would think SQL Injection except that it
doesn't seem to be trying to inject any actual SQL.

 

Any idea what's going on?

 

Thanks.

 

--

Mosh Teitelbaum

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

URLs being appended to query string

[Mosh Teitelbaum]

All:

 

Lately I've been noticing a lot of errors being generated from client sites
(the sites are setup to notify me of any errors that occur) because of URLs
to non-associated websites being appended to the URL as in:

 

 
http://www.client.com/somePage.cfm?someParam=http://www.zlotow.biz/radiomari
ana2/rawi/ayutuqi/

 

somePage.cfm and someParam are legitimate but the value supplied for
someParam is not.  This URL changes constantly and they tend to be submitted
in bursts of about 20-30 in a 1-2 minute time span.  This has been happening
on a number of my clients sites, not just a single one.  So far, none of
these have managed to actually do anything other than generate a ridiculous
amount of error notifications but I'm curious what's going on here.  I would
think SQL Injection except that it doesn't seem to be trying to inject any
actual SQL.

 

Any idea what's going on?

 

Thanks.

 

--

Mosh Teitelbaum

evoch, LLC

WWW: http://www.evoch.com/

 




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

RE: cfquery with array

[Bobby Hartsfield]

Yeah sorry about that... forgot the ( and )

..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com

-Original Message-
From: Richard White [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 22, 2008 10:48 AM
To: CF-Talk
Subject: Re: cfquery with array

ah i managed to fix it by putting brackets around the cfqueryparam then it
works fine :)

thanks again for all your help, this is really useful

richard 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: db connection pooling and performance

[James Holmes]

On Tue, Apr 22, 2008 at 11:37 PM, Brian Dumbledore <[EMAIL PROTECTED]> wrote:

> If all queries were on the same page, would coldfusion somehow optimize new 
> db connections?

It will get one connection from the pool and reuse it for all queries
in that request.

>And when they are all in different pages, it would have to definitely
create a new db connection for each page for sure.

Almost definitely not. If you use the "maintain connections" setting
for the datasource, the connection returns to the pool when the
request is finished with it, ready to be reused. The highest number of
connections to this particular DB you will see from CF in this case is
the highest number of simultaneously running pages all using the same
DB; each connection will be reused for subsequent requests, being
retrieved from and released back to the pool.

-- 
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

db connection pooling and performance

[Brian Dumbledore]

I have a cf page with a couple of queries.. Can the experts comment on 
performance/user experience for this approach: 

I moved a couple of queries to their own individual pages and the original page 
has  asynchronous ajax calls to these secondary pages.

The idea is to load the original page a little faster by distributing the 
workload.

However, obviously, The queries have not gone to each of their own page. How 
would this effect performance? If all queries were on the same page, would 
coldfusion somehow optimize new db connections? And when they are all in 
different pages, it would have to definitely create a new db connection for 
each page for sure. 

Also, from server point of view, instead of one original page, we now have 
multiple hits on server for every single original hit (because of all the 
secondary pages).

I am not sure if this is the right approach. My main intention is to make the 
original page load faster for the user.


Anyone care to comment?? 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

CFDiv, CFTree sync help

[C. Hatton Humphrey]

I'm working on a system where I have a CFForm with two elements - a
CFTree tag and a CFDiv.  The CFTree is using the CF8 AJAX to populate
and that is working just fine.  I need to synchronize the CFDIV
contents to the selected element on the CFTree, and that is driving me
somewhat batty.

In this instance I'm working with a folder listing on one side and
need the files on the right.  It could be any scenario, though -
tables and contents, people and details, etc.  I know the answer is
out there (starts humming the X-Files theme) but I'm not searching for
the right words.

So how *do* I update the contents of a CFDiv that is populated using
the bind tag (right now bind="cfc:cfc.files.getFiles({folder})")?

Thanks!
Hatton

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: cfquery with array

[morgan l]

Glad you got it sorted. Gmail delivered your message saying you'd fixed it
as I hit send.

On Tue, Apr 22, 2008 at 10:03 AM, Richard White <[EMAIL PROTECTED]> wrote:

> yes thanks morgan :)
>
> >Does the IN clause need to be enclosed in parens?:
> >
> >SELECT subjectID, firstName, lastName from subjects where subjectID
> >in  ( >cfsqltype="cf_sql_integer">)
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: cfquery with array

[Richard White]

yes thanks morgan :)

>Does the IN clause need to be enclosed in parens?:
>
>SELECT subjectID, firstName, lastName from subjects where subjectID
>in  (cfsqltype="cf_sql_integer">) 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: cfquery with array

[Greg Morphis]

Only if you want it to work ;)
He fixed that himself.. congrats.

On Tue, Apr 22, 2008 at 9:55 AM, morgan l <[EMAIL PROTECTED]> wrote:
> Does the IN clause need to be enclosed in parens?:
>
>
>  SELECT subjectID, firstName, lastName from subjects where subjectID
>  in  (  cfsqltype="cf_sql_integer">)
>
>
>
>  

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: cfquery with array

[morgan l]

Does the IN clause need to be enclosed in parens?:

SELECT subjectID, firstName, lastName from subjects where subjectID
in  ()


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: cfquery with array

[Richard White]

ah i managed to fix it by putting brackets around the cfqueryparam then it 
works fine :)

thanks again for all your help, this is really useful

richard 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: cfquery with array

[Richard White]

Hi Dominic

fantastic link

thanks, i really need to learn more sql!!!

thanks again

richard

>Hi Richard,
>
>This should help:
>
>http://dev.mysql.com/doc/refman/5.0/en/any-in-some-subqueries.html
>
>Basically, you can do like:
>
>SELECT * FROM tableX
>WHERE tableXId IN (#listOfIds#)
>
>With cfqueryparam that looks like
>
>
>
>You'll also need ArrayToList().
>
>HTH
>
>Dominic
>
>
>
>> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: cfquery with array

[Richard White]

hi

i have tried using the example specified but it is throwing an error, this is 
the example i am trying to use:






SELECT subjectID, firstName, lastName from subjects where subjectID in   
;


and the error i am getting is:

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 'in 1,2,3' at line 1

thanks again for your help

richard


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: Reading data from a website

[James Smith]

>  >>below is the link to the website that contains the data I require.
>
>  Ok, you definitely need CF_REextract:
>  http://www.contentbox.com/claude/customtags/REextract/testREextract.cfm

No, you don't. I have NEVER come across a situation where I needed a
commercial solution to regex in CF, and I use regex a lot and have
done screen scraping with it too.

--
Jay

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: cfquery with array

[Richard White]

thanks for all your replies, there is so many places i could use this. i have 
always been doing a lot of processing with cf (loops, formatting, etc...) and 
after recently looking into why the performance issues are not so great i am 
starting to see that mysql and cfquery can 
 be used for most of the processing and speeding things up loads

thanks again for your help, i see i still have a lot to learn :)


> hi
> 
> i have an array of subjectId's. i have a table in my database called 
> subjects with the primary key set as subjectID
> 
> i have 2 other columns called first name and last name.
> 
> i want to be able to get the first names and last names only for the 
> subjects ids stored in my array
> 
> is there a way in mysql or coldfusion to do this without the need of a 
> loop
> 
> or is the only way to loop through the array of subject ids getting 
> each first name and last name one at a time
> 
> thanks 


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

RE: Reading data from a website

[Bobby Hartsfield]

Once again, you "definitely" DON'T need it. Paul has already offered two
MUCH more effiecient FREE solutions.

..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com


-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 22, 2008 9:44 AM
To: CF-Talk
Subject: Re: Reading data from a website

 >>below is the link to the website that contains the data I require.

Ok, you definitely need CF_REextract:
http://www.contentbox.com/claude/customtags/REextract/testREextract.cfm

You can even test it on your page here:
http://www.contentbox.com/claude/customtags/REextract/testingREextract.cfm
1. Select http for inputmode
2. Enter dataTableRowData"> in RE1
3. enter  in RE2
4. enter the address of your page in the URL field,
5. click Test, and voil?...

For your final solution, you will use a just little more sophisticated loop
to extract exactly what you need.

See also this page which uses the same tag to extract weather forecast 
from environment Canada:
http://www.fafo.on.ca/

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





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: Reading data from a website

[Claude Schneegans]

 >>below is the link to the website that contains the data I require.

Ok, you definitely need CF_REextract:
http://www.contentbox.com/claude/customtags/REextract/testREextract.cfm

You can even test it on your page here:
http://www.contentbox.com/claude/customtags/REextract/testingREextract.cfm
1. Select http for inputmode
2. Enter dataTableRowData"> in RE1
3. enter  in RE2
4. enter the address of your page in the URL field,
5. click Test, and voilà...

For your final solution, you will use a just little more sophisticated loop
to extract exactly what you need.

See also this page which uses the same tag to extract weather forecast 
from environment Canada:
http://www.fafo.on.ca/

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



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: cfquery with array

[Greg Morphis]

You could use the ArrayToList function..
That will convert your array to a list and then just select from table
where id in  

something like that


On Tue, Apr 22, 2008 at 8:24 AM, Richard White <[EMAIL PROTECTED]> wrote:
> hi
>
>  i have an array of subjectId's. i have a table in my database called 
> subjects with the primary key set as subjectID
>
>  i have 2 other columns called first name and last name.
>
>  i want to be able to get the first names and last names only for the 
> subjects ids stored in my array
>
>  is there a way in mysql or coldfusion to do this without the need of a loop
>
>  or is the only way to loop through the array of subject ids getting each 
> first name and last name one at a time
>
>  thanks
>
>  

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

RE: cfquery with array

[Bobby Hartsfield]

Che meant arraytolist() of course

Assuming that subjected is an integer:

Select firstName, lastName from table where subjected in 


This would throw an error on an empty list so be sure to check the
arrayLen(myArray) beforehand

..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com

-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 22, 2008 9:27 AM
To: CF-Talk
Subject: RE: cfquery with array

Richard, try using listtoarray to create a new variable and then a SQL "IN"
statement on the newly created list.
~Che 

-Original Message-
From: Richard White [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 22, 2008 9:24 AM
To: CF-Talk
Subject: cfquery with array

hi

i have an array of subjectId's. i have a table in my database called
subjects with the primary key set as subjectID

i have 2 other columns called first name and last name.

i want to be able to get the first names and last names only for the
subjects ids stored in my array

is there a way in mysql or coldfusion to do this without the need of a loop

or is the only way to loop through the array of subject ids getting each
first name and last name one at a time

thanks 





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: cfquery with array

[Dominic Watson]

Hi Richard,

This should help:

http://dev.mysql.com/doc/refman/5.0/en/any-in-some-subqueries.html

Basically, you can do like:

SELECT * FROM tableX
WHERE tableXId IN (#listOfIds#)

With cfqueryparam that looks like



You'll also need ArrayToList().

HTH

Dominic


On 22/04/2008, Richard White <[EMAIL PROTECTED]> wrote:
>
> hi
>
> i have an array of subjectId's. i have a table in my database called
> subjects with the primary key set as subjectID
>
> i have 2 other columns called first name and last name.
>
> i want to be able to get the first names and last names only for the
> subjects ids stored in my array
>
> is there a way in mysql or coldfusion to do this without the need of a
> loop
>
> or is the only way to loop through the array of subject ids getting each
> first name and last name one at a time
>
> thanks
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

RE: cfquery with array

[Che Vilnonis]

Sorry, I meant arraytolist. ;)

-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 22, 2008 9:27 AM
To: CF-Talk
Subject: RE: cfquery with array

Richard, try using listtoarray to create a new variable and then a SQL "IN"
statement on the newly created list.
~Che 

-Original Message-
From: Richard White [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 22, 2008 9:24 AM
To: CF-Talk
Subject: cfquery with array

hi

i have an array of subjectId's. i have a table in my database called
subjects with the primary key set as subjectID

i have 2 other columns called first name and last name.

i want to be able to get the first names and last names only for the
subjects ids stored in my array

is there a way in mysql or coldfusion to do this without the need of a loop

or is the only way to loop through the array of subject ids getting each
first name and last name one at a time

thanks 





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

RE: cfquery with array

[Che Vilnonis]

Richard, try using listtoarray to create a new variable and then a SQL "IN"
statement on the newly created list.
~Che 

-Original Message-
From: Richard White [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 22, 2008 9:24 AM
To: CF-Talk
Subject: cfquery with array

hi

i have an array of subjectId's. i have a table in my database called
subjects with the primary key set as subjectID

i have 2 other columns called first name and last name.

i want to be able to get the first names and last names only for the
subjects ids stored in my array

is there a way in mysql or coldfusion to do this without the need of a loop

or is the only way to loop through the array of subject ids getting each
first name and last name one at a time

thanks 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: hello folks How to do paging on looping a list i was confused please help me

[Paul Stewart]

or indeed my custom tag cfMagicpager.

http://www.stewart-web.co.uk/blog/index.cfm/2008/4/20/Cold

It is a different take than Nathan's on pagination.

Nathan Strutz wrote:
> Shariff,
>
> I don't know exactly what you are attempting to do, but if you are looking
> for a way to page your data, you may want to look into my Pagination.cfc
> project. http://paginationcfc.riaforge.org/
>
> If that's not it, perhaps you can elaborate your problem, with the overview,
> what your goal is, what you have tried, what you get output from that code
> and why it has failed?
>
> 1000 rows in a database table should not be a problem. I have had tables
> with millions of rows.
>
>   


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

cfquery with array

[Richard White]

hi

i have an array of subjectId's. i have a table in my database called subjects 
with the primary key set as subjectID

i have 2 other columns called first name and last name.

i want to be able to get the first names and last names only for the subjects 
ids stored in my array

is there a way in mysql or coldfusion to do this without the need of a loop

or is the only way to loop through the array of subject ids getting each first 
name and last name one at a time

thanks 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: Parse phone number characters - almost there ...

[Web Specialist]

Agree with Sonny. I'm using this script:

 
  function JustNumeric(string){
   return reReplace(string,'[^[:digit:]]','','all');
  }
 

Cheers
Marco Antonio


On 4/22/08, Sonny Savage <[EMAIL PROTECTED]> wrote:
>
> I'd recommend removing everything but the digits, and regex is perfect for
> that:
> 
>
> Store the resulting value, and then format it as you desire when
> displaying.
>
> On Tue, Apr 22, 2008 at 3:34 AM, Azadi Saryev <[EMAIL PROTECTED]> wrote:
>
> > rereplace() is looking for a regexp, while you are giving it a literal
> > string to find and replace...
> > either use replace() function, or give rereplce() a regexp to match the
> > characters you want to remove.
> > something like rereplace(phone, "[\(\)\.-]", "", "all")
> >
> > Azadi Saryev
> > Sabai-dee.com
> > http://www.sabai-dee.com/
> >
> >
> >
> > [EMAIL PROTECTED] wrote:
> > > I've got different phone number formats due to an csv import.  I'm
> > trying to remove
> > > phone number formating from the database and just have the
> numbers.  As
> > I parse
> > > through my phone numbers from a query, this code is throwing errors.
> >  I'm trying to
> > > get rid of ')', '(', '.' and '-'
> > >
> > > 
> > > 
> > > 
> > > 
> > >
> > > Thanks
> > >
> > > D
> > >
> > >
> >
> >
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

RE: Parse phone number characters - almost there ...

[Bobby Hartsfield]

With what you have now, you should be using replace not REreplace

But... of course I'd just use a regex to strip everything but numbers
Rereplace(phone, "[^\d]", "", "all")

If there happen to be any other characters that you want to keep besides
digits (like a space) just put them right after the \d but inside the
closing bracket
Example: Rereplace(phone, "[^\d ]", "", "all")


..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 22, 2008 3:26 AM
To: CF-Talk
Subject: Parse phone number characters - almost there ...

I've got different phone number formats due to an csv import.  I'm trying to
remove 
phone number formating from the database and just have the numbers.  As I
parse
through my phone numbers from a query, this code is throwing errors.  I'm
trying to
get rid of ')', '(', '.' and '-'






Thanks

D



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

CFFTP CF8.01 timeout and connection property bug/issues

[Paul Vernon]

Hi All,

It's been a long time since I've had to use CFFTP (CF5) so I may well be 
missing something but I seem to have come across a couple of things one of 
which, I consider to be a bug.

Firstly, the bug.

I need to download a large (600Mb) file, if I set the timeout value to 
something like 5 seconds for my connection then the tag times out after 5 
seconds rather than after 5 seconds of inactivity. There is a major difference 
here.

If I set the timeout to 30 seconds, I get about 45Mb down before the tag times 
out.
If I set the timeout to 300 seconds, I get about 450Mb down before the tag 
times out.

If I set the timeout to something silly, say 12 seconds, the tag just hangs 
(I assume until the timeout is reached). (I know why this is).

If I set the timeout to something more reasonable, say 900 seconds, the tag 
does not return until the 900 seconds are up and I get the file :-).

CFFTP is hanging until timeout because of the config of the FTP server 
(something I cannot change as it's a 3rd party server). I've double checked the 
connection with standard FTP clients and they too hang at the end until their 
timeout is reached.

The difference between CFFTP and other FTP clients is that other FTP clients 
can have timeouts of say 5 seconds and only timeout after the entire file has 
been downloaded. Ideally this is what CFFTP should do and I'd consider it to be 
a bug if it did otherwise which it does.

Secondly, the annoying problem.

The server I'm connecting to requires a PASV connection from where I am. 
Ideally, I would like set this on the first connection and have CF track this 
in the connection structure that is created. It isn't. Every CFFTP call I make, 
I have to set passive="Yes". Until I dumped out the connection structure, I 
couldn't figure out why I wasn't even able to list a set of directories after 
the initial connection as I'd assumed that passive being an attribute of the 
connection would be carried through in the connection struct. This is not so. 
Annoying, fixable but shouldn't be there.

Paul



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: Parse phone number characters - almost there ...

[Sonny Savage]

I'd recommend removing everything but the digits, and regex is perfect for
that:


Store the resulting value, and then format it as you desire when displaying.

On Tue, Apr 22, 2008 at 3:34 AM, Azadi Saryev <[EMAIL PROTECTED]> wrote:

> rereplace() is looking for a regexp, while you are giving it a literal
> string to find and replace...
> either use replace() function, or give rereplce() a regexp to match the
> characters you want to remove.
> something like rereplace(phone, "[\(\)\.-]", "", "all")
>
> Azadi Saryev
> Sabai-dee.com
> http://www.sabai-dee.com/
>
>
>
> [EMAIL PROTECTED] wrote:
> > I've got different phone number formats due to an csv import.  I'm
> trying to remove
> > phone number formating from the database and just have the numbers.  As
> I parse
> > through my phone numbers from a query, this code is throwing errors.
>  I'm trying to
> > get rid of ')', '(', '.' and '-'
> >
> > 
> > 
> > 
> > 
> >
> > Thanks
> >
> > D
> >
> >
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: Parse phone number characters - almost there ...

[Azadi Saryev]

rereplace() is looking for a regexp, while you are giving it a literal
string to find and replace...
either use replace() function, or give rereplce() a regexp to match the
characters you want to remove.
something like rereplace(phone, "[\(\)\.-]", "", "all")

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/



[EMAIL PROTECTED] wrote:
> I've got different phone number formats due to an csv import.  I'm trying to 
> remove 
> phone number formating from the database and just have the numbers.  As I 
> parse
> through my phone numbers from a query, this code is throwing errors.  I'm 
> trying to
> get rid of ')', '(', '.' and '-'
>
> 
> 
> 
> 
>
> Thanks
>
> D
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Re: Parse phone number characters - almost there ...

[AJ Mercer]

you are not using regex so just use the replace function (no REreplace)


On Tue, Apr 22, 2008 at 3:25 PM, <[EMAIL PROTECTED]> wrote:

> I've got different phone number formats due to an csv import.  I'm trying
> to remove
> phone number formating from the database and just have the numbers.  As I
> parse
> through my phone numbers from a query, this code is throwing errors.  I'm
> trying to
> get rid of ')', '(', '.' and '-'
>
>
>
>
>
>
> Thanks
>
> D
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

RE: Proxy Authentication with Oracle - Does ColdFusion Support th is?

[Joseph Bugeja]

In reality, connection pooling with proxy authentication should
automatically create a second session, a lightweight session, with the
actual user id and password. Naturally, the dba must grant the proxy user
connect rights on the database for this to work.

I did not investigate but I think, as was suggested, we need to create our
own JNDI data-source for this to work, and then find a way to dynamically
inject the specific settings.

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Monday, April 21, 2008 8:51 PM
To: CF-Talk
Subject: RE: Proxy Authentication with Oracle - Does ColdFusion Support th
is?

> But isn't that what the OP wanted?  The ability to have 
> auditing based on user authentication over the datasource and 
> the session it creates (not just as a login to a table)?  
> Wouldn't a datasource created at the J2EE server behave the 
> same way?  I would assume that the ASP pool would work the 
> same way.  I'd be curious to see how it would run under load
> testing.

No, the OP wanted to use proxy authentication, which would let you have a
single connection pool with a single username and password, but would also
let you track the Oracle account using a specific connection from that pool
by its own specific username and password. This is an Oracle-specific
feature, which requires manipulation of the connection string at runtime to
include the proxy authentication attributes.

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

Fig Leaf Training: Adobe/Google/Paperthin Certified Partners 
http://training.figleaf.com/

WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
http://www.webmaniacsconference.com/



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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

Parse phone number characters - almost there ...

[coldfusion . developer]

I've got different phone number formats due to an csv import.  I'm trying to 
remove 
phone number formating from the database and just have the numbers.  As I parse
through my phone numbers from a query, this code is throwing errors.  I'm 
trying to
get rid of ')', '(', '.' and '-'






Thanks

D

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

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