RE: SQL regex select

2003-09-24 Thread Jason Lees (National Express)
Yes, in MSSQL Select * from myTable where myColumn like '[a-z]iger' so you can build up regular expresions like that, Jason Lees Development Team Leader National Express. -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED] Sent: 24 September 2003

RE: re cfquery INSERT into SQL database

2003-09-18 Thread Jason Lees (National Express)
You dont say what DB to use, but with MSSQL I suppose you could have a look up of invalid entries in another SQL table so that your query reads cfquery name=update DATASOURCE=database INSERT INTO strfields (

RE: [OT] ShittyCode.Com (Launched new site last night, feedback p lease!)

2003-09-11 Thread Jason Lees (National Express)
Just remember - one mans cr*p is anothers gold I have to agree with the comments made by Micheal and Calvin. As for some of the examples, they are not so much sh*t code, more like lack of knowledge, besides we've all dont things like cfif myVar != 0 espcially when switching between several

RE: Anyone going to MAX in November?

2003-09-09 Thread Jason Lees (National Express)
anyone have any details on this please, As I'd be interested to go. Jason Lees Development Team Leader National Express. -Original Message- From: Cathy Taylor [mailto:[EMAIL PROTECTED] Sent: 09 September 2003 15:09 To: CF-Talk Subject: Anyone going to MAX in November? I'm probably

RE: sql question

2003-08-19 Thread Jason Lees (National Express)
I think this should work, select Id,count(Id) from mytable group by Id having count(id)1 It will also show you how many of each Id's you have, you can naturally add a where clause if you want. Jason Lees Development Team Leader National Express. -Original

RE: Auto generate form fields problem...

2003-07-31 Thread Jason Lees (National Express)
I believe this may work, as I do somethink simular with parsing through dynamic Form variables. tdinput type=text name=call_letters_#i# value=#evaluate(call_letters_ i)# size=15/td Jason Lees Development Team Leader National Express. -Original Message- From: Bruce H. Beinert

CFMX .Net Remoting

2003-07-29 Thread Jason Lees (National Express)
All, Has anyone used .Net remoting with CFMX, and is it possible? If you have any experience can you pass on any helpfull tips for accessing and creating the objects TIA Jason Lees Development Team Leader National Express.

RE: numbers too big

2003-06-13 Thread Jason Lees (National Express)
Why 30 digits?, I'm not aware of any numbers of greater than 20 digits, even with the International diaing code. Jason Lees Development Team Leader National Express. -Original Message- From: Michael Tangorre [mailto:[EMAIL PROTECTED] Sent: 13 June 2003 15:25 To: CF-Talk Subject: numbers

RE: numbers too big

2003-06-13 Thread Jason Lees (National Express)
: Michael Tangorre [mailto:[EMAIL PROTECTED] Sent: 13 June 2003 15:57 To: CF-Talk Subject: Re: numbers too big Can you confirm this? I would need hard proof. I appreciate the insight however. Mike - Original Message - From: Jason Lees (National Express) [EMAIL PROTECTED] To: CF-Talk [EMAIL

RE: MSDE on Office XP CD - where is Enterprise Manager?

2003-03-18 Thread Jason Lees (National Express)
This is the Short cut I use to start EM C:\WINNT\SYSTEM32\MMC.EXE /s C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC Jason Lees Development Team Leader National Express Systems. -Original Message- From: Nick de Voil [mailto:[EMAIL PROTECTED]

RE: MSDE on Office XP CD - where is Enterprise Manager?

2003-03-18 Thread Jason Lees (National Express)
I didnt get it from anywhere, It was part of the installation. What type of install did you do? From what I can remember theres three option, Client Tools only, DB Client Tools, or DB Only. If you didnt install the tools option that might be the reason. Jason Lees Development Team Leader

RE: TSQL Script to replicate a db?

2003-03-18 Thread Jason Lees (National Express)
You could use the Scripting wizard in the Enterprise manager. To do this Select the DB right click, and select Script DB, this gives you the necessary wizard to get everything, SP's, tables, Indexes etc. Jason Lees Development Team Leader National Express Systems. -Original Message-

RE: Using createUUID()

2003-03-17 Thread Jason Lees (National Express)
The point of a UUID is not to use the first four characters, but to use the whole ID Jason Lees Development Team Leader National Express Systems. -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:36 To: CF-Talk Subject: RE: Using

RE: Using createUUID()

2003-03-17 Thread Jason Lees (National Express)
Heres a URL on how the UUID is defined http://www.dsps.net/uuid.html (the Colour coding leaves something to be desired but...) Just glancing at the document suggests that this will be a unique number, as it uses the Mac address of the PC to generate it. there are

RE: JS problem

2003-03-06 Thread Jason Lees (National Express)
Can't you just use if ((isNan(myField.value)) || myField.Value==0){ window.alert(- The Quantity you entered is invalid); myField.Focus(); return false; } else return true; Jason Lees Development Team Leader National Express Coaches Ltd. -Original

CFMX 100% utilization

2003-03-05 Thread Jason Lees (National Express)
All, We've just moved a development website over to the production server. The problem is that after about 2 hours, the production server just went keeled over with 100% CPU. This didnt happen on the development server The production server win 2K, twin Xeon processor, with hyper threading.

RE: CFMX 100% utilization

2003-03-05 Thread Jason Lees (National Express)
: 05 March 2003 10:24 To: CF-Talk Subject: Re: CFMX 100% utilization On Wednesday, Mar 5, 2003, at 02:02 US/Pacific, Jason Lees (National Express) wrote: We've just moved a development website over to the production server. The problem is that after about 2 hours, the production server just

CFMX behaving Strangely

2003-02-28 Thread Jason Lees (National Express)
A couple of days ago I got this error (unable to load library null). It's when we try to do the 1 second waits when we are waiting for a Smartnet reply - we call a C++ cfx library functon. I had to resurrect cfadmin support on webserver4 (which had been lost for no known reason). I reset

RE: Strange characters after MX upgrade

2003-02-28 Thread Jason Lees (National Express)
There are several prbolems with CFMX and DB's, the simplest way is for you to check the following URL for a list of Known Issues, http://www.macromedia.com/support/coldfusion/releasenotes/mx/releasenotes_mx _updater.html#newissues Jason Lees Development Team Leader National Express Coaches

RE: Strange characters after MX upgrade

2003-02-28 Thread Jason Lees (National Express)
Server-Specific Issues. But, doesn't this mean it's supposed to be fixed in updater 2? Phillip -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 9:35 AM To: CF-Talk Subject: RE: Strange characters after MX upgrade

RE: CF - PHP comparisons?

2003-02-14 Thread Jason Lees (National Express)
Where can I find out more about Bluedragon? Jason Lees Development Team Leader National Express Coaches Ltd. -Original Message- From: Vince Bonfanti [mailto:[EMAIL PROTECTED]] Sent: 14 February 2003 14:20 To: CF-Talk Subject: RE: CF - PHP comparisons? Hi Mike, I tend to agree with

RE: BlueDragon for .NET (was: CF - PHP comparisons?)

2003-02-14 Thread Jason Lees (National Express)
I was thinking the same thing. It'll save having .Net Webservices etc, I also hope it might Open up full COM+ transactions etc. Jason Lees Development Team Leader National Express Coaches Ltd. -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED]] Sent: 14 February 2003

RE: Proper SQL statements

2003-02-06 Thread Jason Lees (National Express)
Use a strored procedure to do both jobs, Jason Lees Development Team Leader National Express Coaches Ltd. -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: 06 February 2003 15:23 To: CF-Talk Subject: Proper SQL statements Is there a better more efficient way of

RE: CFMX .NET

2003-02-05 Thread Jason Lees (National Express)
I have them both runing on the same PC, although its my main development PC. so I dont know how it would react on a Win2k Server etc. And I've not seen any so far. Jason Lees Development Team Leader National Express Coaches Ltd. -Original Message- From: Adrocknaphobia Jones

RE: CF Logins and Users Logged In

2003-02-04 Thread Jason Lees (National Express)
Its fairly straight forward, the problem is when they dont log out cleanly, The simplist way is to have another column in your user table called Logged_In and set it to 1 when logged on, and 0 on a clean logout To find the count simply run the following script. Select count(Logged_in)

RE: CF Logins and Users Logged In

2003-02-04 Thread Jason Lees (National Express)
To update the on login DB I think the SQL is update usersetup set logged_in=1 where Username = '#Session.Username#' and on logout update usersetup set logged_in=0 where Username = '#Session.Username#' This assumes that you dont have users

RE: Webservices in CFMX

2003-01-30 Thread Jason Lees (National Express)
A Corfield [mailto:[EMAIL PROTECTED]] Sent: 29 January 2003 17:07 To: CF-Talk Subject: Re: Webservices in CFMX On Wednesday, Jan 29, 2003, at 01:36 US/Pacific, Jason Lees (National Express) wrote: I've just been doing some load testing connecting from CFMX to an Inhouse webservice application

Webservices in CFMX

2003-01-29 Thread Jason Lees (National Express)
All, I've just been doing some load testing connecting from CFMX to an Inhouse webservice application. Everything is running ok until about 300 transactions have been processed, CFMX then throws the following error Object reference not set to an instance of an object. at

RE: Stealing content?

2003-01-20 Thread Jason Lees (National Express)
Its called scrapping or syndication, depending on the books you read. to accomplish syndication, you use the cfhttp tag, However this is technically illegal without the Website owners permission as they own legal copyright on the material. Jason Lees Development Team Leader National Express

RE: Book reviews

2003-01-20 Thread Jason Lees (National Express)
check out the Ben forta books published by Macromedia press (ISDN nos - 0-321-12516-9, and 0-321-12710-2], they're both quite good, Jason Lees Development Team Leader National Express Coaches Ltd. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 20 January

RE: Loop Errors

2003-01-06 Thread Jason Lees (National Express)
Well for a start you dont neet to nest the cfoutput's Jason Lees Development Team Leader National Express Coaches Ltd. -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: 06 January 2003 15:50 To: CF-Talk Subject: Loop Errors Does anybody have any ideas on why I am

RE: Loop Errors

2003-01-06 Thread Jason Lees (National Express)
Code /select/td /tr /table /body /html - Original Message - From: Jason Lees (National Express) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 06, 2003 3:55 PM Subject: RE: Loop Errors Well for a start you dont neet to nest the cfoutput's Jason Lees

RE: MS CF?

2002-12-23 Thread Jason Lees (National Express)
If it happens it happens, being a developer I'll use whatever tool's I'm told to use either by Clients or the company I work for at the time. As for if MS buys MM personally I can see it happening, based on the aqusitions its made over the years, and also the fact that the only tools MS have for

RE: Page Breaks for Printing

2002-12-19 Thread Jason Lees (National Express)
We use page breaks, and its a simple tag extention of the classic paragraph Tag p STYLE=page-break-before: always The Complication is deciding on the location to place the Tag. Jason Lees Development Team Leader National Express Coaches Ltd. -Original Message- From: Chad

RE: Is Coldfusion REALLY multi threaded?

2002-12-05 Thread Jason Lees (National Express)
It might not Be CF thats causing the problem, its most likley the DB thats escalating the Lock to a full table lock and thus preventing other users from running the queries until the table is free. Also try moving the DB onto another server, as we had a simular problem, with ingres and moving the

Passing objects from CFMX to Webservices

2002-12-04 Thread Jason Lees (National Express)
All, I have two webservices both written in VB.Net, one generates a Journey Object, which I can parse quite easily in CFMX, however I need to be able to pass part of the object back into another webservice after a selection is made, the receiving webservice is expecting the same object type I'm

RE: Checking SESSION variable

2002-12-02 Thread Jason Lees (National Express)
Use the find function cfif find(session.showme,session.strfilename,0) gte 0 cfelse . /cfif but from the example that could be ambigious, as there could be more than one mywork2 in different sub folders. Jason Lees Systems Developer National Express Coaches Ltd.

Webservices that return Collections

2002-11-29 Thread Jason Lees (National Express)
All, I have written a Webservice in .Net that produces an Object Collection, the basic structure is Journeys(Index).JourneyDetail.LegCount .Duration .Legs(Index).LegData I would like to know how I can loop

RE: Webservices that return Collections

2002-11-29 Thread Jason Lees (National Express)
][Duration][Legs][1].LegDate # /cfoutput also, try and run an #isStruct(YOURSERVICE)# to determine if its a valid structure... It really shouldnt be difficult to get at the values if it is! Neil -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: 29

RE: Alternating Row Colours Number Listing in CFOutput

2002-11-27 Thread Jason Lees (National Express)
Cant you just use the CurrentRow variable, for the record number display? Jason Lees Systems Developer National Express Coaches Ltd. -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED]] Sent: 27 November 2002 16:39 To: CF-Talk Subject: Alternating Row Colours Number Listing

RE: Checking a float

2002-11-18 Thread Jason Lees (National Express)
As CF is a loosly typed language you could simply do cfif find(.0,#bathrooms#) eq 0 --whole bathrooms cfelse --partial bathrooms /cfif Question is though how do you have .5 of a bathroom, isnt this like half a hole? Jason Lees Systems Developer National Express Coaches Ltd.

RE: calling a dll from an sql stored proc

2002-11-15 Thread Jason Lees (National Express)
Hi John, I've just spoken with our MS SQL Guru and hes not aware of any way of accesing a VB created Dll through MS SQL. The only way he intimated it could be done was by writing an xp_ wrapper in c++ for the VB library. Jason Lees Systems Developer National Express Coaches Ltd.

RE: CFX tags

2002-11-14 Thread Jason Lees (National Express)
Mark, To the best of my knowledge you need to define the CFX tag on the local server, and have a local copy or a mapped drive to the location of the CFX tags on the other server. Jason Lees Systems Developer National Express Coaches Ltd. -Original Message- From: Mark Leder

RE: CFOBJECT and conversion from ASP

2002-11-12 Thread Jason Lees (National Express)
Joshua, I think this will work, cfobject type=com action=Connect class=NextPage.NPOptions name=anObject cfset myMethod=anObject.Item(title) cfset myMethod=Title Or With CFScript cfscript anObject=CreateObject(Com,NextPage.NPOptions)' myMethod=anObject.Item(title);

RE: CFOBJECT and conversion from ASP

2002-11-12 Thread Jason Lees (National Express)
Coms not dead yet as you say theres too many older applications using it, but the way forward is webservices, which is basically a newer version of Com without the all the hassles. With reagrd the problem try myMethod = myObject.item(title); myMethod = title; Jason Lees Systems Developer

RE: Studio MX

2002-11-08 Thread Jason Lees (National Express)
My understanding is that there is no longer a CF Studio, its now fully integrated with Dreamweaver MX. Jason Lees Systems Developer National Express Coaches Ltd. -Original Message- From: Owens, Howard [mailto:HOwens;insidevc.com] Sent: 07 November 2002 20:49 To: CF-Talk Subject: Studio

Using .Net Object with CF Server MX

2002-11-07 Thread Jason Lees (National Express)
All, Has anybody succesfully managed to interface Microsoft .NET DLL's with CF MX? If so can you provide me with some pointers please. Many thanks in Advance. Jason Lees Systems Developer National Express Coaches Ltd. ~|

RE: is this list dead?

2001-07-02 Thread Jason Lees (National Express)
This is the first one i've had in over a week!!! I thought the list was Dead!! Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Erika L. Walker [mailto:[EMAIL PROTECTED]] Sent: 02 July 2001 16:53 To: CF-Talk Subject: RE: is this list dead? I'm getting

RE: ignore an error??

2001-06-07 Thread Jason Lees (National Express)
you could use the CFParam to set it to an empty string. Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: 07 June 2001 16:10 To: CF-Talk Subject: ignore an error?? I recieve the following error: An error occurred

RE: CF 5 Eval

2001-06-06 Thread Jason Lees (National Express)
I'm currently evaluating it, and this sounds like it could be extremly usefull, please forward any information. Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Bryan LaPlante [mailto:[EMAIL PROTECTED]] Sent: 06 June 2001 07:44 To: CF-Talk Subject: CF 5

RE: CF 5 Eval

2001-06-06 Thread Jason Lees (National Express)
Go to http://www.macromedia.com/go/cfpromo/ As far as I can understand its available now. Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: 06 June 2001 11:06 To: CF-Talk Subject: RE: CF 5 Eval When

RE: profanity checker(again)

2001-06-06 Thread Jason Lees (National Express)
you could check to see if there is a valid caracter before and/or after the profanity, it Saturday would find turd then check back and find that there is no space or full stop, and then check forward for the same. Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message

RE: Challenging dillemma (double values?)

2001-06-06 Thread Jason Lees (National Express)
you can youse a hidden field in the page and pass that into the Javascript function and just add the part item into it, with a comma so its a commer delmited list, just remember to remove the last Commer from the List. Jason Lees National Express Email : [EMAIL PROTECTED] -Original

RE: Preserve ampersand tagged data (SGML)

2001-06-06 Thread Jason Lees (National Express)
Use the reverse of UrlDecode(encodedUrlString) Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 06 June 2001 15:05 To: CF-Talk Subject: RE: Preserve ampersand tagged data (SGML) Thanks Another

CF5.0 Tag CFFlush

2001-06-05 Thread Jason Lees (National Express)
. Thanks Jason Lees National Express Email : [EMAIL PROTECTED] ### This document is intended for, and should only be read by, those persons to whom it is addressed. Its contents are confidential and if you have received this message in error

RE: CF5.0 Tag CFFlush

2001-06-05 Thread Jason Lees (National Express)
Thanks, I've checked the code for that and there is nothing except standard CFML HTML tags, ie no CFCookie, cflocation, or any other such tags. Just to check I used this on a page that is a 90% CFscript block. and still the same. Jason Lees National Express Email : [EMAIL PROTECTED

RE: CF5.0 Tag CFFlush

2001-06-05 Thread Jason Lees (National Express)
Thanks, Just tried that, changed from a cookie to the Registry and it appears to be working a bit better. Whats the best way to store client vars, Registry or DB Table? Thanks. Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: David E. Crawford

RE: Use interactive CF debugger!!! : was VeRy tricky evaluate()

2001-06-04 Thread Jason Lees (National Express)
url.grid [ i ])# /cfloop Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: 04 June 2001 14:42 To: CF-Talk Subject: RE: Use interactive CF debugger!!! : was VeRy tricky evaluate() After many many attempts i

RE: What's with this?

2001-06-01 Thread Jason Lees (National Express)
Doesn't June only have 30 days! Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: 01 June 2001 14:11 To: CF-Talk Subject: What's with this? I have this bit of code... cfset date1=dateformat

RE: How do I parse strings?

2001-05-30 Thread Jason Lees (National Express)
pos=pos+1; MsgOperator=Mid(MsgOperator,pos-1,len(MsgOperator)); } iLine=iLine-1; /cfscript HTH Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Bill Poff [mailto:[EMAIL PROTECTED]] Sent: 30 May 2001 15

RE: whitespace

2001-05-26 Thread Jason Lees (National Express)
as much as possible into a CFScript tag. HTH. Jason Lees National Express Systems Department. E-Mail : [EMAIL PROTECTED] -Original Message- From: nagesh [mailto:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 8:09 PM To: CF-Talk Subject: whitespace hi all, i really fed up with the white

RE: CFGRID with list box?

2001-05-25 Thread Jason Lees (National Express)
Latest JRE Environment (1.3.1) is about 5.5MB, It is ideal for Intranets, but a problemif your Network Admin has a god complex where hes locked all machines to Normal Users Installing software, even off the intranet!!! Jason Lees National Express Email : [EMAIL PROTECTED] -Original

RE: CFGRID with list box?

2001-05-25 Thread Jason Lees (National Express)
development suite, so chances are that it wont. Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Angél Stewart [mailto:[EMAIL PROTECTED]] Sent: 25 May 2001 14:13 To: CF-Talk Subject: RE: CFGRID with list box? Arrggh..what are the chances that the new JRE

RE: Can I retrieve the peripherals attached to a 'puter?

2001-05-25 Thread Jason Lees (National Express)
If you goto the M$ page http://windowsupdate.microsoft.com/ and click on the products Update, and it appears that this goes and searches the registry. So It is Possible, Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Claremont, Timothy S [mailto

RE: SLightly OT - a time formula

2001-05-22 Thread Jason Lees (National Express)
Try this cfset Hours=int(totalMins/60) cfset Minutes=totalMins Mod 60 Therefore with 400 Mins you get Hours=int(400/60)=6 Mins=400 Mod 6= 40 Back Calc = (6*60)+40=360+40=400 Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Will Swain [mailto

Configuring CF45 for Java

2001-05-18 Thread Jason Lees (National Express)
to run JVM and doesnt have the necessary classes on the system. Is this true? and How do you configure the Java settings in CF4.5 so that you can utilise classes? Jason Lees National Express Email : [EMAIL PROTECTED] ### This document is intended

RE: OpenIngres Database

2001-05-16 Thread Jason Lees (National Express)
I've Just spoken to our resident Ingres expert, and his opinion is that you need to use a DB procedure to do it. Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 15 May 2001 18:37 To: CF-Talk Subject

RE: query error

2001-05-14 Thread Jason Lees (National Express)
Do You realy need the ; at the end of the Query? Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: 14 May 2001 11:36 To: CF-Talk Subject: query error Hello, Must be having a brain spasm todayI am getting

Way OT:Java Mailing Lists

2001-05-14 Thread Jason Lees (National Express)
Hi All, Can anybody recommend a good JAVA Mailing list like CF-Talk. TIA Jason Lees National Express Email : [EMAIL PROTECTED] ### This document is intended for, and should only be read by, those persons to whom it is addressed. Its contents

RE: Changing Default Site error page

2001-05-03 Thread Jason Lees (National Express)
sorry, this is what I meant, I must start being more precise.. Any Ideas? Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Bob Silverberg [mailto:[EMAIL PROTECTED]] Sent: 02 May 2001 19:59 To: CF-Talk Subject: RE: Changing Default Site error page He

Changing Default Site error page

2001-05-02 Thread Jason Lees (National Express)
work. Does anyone have any ideas?? Jason Lees National Express Systems Department. E-Mail : [EMAIL PROTECTED] ### This document is intended for, and should only be read by, those persons to whom it is addressed. Its contents are confidential

RE: Update in CFquery is failing, somone code check this ?

2001-05-01 Thread Jason Lees (National Express)
there for no record therefore an Error. QED Jason Lees National Express Systems Department. E-Mail : [EMAIL PROTECTED] -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 11:43 AM To: CF-Talk Subject: Update in CFquery is failing, somone code check

RE: Update in CFquery is failing, somone code check this ?

2001-05-01 Thread Jason Lees (National Express)
Cant see anything wrong with the syntax, have you tried removing the spaces before and after all the ='s in the query string,shouldn't make a difference but worth trying. is the DSN correct? Jason Lees National Express Systems Department. E-Mail : [EMAIL PROTECTED] -Original Message

RE: ASCII for Tab

2001-04-06 Thread Jason Lees (National Express)
I belive its ASCII '9' Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: 06 April 2001 13:01 To: CF-Talk Subject: ASCII for Tab 'Mornin, Can anybody tell me what the ASCII for 'Tab' is so I can remove them

RE: ASCII for Tab

2001-04-06 Thread Jason Lees (National Express)
I think it would be better to chr(9) in he replace statement, Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: 06 April 2001 13:11 To: CF-Talk Subject: Re: ASCII for Tab So it would be #009; in a replace

RE: CF Time off by an hour?

2001-04-06 Thread Jason Lees (National Express)
Same thing happens on our system running CF server 4.5.1 and windows NT4 SP 4 Jason Lees National Express Systems Department. E-Mail : [EMAIL PROTECTED] -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 2:26 PM To: CF-Talk Subject: RE

RE: Oddness with cfqueryparam

2001-04-05 Thread Jason Lees (National Express)
Personally I've never used the CFQueryparam tag, but Surely the query should read, cfquery name="contacts" datasource="Contacts" SELECT ID, FirstName, LastName, JobTitle,BusinessPhone FROM exoduscontacts WHERE LastName like '%#form.what#%' ORDER BY LastName ASC /cfquery Jason Lees

RE: Oddness with cfqueryparam

2001-04-05 Thread Jason Lees (National Express)
Fair comment, Jason Lees National Express Systems Department. E-Mail : [EMAIL PROTECTED] -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 2:23 PM To: CF-Talk Subject: RE: Oddness with cfqueryparam Personally I've never used

RE: Please Help

2001-04-04 Thread Jason Lees (National Express)
Its also Ideal way to learn Java Script. At least thats how I taught myself Java script. Another benefit is that I also managed to cut the output page sizes down by as much as 50%!!! Remember why reinvent the wheel. -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent:

RE: date range search

2001-04-04 Thread Jason Lees (National Express)
Give this one a try, CFSET startdate = "#Createdate(Year,Month,Day)#" CFSET enddate = "#Createdate(Year2,Month2,Day2)#" cfset startdate = #dateformat(startdate,'mm/dd/')# cfset enddate = #dateformat(enddate,'mm/dd/')# cfquery query="myQuery" Datasource="MyDataSource" Select * From My

RE: Displaying yes/no field dynamically in checkboxes?

2001-04-03 Thread Jason Lees (National Express)
try something like this. input type="checkbox" name="cabinPets" value="#cabinPets#" cfif #ucase(Cabinpets)# eq "YES"Checked/cfif Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: P@tty Ayers [mailto:[EMA

Looping through a Query in CFSCRIPT

2001-04-03 Thread Jason Lees (National Express)
Hi all, Is it possible to loop through the results of a CFQuery structure? and Has anybody got an example of how its done TIA. Jason Lees National Express Email : [EMAIL PROTECTED] ### This document is intended for, and should only be read

RE: Looping through a Query in CFSCRIPT

2001-04-03 Thread Jason Lees (National Express)
Thanks for all the help, I've tried the solution and it works, I forgot that effectivly the query is a structured array. I need a break/holiday or caffine injection. Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Hayes, David [mailto:[EMAIL PROTECTED

RE: Form Variables not being passed on selected machines

2001-03-28 Thread Jason Lees (National Express)
Have you Checked that the form method is set to post? Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 28 March 2001 11:57 To: CF-Talk Subject: Form Variables not being passed on selected machines All

OT:Converting CFML to WML

2001-03-27 Thread Jason Lees (National Express)
Hi All, Is it an easy job to convert CFML pages to WML? Jason Lees National Express Email : [EMAIL PROTECTED] ### This document is intended for, and should only be read by, those persons to whom it is addressed. Its contents are confidential

RE: CF Status in UK

2001-03-26 Thread Jason Lees (National Express)
and quicker, I would suggest Computer Futures (www.computerfutures.co.uk), mainly becuase they have offices nationwide. I had an interview with Novasoft myself, about a year ago, I wasn't impressed with what they where offering. Good Luck, Jason Lees National Express Email : [EMAIL PROTECTED

RE: Is this possible?

2001-03-26 Thread Jason Lees (National Express)
ag. In theory it should work, give it a try and let me know. Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: David Shadovitz [mailto:[EMAIL PROTECTED]] Sent: 26 March 2001 16:00 To: CF-Talk Subject: RE: Is this possible? But Terri wants to compare the cli

RE: Is this possible?

2001-03-26 Thread Jason Lees (National Express)
name="X" value="" onblur="Check_Items(X,'#MyQuery.MyField#');" /cfoutput Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: 26 March 2001 15:34 To: CF-Talk Subject: Is this possible? He

Calling Custom Tags in CFSCRIPT

2001-03-23 Thread Jason Lees (National Express)
Hi All, In CF Version 4.5 is it possible to call a custom Tag from with in a CFScript block EG cfif x gt 1 cf_Foo In="x" out="y" /cfif cfoutputthe x^2 = #y#/cfoutput How would you convert the CF_Foo into the cfscript block? Jason Lees National Express Emai

RE: Calling Custom Tags in CFSCRIPT

2001-03-23 Thread Jason Lees (National Express)
I thought as much but just wanted to make sure I'd not missed an undocumented feature. Roll on CF5.0! Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 23 March 2001 12:51 To: CF-Talk Subject: RE: Calling

RE: Help please

2001-03-23 Thread Jason Lees (National Express)
Dont just stick to Web based tools, get to grips with conventional programming languages as well, such as VB, C++, JAVA. and others. Even if its just a matter of installing a standard edition of the software and getting to grips with the syntax and format and quirks of the language. Jason Lees

RE: HTML problem

2001-03-22 Thread Jason Lees (National Express)
Try the reverse, Ie make the image 1024x768 then use HTML to shrink to 800x600. This should solve the problem, it may be a little blured I'm not sure. Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Heidi Belal [mailto:[EMAIL PROTECTED]] Sent: 22

RE: loop in CFSCript

2001-03-22 Thread Jason Lees (National Express)
cant you use a cfscript arrayYes=Arraynew(1); for (k=0;k lte varlength;k++) arrayYes[k]=(#SomeNum[k]#/#othernum[k]#)*100; /cfscript Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Zhou, Mei Y (Mei) [mailto:[EMAIL PROTECTED]] Sent: 22 March

RE: loop in CFSCript

2001-03-22 Thread Jason Lees (National Express)
Sorry I've had my 'C++' and Java hat on recently and forgot that CF doesnt like the k++. My fault. use k=k+1 and replace 0 with 1, should work then. Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Zhou, Mei Y (Mei) [mailto:[EMAIL PROTECTED]] Sent: 22

RE: Can we do another select on a cfquery resultset?

2001-03-21 Thread Jason Lees (National Express)
as far as I'm aware this facility is Only available in CF5.0, unless you loop through the entire collection. Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: JAIME HOI [mailto:[EMAIL PROTECTED]] Sent: 21 March 2001 12:54 To: CF-Talk Subject: Can we do

RE: [RE: To ASP or not to ASP]

2001-03-21 Thread Jason Lees (National Express)
Why not take the best of both worlds and cerate templates that use CF and ASP!! Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Angél Stewart [mailto:[EMAIL PROTECTED]] Sent: 21 March 2001 15:24 To: CF-Talk Subject: RE: [RE: To ASP or not to ASP

RE: Win2k

2001-03-21 Thread Jason Lees (National Express)
So Far we've not had any problems with the CF on a Win2k server (+1Month), but the hits are quiet low. However I've seen posts from others on the lists that have noted problems though. Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Thomas Chiverton

RE: Previous date

2001-03-21 Thread Jason Lees (National Express)
use the function CreateTimeSpan Yesterday=DateFormat(Now()-CreatetimeSpan(1,0,0,0),"MM/DD/YY") Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: monika kon [mailto:[EMAIL PROTECTED]] Sent: 21 March 2001 16:03 To: CF-Talk Subject: Previous

RE: cfloop

2001-03-13 Thread Jason Lees (National Express)
llsign#" /td/tr /cfoutput Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: 13 March 2001 16:19 To: CF-Talk Subject: cfloop From a select box I am selecting a single vehicle or all vehicles and pass the p

RE: Converting Docs and Powerpoint files to html or pdf using CF?

2001-03-07 Thread Jason Lees (National Express)
You can always run them through dreamweaver before commiting them to disk (esp the word files). Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: 07 March 2001 14:37 To: CF-Talk Subject: Re: Converting Docs

  1   2   >