Re: SQL Weirdness on text file query

2008-05-19 Thread James Smith
OK, eventually found a fix.. SELECT *, STR(the-field) AS TheField FROM theTextFile Kind of works but still drops leading zeroes so I have to re add them after the select... -- Jay On Wed, May 14, 2008 at 12:11 PM, James Smith [EMAIL PROTECTED] wrote: I am querying a text file and getting

SQL Weirdness on text file query

2008-05-14 Thread James Smith
tried using convert() but that throws an undefined function error. Does any one know how I can get the text file odbc driver to read this field as a varchar? -- James Smith IT Director Music Express Ltd ~| Adobe® ColdFusion® 8

Re: OT - Google Hosted Email

2008-05-09 Thread James Smith
Google apps rules, we use it for about a dozen domains and about 25 users and it works like a dream, even for those older staff members who insist on keeping with outlook! I still haven't got around to re-purposing the old linux mail server though! -- Jay

Re: Reading data from a website

2008-04-22 Thread 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

Re: CF and SQL Server temporary tables

2008-04-17 Thread James Smith
If I remember correctly if you have CF maintaining connections your temp table will hang around almost indefinitely, best practice would be to DROP it once you are done with it. Also worth noting that if the page that creates the table can be called multiple times simultaneously (by different

Re: whats the best way of doing this

2008-04-15 Thread James Smith
Can't really help without more information... How are you storing consultantid in the tbl_clients table, specifically for when you have added multiples? I suspect what you really need here is a many-to-many relationship for which you will need a linking table in between your current two. -- Jay

Re: domain registrar

2008-04-14 Thread James Smith
3D Secure is the collective name for Verified by Visa, *Oh* that pile of pointless interjection that keeps getting in the way of my purchases :-) Indeed, so far I have refused to register any of my cards since there is no benefit to me, a 3D secured transaction shifts fraud liability from

Re: domain registrar

2008-04-14 Thread James Smith
I have registered domains with a few services in the past...i just registered 3 with name.com. it has a deal running at the moment where it is 5.99 for the first year and you get a google apps standard edition with each domain. the following year the renew the domain it would be 7.99.

Re: domain registrar

2008-04-11 Thread James Smith
123-reg.co.uk I wouldn't go near 123-reg. I have loads of domains with them because the USED to be a good company, however they have changed hands twice since then. Customer support emails take forever (a couple of days) to get responded to and customer support phone calls cost £1.50 per

Re: domain registrar

2008-04-11 Thread James Smith
Wow, never heard a bad word against them till now. They started going wrong about 6 months ago and although the last couple of months have shown marked improvement I am afraid it is too late, they have already lost my confidence. -- Jay

Re: domain registrar

2008-04-11 Thread James Smith
if you have 3D secure enabled on your card you can pretty much forget it. Have what ? 3D Secure is the collective name for Verified by Visa, MasterCard SecureCode, J/Secure etc... http://en.wikipedia.org/wiki/3D_secure -- Jay

Re: 3D Secure (WAS: domain registrar)

2008-04-11 Thread James Smith
3D secure is a new system in the UK for added security on credit card processing through gateways. Not true, it was first introduced (version 0.7) in the US only. -- Jay ~| Adobe® ColdFusion® 8 software 8 is the most

Re: ColdFusion Mailing list

2008-04-09 Thread James Smith
I am in search of a prebuilt mailing list application. We have used http://www.2simplifi.com/ws/page.cfm/pid/1/sid/3 with no problems. It isn't really a mailing list though, may not be what you were looking for. -- Jay ~|

Lucene (Was: SOUNDEX() in MSSQL)

2008-04-04 Thread James Smith
OK, does anyone have any good examples of setting up and using Lucene? The Apache docs are not beginner friendly... On Thu, Apr 3, 2008 at 3:28 PM, James Smith [EMAIL PROTECTED] wrote: If you want really good search results, look into Lucene. I believe you can use the Did you mean

Re: Lucene (Was: SOUNDEX() in MSSQL)

2008-04-04 Thread James Smith
://www.coldfusionjedi.com/index.cfm/2007/9/30/ColdFusion-Lucene-Test I have got it up and running so it is do-able cflucene.org is MIA btw I have the source somewhere if you are interested. G On Fri, Apr 4, 2008 at 10:47 AM, James Smith [EMAIL PROTECTED] wrote: OK, does anyone have any good examples

SOUNDEX() in MSSQL

2008-04-03 Thread James Smith
Does any one know how to use MSSQL's SOUNDEX() functionality to get good search results? Lets say I am doing a product search by title, if the title in the DB is Blade Runner (DVD) and someone searches for Blade Runner then WHERE SOUNDEX(title) = SOUNDEX(#form.title#) will work just fine but if

Re: SOUNDEX() in MSSQL

2008-04-03 Thread James Smith
Maybe a Quick removal of stoplist words from your search string before matching? Not really what I am after, perhaps my example was to simple... What is someone searches for dvd blade runner or Harrison Ford blade runner? I am really asking if there is some standard way of using the power of

Re: SOUNDEX() in MSSQL

2008-04-03 Thread James Smith
IMO, the soundex algorithm is not appropriate in this case. Soundex extract a key which essentially depends on the first syllable of the string. It has been develop mostly for names, not for any kind of string. As far as I can tell it would work perfectly for this...

Re: SOUNDEX() in MSSQL

2008-04-03 Thread James Smith
I'm not sure soundex is what you want to use here. Soundex is for searching for words that sound alike but may be spelled differently, ie searching for a person named Smyth and you search for Smith. I know, I was hoping to use this to match runner when a user types runer into the search

Re: SOUNDEX() in MSSQL

2008-04-03 Thread James Smith
If you want really good search results, look into Lucene. I believe you can use the Did you mean functionality, which I think is what you're going for. I will have a look into it, cheers. -- Jay ~| Adobe® ColdFusion® 8

Re: regex values between

2008-04-02 Thread James Smith
cfset myVal = '%@ attribute name=myName type=mytype required=false description=mydescription %' cfoutput p name = #reReplace(myVal,'(.*)name=(.*?)(.*)','\2','ALL')#br type = #reReplace(myVal,'(.*)type=(.*?)(.*)','\2','ALL')#br required =

Re: Trim leading zeros

2008-04-01 Thread James Smith
numberFormat(yourNumber,0) or if you want to be silly... rereplace(yourNumber,'^0+','','ALL') On Tue, Apr 1, 2008 at 3:44 PM, James Smith [EMAIL PROTECTED] wrote: numberformat(youNumber,0) On Tue, Apr 1, 2008 at 3:42 PM, Paul Ihrig [EMAIL PROTECTED] wrote: how would i trim the results

Re: Trim leading zeros

2008-04-01 Thread James Smith
CFLib.org has a UDF that does this: http://cflib.org/udf.cfm?ID=239 That wouldn't work, looking at the code for that UDF it would only strip the first zero... -- Jay ~| Adobe® ColdFusion® 8 software 8 is the most important

Re: Trim leading zeros

2008-04-01 Thread James Smith
Actually doing anything mathematical to it will work too so you could also do... #yourNumber*1# #yourNumber+1-1# #ceiling(yourNumber)# etc... -- Jay ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release

Re: Trim leading zeros

2008-04-01 Thread James Smith
!ke -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2008 9:52 AM To: CF-Talk Subject: Re: Trim leading zeros CFLib.org has a UDF that does this: http://cflib.org/udf.cfm?ID=239 That wouldn't work, looking at the code

Re: Reg ex question

2008-03-18 Thread James Smith
Assuming you meant HEAD and not [HEAD] you can use... reReplaceNoCase(thisPage.string,'HEAD(.+)/HEAD(.*)','\1') If you meant to use square brackets it will change to... reReplaceNoCase(thisPage.string,'\[HEAD\](.+)\[/HEAD\](.*)','\1') -- Jay On Tue, Mar 18, 2008 at 3:52 PM, Qasim Rasheed

Re: Reg ex question

2008-03-18 Thread James Smith
you can actually do both with the same regex... cfset thisPage.result1 = reReplaceNoCase(thisPage.string,'\[HEAD\](.+)\[/HEAD\].*\[BODY\](.+)\[/BODY\]','\1') cfset thisPage.result2 = reReplaceNoCase(thisPage.string,'\[HEAD\](.+)\[/HEAD\].*\[BODY\](.+)\[/BODY\]','\2') -- Jay On Tue, Mar 18,

Re: Still can't make new posts to the CF-talk list

2008-03-14 Thread James Smith
And you posted this... how? On Fri, Mar 14, 2008 at 4:41 PM, Andy Matthews [EMAIL PROTECTED] wrote: Is anyone else still having problems making new posts to the CF-Talk list from external programs? I've not been able to make new posts to the CF-Talk list for about a month now. I can reply to

RE: Lat Long convertion to Easting and Northing

2008-03-03 Thread James Smith
If all you have is 6 digits it can't be OSGB36, that requires 2 letters as well. http://en.wikipedia.org/wiki/British_national_grid_reference_system -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: 03 March 2008 12:19 To: CF-Talk Subject: Re: Lat Long

RE: Resolution and Color Depth Data

2008-02-25 Thread James Smith
Ok, I can understand that a resolution of 3840x1024 is some lucky person with 3 1280x1024 monitors next to each other but what kind of device produces an 800x5000 resolution!? -- Jay -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: 23 February 2008 06:54 To: CF-Talk

RE: Currency Exchange rates - XML format

2008-02-01 Thread James Smith
There is also also an XML feed at http://www.ecb.int/stats/eurofxref/eurofxref-daily.xml that I use, it's base currency is the euro but that is a simple convertion. -- Jay -Original Message- From: Matthew Friedman [mailto:[EMAIL PROTECTED] Sent: 31 January 2008 16:32 To: CF-Talk

RE: CF Charting question

2008-02-01 Thread James Smith
I have always used CFCHAT but for my next project I am going to give Flot a try, looks really cool and runs over jQuery. Refs: http://ajaxian.com/archives/plotting-in-jquery http://code.google.com/p/flot/ -- Jay -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: 31

RE: White Space Eliminator

2008-01-22 Thread James Smith
I also seem to recall the saving over HTTP 1.1 is negligible as it compresses on the fly. It can, but you would have to enable it in your HTTP server. -- Jay No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.19.8/1236 - Release

RE: Odd CFMail Problem

2008-01-15 Thread James Smith
ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com James Smith wrote: I have recently started getting a lot of failed messages in the \Mail\Undelivr folder with 421 errors in the log files. It seems to be that if I put 4-5 messages in the spool most of them go

Odd CFMail Problem

2008-01-14 Thread James Smith
I have recently started getting a lot of failed messages in the \Mail\Undelivr folder with 421 errors in the log files. It seems to be that if I put 4-5 messages in the spool most of them go most of the time, if I put 20-30 messages in the spool half of them fail and if I put 100-500 messages in

Pulling data from a remote CSV file

2007-12-12 Thread James Smith
I need to pull data from a remote CSV file and the way I see it I have 2 options. 1) Use CFHTTP to load it directly into a query variable. 2) Use CFHTTP to download the file and then CFQUERY it to get the data. The CSV file is returned as an attachment not directly as part of the body text, this

Site-wide Error Handler

2007-12-10 Thread James Smith
Is there a way to override the Site-wide Error Handler for a specific template? I ask because I need to test some code on our production server due to some third party licensing issues but my errors are of course obscured by our error handler. I don't want to turn it off globally as that would

RE: Site-wide Error Handler

2007-12-10 Thread James Smith
) Then in the template specified in the cferror tag you could dump out certain structures to help yourself find any errors. -- Jake Churchill Team Leader 11204 Davenport, Ste. 100 Omaha, NE 68154 http://www.cfwebtools.com 402-408-3733 x103 From: James

RE: Site-wide Error Handler

2007-12-10 Thread James Smith
, Ste. 100 Omaha, NE 68154 http://www.cfwebtools.com 402-408-3733 x103 -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: Monday, December 10, 2007 8:03 AM To: CF-Talk Subject: RE: Site-wide Error Handler How could I use this to disable the Site-wide Error Handler (set

RE: CFEclipse / SVN problem

2007-11-13 Thread James Smith
I don't know if the 1-click install sets up services but I am sure it doesn't install apache. Did you try svn://localhost/? -Original Message- From: ColdFusion [mailto:[EMAIL PROTECTED] Sent: 13 November 2007 03:41 To: CF-Talk Subject: OT: CFEclipse / SVN problem Configuration: I

RE: DNS not specific to ColdFusion

2007-10-18 Thread James Smith
It is also worth noting that Google can mark you down for duplicate content so if you have multiple domains and multiple sub-domains pointing to the same site your page rank can suffer. What I do here where I have about 20 domains pointing to the same site with and without www on is to have one

RE: SQL Concat Issue

2007-10-15 Thread James Smith
With some DB's moving your criteria from the WHERE clause to the HAVING clause will take care of it since HAVING is evaluated after the results have been calculated... sometimes... -- Jay -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 13

RE: SHA Hashing...

2007-10-08 Thread James Smith
Thanks guys, nothing is ever as simple as it should be is it ;-) anyway I managed to find a couple of cf custom tags to do the job in the end, thanks for clarifying the situation for me. -- Jay No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.488 / Virus

Graphing date ranges...

2007-10-08 Thread James Smith
I have a cfchart displaying dates along the X axis, is there any way to get ColdFusion to treat these as a scale so that a 7 day gap in the data would stretch the graph out to interpolate the missing days? CFChart does have an xAxisType attribute but to set it to scale the data must be numeric

RE: Graphing date ranges...

2007-10-08 Thread James Smith
not an overly complicated task, but a calendar table will really help you out for this and many other tasks too, I'd highly recommend one. Let me know if you need any more help Jay, Rob -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: 08 October 2007 10:44 To: CF-Talk

RE: Graphing date ranges...

2007-10-08 Thread James Smith
supposed to. I've used this method before on my application solve the same problem so it defiantly works and is a nice efficient way to solve the problem. Rob -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: 08 October 2007 12:46 To: CF-Talk Subject: RE: Graphing date ranges

RE: Case Sensitivity

2007-10-05 Thread James Smith
Something that hasn't been mentioned yet and as far as I am aware is the only case sensitive feature of CF that isn't case sensitive because of some other reason (java or the file system for instance) and that is query of queries. For some reason in QoQ A!=a even though in most other DB's A=a

SHA Hashing...

2007-10-05 Thread James Smith
I have a need to do the following... quote Create an RFC 2104 compliant HMAC-SHA1 hash on the Action+Timestamp string, using the Secret Access Key as the key. /quote Unfortunately is seems like I can use hash() with the SHA algorithm but not provide a key, or I can use encrypt() with a key but

RE: Dealing with 'fake' folders?

2007-09-19 Thread James Smith
Could you create a 404.cfm page that does any processing you need and point IIS/Apache to that file as your custom 404 error page? -- Jay -Original Message- From: Scott Weikert [mailto:[EMAIL PROTECTED] Sent: 19 September 2007 15:42 To: CF-Talk Subject: Dealing with 'fake' folders? Hi

Application.cfc adding whitespace

2007-09-03 Thread James Smith
I have a cfm page which must at all costs return a simple pipe delimited list with no whitespace before or after it. Application.cfc is adding some and messing everything up. For now I have fixed the problem by moving the relevant cfm page into its own folder with its own [blank] application.cfc

RE: Application.cfc adding whitespace

2007-09-03 Thread James Smith
Output=no doesn't quite work (almost but not quite) since setting it on the onRequest() function results in no output being sent to the browser at all! However, adding cfcontent reset=yes directly before cfinclude template=#Arguments.targetPage# in the onRequest() function seems to have solved

Query speed diference

2007-08-30 Thread James Smith
Which of these two methods would be faster? - Method 1 - cfquery SELECT * FROM table WHERE someID = #someVar# /cfquery cfif query.recordCount IS 1 cfqueryUPDATE table.../cfquery cfelse cfqueryINSERT INTO table.../cfquery /cfif - Method 2 -

RE: Mail Queue

2007-08-23 Thread James Smith
I think if you specify the spoolenable=false inside the cfmail that technically jumps the spool and sends it directly to the mailserver. We won't be sending another bulk mail until next week now but I will do some testing with spoolEnable then and let you know how it goes. Cheers. -- Jay No

Mail Queue

2007-08-22 Thread James Smith
Is there any way to have mail sent with CFMAIL jump the queue? A couple of times a week we send large mail outs to several thousand customers and this takes almost no time to get into the spool folder but a couple of hours to get from there to the mail server. If during this time someone places

RE: Forcing a session to end...

2007-08-03 Thread James Smith
All this being said, is there any way I can force a user to get a new session id. I can clean up the old session by hand but I need them to be pushed into a new session. -- Jay ~| Create robust enterprise, web RIAs. Upgrade to

RE: Forcing a session to end...

2007-08-03 Thread James Smith
not - be something you are concerned with. You need to concern yourself with the data, and as others have pointed out here there are simple ways to clear the data. On 8/3/07, James Smith [EMAIL PROTECTED] wrote: All this being said, is there any way I can force a user to get a new session id. I can clean

Forcing a session to end...

2007-08-02 Thread James Smith
Is there any way to end a session when a logout link is clicked? I have tried... cfset temp = onSessionEnd(session,application) cfapplication name=application sessiontimeout=#createTimeSpan(0,0,0,0)# But it leaves the session scope fully populated. I have even tried... cfset temp =

CF8 and cfimage captchas

2007-07-24 Thread James Smith
While messing around with CF8 I inevitably came across cfimage and tried creating a captcha with the following line of code... cfimage action=captcha text=iamhuman fontsize=24 difficulty=low width=250 height=40 / Unfortunately our servers have a barcode

RE: Current time in seconds

2007-07-17 Thread James Smith
cfset startTime = {ts '2007-07-01 00:00:00'} cfset nowTime = now() cfset seconds = dateDiff('s',startTime,nowTime) cfoutputp#seconds#br /#dateAdd('s',seconds,startTime)#/p/cfoutput -- Jay -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED] Sent: 17 July 2007 14:17 To: CF-Talk

RE: Mail error

2007-07-11 Thread James Smith
Well so far all seems ok so for future reference for anyone this problem happens to, removing update 2 seems to solve it. -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: 02 July 2007 11:20 To: CF-Talk Subject: RE: Mail error In this case I had only just installed CF

onSeessionEnd not working?

2007-07-06 Thread James Smith
I currently have an Application.cfc with the following 3 functions... cffunction name=onApplicationStart returnType=void output=no cfscript Application.Sessions = 0; /cfscript /cffunction cffunction name=onSessionStart returnType=void cfscript

RE: Dreamweaver and Vista (zip issue fixed)

2007-07-06 Thread James Smith
Well I finally got sick of the one vista issue still bugging me, the slow zip file handling and slow file copy/move operations. http://support.microsoft.com/kb/931770/en-us The hotfix above will fix your problems, and if you don't want to phone Microsoft to get it just goole search it and you

RE: onSeessionEnd not working?

2007-07-06 Thread James Smith
: 06 July 2007 09:48 To: CF-Talk Subject: Re: onSeessionEnd not working? If I understand your question, you can not expect the onSessionEnd to fire when a user close their browser. It is only fired when the session actually times out by the settings set within you admin settings. On 7/6/07, James

RE: onSeessionEnd not working?

2007-07-06 Thread James Smith
I haven't used this, but one minute is too short for real world applications. So you might need to think about that, and maybe look into I am aware of this but for testing it is just fine, thanks for your concern though. -- Jay

RE: Mail error

2007-07-02 Thread James Smith
Ok, just found someone else with the same problem who traced it to Cumulative Hot Fix 2 saying it went away when he removed the update. How do I uninstall the cumulative Hot Fix? -- Jay -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: 28 June 2007 11:16 To: CF-Talk

RE: Mail error

2007-07-02 Thread James Smith
Does just deleting the jar file remove the update? -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: 02 July 2007 10:16 To: CF-Talk Subject: Re: Mail error I would assume you remove it from the directory you placed it. On 7/2/07, James Smith [EMAIL PROTECTED] wrote

RE: Dreamweaver and Vista

2007-07-02 Thread James Smith
Even MS applications like office 2000 have to be hacked to work on it. What on earth are you doing running the latest cutting edge OS and then installing 7 year old, 4 version out of date apps on it for! No wonder you think it sucks, I surprised your 486 has enough hard drive space for vista in

RE: Mail error

2007-07-02 Thread James Smith
PROTECTED] wrote: Not 100% sure, but I thin if you stop CF delete the file and restart it it is removed. I am sure (not 100%) that I saw this on the adobe website somewhere. On 7/2/07, James Smith [EMAIL PROTECTED] wrote: Does just deleting the jar file remove the update? -Original

RE: OT - Gap when making element invisible

2007-07-02 Thread James Smith
Put the br / tags inside the span? -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 02 July 2007 14:39 To: CF-Talk Subject: OT - Gap when making element invisible I have three spans: span id=span_11/spanbr / span id=span_22/spanbr / span id=span_33/span Which

Mail error

2007-06-28 Thread James Smith
I have an error I have not seen before that has recently started cropping up (since Sunday). After the server has been running for a couple of days attempts to send mail will throw the following error... An exception occurred when setting up mail server parameters. This exception was caused by:

ColdFusion server playing up

2007-06-22 Thread James Smith
Our server is playing silly buggers. It will randomly return jrun errors to some customers and not others, i can be on the phone with a customer saying the site is returning a jrun error while at the same time be browsing the site with no problem. I have never had a server do anything but work

RE: Conditional SQL

2007-06-14 Thread James Smith
I don't think that is a very good solution. Not only can this not use any indexes, it will also not match Friends Season 7 - Complete Series because the order of the words doesn't match. I was originally breaking the string and doing several 'and's. I do need to look into Full Text Indexing

RE: Conditional SQL

2007-06-13 Thread James Smith
AND ProductGroupID = CASE WHEN @productgroupid 0 THEN @productgroupid ELSE ProductGroupID END This is the simplest to read but has a drawback, it the stored ProductGroupID is null then the statement becomes AND ProductGroupID = ProductGroupID and for some reason NULL does not equal NULL so the

RE: Conditional SQL

2007-06-13 Thread James Smith
This seems like a really complicated way of saying AND ((ProductGroupID = @productgroupid) OR (@productgroupid = 0)). Am I missing something? Works perfectly... Simplest solutions are always the best, cheers. -- Jay ~| CF

RE: Conditional SQL

2007-06-13 Thread James Smith
As a last resort this procedure does the following... SET @searchTerm = '%' + REPLACE(@searchTerm,' ','%') + '%'; .. .. .. AND (Title LIKE @searchTerm OR ArtistName LIKE @searchTerm) So that is someone searches for 'friends series 7' it is first turned into '%friends%series%7%' which will

Odd session behavior

2007-06-12 Thread James Smith
Our production site is having some issues. We are getting some feedback that sessions are going AWOL. Some people are unable to add products to their cart, some can but they quickly vanish leaving them with empty carts after 30-60 seconds. Everyone here has tried and our carts last for weeks with

RE: Large CSV File

2007-06-12 Thread James Smith
What's going to make it interesting is that the file is named according to date, so it will have a different name each time they ftp it over. I Shouldn't be a problem, just have them ftp it to an empty directory then use a cfdirectory to get the name of the only file in the directory, do your

Conditional SQL

2007-06-12 Thread James Smith
I currently have a (very complex) query in the format... SELECT Title, ProductID FROM aTable WHERE Stock 0 cfif len(trim(queryParams.productgroupid)) GT 0 AND ProductGroupID = #val(productgroupid)# /cfif I wish to move this query into MSSQL server for performance reasons, how do I go

Re: Conditional SQL

2007-06-12 Thread James Smith
the query is actually very complex involving several loops and a few conditional clauses and I am hoping that by sticking it all into a stored procedure it will be precompiled by MSSQL and therefore more efficient. On 12/06/07, Jochem van Dieten [EMAIL PROTECTED] wrote: James Smith wrote

Short rant

2007-06-12 Thread James Smith
Is it just me or is SQL Server Management Studio Express crap? ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV

Server Cluster

2007-06-11 Thread James Smith
I am thinking of setting up a virtual cluster to run our website for reliability reasons. Does anyone have any good documentation (preferably in a PDF or other offline readable format) in the form of a beginners guide to CF clusters? Also, what is the licencing requirement for this, I am aware I

Re: Server Cluster

2007-06-11 Thread James Smith
so would you recomend one server with multiple jrun instances or multiple virtual servers with one on each? On 11/06/07, Brad Wood [EMAIL PROTECTED] wrote: To answer one of your many questions. You will need CF Enterprise. Once you have obtained the appropriate license for each physical

Re: Server Cluster

2007-06-11 Thread James Smith
Actually, you can't just use the same copy of Windows Server in multiple virtual machines. Microsoft has a VM licensing calendar here: http://www.microsoft.com/windowsserver2003/howtobuy/licensing/calculator.msp x Good catch, I would have missed that. As for CF, though, it's licensed per

RE: Force a page refresh

2007-04-17 Thread James Smith
You could have the redirect back to page 1 add a url parameter (index.cfm?refresh=true) and then have page 1 do a cfif to check for this header and if it exists add a meta refresh into the headers with a time value of 0, that should force the browser to do a refresh immediately. -- Jay

SSL Errors

2007-03-09 Thread James Smith
I have a process that connects to Amazon to download some reports, unfortunately they have allowed their ssl certificate to expire. Is there any way to tell cfhttp to ignore the expired certificate and connect anyway? -- Jay

cfinput validating email addresses

2007-03-09 Thread James Smith
I notice that cfinput now has the option to validate email addresses. How reliable is this, am I going to get any false results? Will it error on most invalid addresses? -- Jay ~| ColdFusion MX7 and Flex 2 Build sales

CF Report Builder

2007-03-08 Thread James Smith
Has anyone got report builder to install on Vista? I have tried more than once now and on all occasions it gets through to the Installing stage and then just stops requiring Task Manager to end it as javaw.exe seems to be having problems. I do have an XP install running in Virtual PC 2007 but I

RE: CF Report Builder

2007-03-08 Thread James Smith
, business, ultimate? I would recommend running the install as Administrator and in XP Compatibility mode, you can do this by right clicking the install exe and choosing properties, and then the 'compatibility' tab. Hope that helps, Rob -Original Message- From: James Smith [mailto:[EMAIL

RE: CF Report Builder

2007-03-08 Thread James Smith
While on the subject of report builder, how can you do conditional queries? For example on a cfm template I could use the following... cfquery SELECT * FROM aTable cfif isDefined('url.someVar') WHERE someID = #url.somevar# /cfif ORDER BY someID /cfquery However this is not possible in report

Conditions on a sub-query collumn in MSSQL

2007-02-22 Thread James Smith
to the collumn SecondCollumn. I can use... WHERE FirstColumn = SomeValue Just fine, but trying to use WHERE SecondCollumn = SomeValue Return the error Invalid column name 'SecondCollumn'. Does anyone know why and more importantly how to get arround this? -- James Smith - IT Director uWish Ltd

IIS SMTP Service Help

2007-02-09 Thread James Smith
I am sending mail from CF to the IIS SMTP service but it is all getting stuck in the IIS Queue folder, does anyone have any idea why the server may not be sending it? -- James Smith - IT Director uWish Ltd - http://www.uWish.co.uk

Webcharts

2007-02-06 Thread James Smith
2,3,4 5 it would display 14 at the top of the column? -- James Smith - IT Director uWish Ltd - http://www.uWish.co.uk ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs

MSSQL Replication

2007-01-24 Thread James Smith
have to give it a nudge? -- James Smith - IT Director uWish Ltd - http://www.uWish.co.uk ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk

RE: SQL Server, querying between two DBs

2007-01-24 Thread James Smith
will fail. It is also worth noting that this can be rather unpredictable in speed sometimes returning results lightning fast and sometimes crawling so it may be worth setting up replication to copy one of the databases across to the other server and perform your queries against that. -- James Smith

RE: Using CF to do DNS and MX lookups?

2007-01-24 Thread James Smith
/intrafoundation/products.php?id=2 Both excellent products. -- James Smith - IT Director uWish Ltd - http://www.uWish.co.uk ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform

RE: SOT: Non Local MSSQL Server replication

2007-01-24 Thread James Smith
Add it to your hosts and/or lmhosts file. Finally solved it using the Client Network Utility. -- James Smith - IT Director uWish Ltd - http://www.uWish.co.uk ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7

RE: MSSQL Replication

2007-01-24 Thread James Smith
You need two spare PC's, or one of the many free virtualisation products :-) Why 2? -- James Smith - IT Director uWish Ltd - http://www.uWish.co.uk ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration

SOT: Non Local MSSQL Server replication

2007-01-22 Thread James Smith
to help me out? -- James Smith - IT Director uWish Ltd - http://www.uWish.co.uk ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk

RE: Richest ColdFusion E-Commerce Site

2007-01-05 Thread James Smith
co-lo in the next couple of weeks. -- James Smith - IT Director uWish Ltd - http://www.uWish.co.uk -Original Message- From: Clark Valberg [mailto:[EMAIL PROTECTED] Sent: 04 January 2007 17:44 To: CF-Talk Subject: Richest ColdFusion E-Commerce Site In preparation for an upcoming

RE: Interesting Date Problem

2007-01-05 Thread James Smith
As it is a birth date you know it must be in the past, you could therefore do a datediff() comparing the retuned date and the current date and if the returned date is in the future subtract 100 years with a dateadd(). -- James Smith - IT Director uWish Ltd - http://www.uWish.co.uk

  1   2   3   4   5   >