RE: mod function?

2001-09-27 Thread Mike Kear
Well if you leave yourself alone you wont go blind so quickly. Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Michael Vinson [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 27, 2001 1:48 PM To: CF-Talk Subject: mod function? newbie needs to know if

Re: XML-XSL-CF_SOXML

2001-09-27 Thread tom dyson
Hi Timur Our CF XML Toolkit allows you to transform an XML document using a given XSL Stylesheet (and to apply optional parameters to the transformation). It currently uses the MSXML DOM object, though there are plans afoot to create a platform-independent version using Xerces and Xalan. Other pa

RE: XML-XSL-CF_SOXML

2001-09-27 Thread DeVoil, Nick
Timur >What are other ways to transform XML and XSL into HTML using Cold Fusion and MSXML DOM object. If you're using CF5, there is a UDF at CFLib.org that does this. I haven't used it myself. http://www.cflib.org/udf.cfm?ID=147 Nick **

Re: CFGRID problems in CF5 (need workaround)

2001-09-27 Thread Paul Hastings
> There's no reason to go to all this trouble. I'm sure that there are already > plenty of Java grids with the features that you want - I know there are many > Java grids available from component companies, and many have almost the same > feature sets that the COM/ActiveX grids do. for instance?

break

2001-09-27 Thread Aidan Whitehall
Is there any good reason why CFSCRIPT requires the inclusion of a break; statement at the end of each case? It took me a while after looking at Advanced CFWACK 4 (where break; doesn't appear) and digging around the archives to find out that it's needed. And it just left me thinking... why? Aid

RE: break

2001-09-27 Thread DeVoil, Nick
Aidan It's based on 'C' syntax, which itself isn't very far removed from machine code - the switch statement is really just a glorified set of goto statements. If you don't put the break in, it drops through to the next case. But it can be useful sometimes if you want to do some processing for

RE: ODBC error code

2001-09-27 Thread Tristram Charnley
No, the query runs fine on my machine (CF5 W98 and Access) and on our development server (CF4.5.0 NT4SP5 SQL Server7) but not on our production server with CF4.5.1 Here's the query anyway: INSERT INTO DBGENERE (Country, TradeName, InternationalN

RE: mod function?

2001-09-27 Thread Peter Tilbrook
Yes it does. eg: Do this.. Do this.. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mike Kear Sent: Thursday, 27 September 2001 18:29 To: CF-Talk Subject: RE: mod function? Well if you leave yourself alone you wont go blind so quickly. Cheers,

cross post: page loading problem....processing aborted

2001-09-27 Thread William Swain
Hi gang, I have a page that pulls out a list on stories, then loops over them, setting a variable for a font colour for each one, and selecting the authors name for each one from another table. It all works, but in IE5.5 and IE6, the page seems to get stuck in a loop, and sometimes throws and er

RE: break

2001-09-27 Thread Aidan Whitehall
> It's based on 'C' syntax, which itself isn't very far removed > from machine code - the switch statement is really just a > glorified set of goto statements. > > If you don't put the break in, it drops through to the next case. > > But it can be useful sometimes if you want to do some processi

RE: bug with files ending in "Application.cfm"?

2001-09-27 Thread Aidan Whitehall
> Found a weird bug in Coldfusion to do with files ending in > "Application.cfm". I have a file called "AccountApplication.cfm" and > when called, it produces the "Invalid Request of APPLICATION.CFM or > ONREQUESTEND.CFM File" error. Yeah, I've seen this before with file names that contain the wo

RE: break

2001-09-27 Thread Andrew Scott
Hmm, I remember C as Case 'A': { ...Evaluation; } Case 'B': { ...Evaluation; } Default: { ...Evaluation; } And I remember assembly as Cmp #$01 Bne next Code Process Next: Cmp #$02 Bne Next1 Code Process Next1: Regards, Andrew Scott -Original Message- From: DeVoil, N

RE: break

2001-09-27 Thread DeVoil, Nick
> every other bit of CFML is geared towards making it a simple language I agree, but the idea of CFScript on the other hand is to be as close as possible to JavaScript - except where that was too difficult to implement. Nick *

Double back button

2001-09-27 Thread Janine Jakim
I have a page that calls a pdf file. When a user hits the back button they are returned to the action page which of course sends them back to the pdf. If they click twice quickly they are returned to the original screen. It works, but feels clumsy. Is there some way I can make it that if the br

RE: Checking for NULL

2001-09-27 Thread Irwan Kurniawan
This should done the job for you =) -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 9:48 PM To: CF-Talk Subject: Checking for NULL How do I compare a field for a NULL value ? ? Regards, Thomas Chiverton Intranet Architect 015

RE: Double back button

2001-09-27 Thread Joshua Tipton
history.back(-2) -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 27, 2001 8:08 AM To: CF-Talk Subject: Double back button I have a page that calls a pdf file. When a user hits the back button they are returned to the action page which of cours

Reclaiming results of dynamic query

2001-09-27 Thread G
I've got a unique situation thats got me a bit stuck. I've got a query that is completely dynamic, as such: SELECT #form.fieldlist# FROM #form.tablelist# WHERE #form.wherefield# #form.conditional# #form.WhereClause# The results of the query are displayed in a table, with the column headings

RE: break

2001-09-27 Thread Aidan Whitehall
> I agree, but the idea of CFScript on the other hand is to be as close > as possible to JavaScript - except where that was too difficult to > implement. Right... good point. I've just searched and seen that that's how they are done in JavaScript. Thanks again for the info. Aidan -- Aidan Wh

RE: Double back button

2001-09-27 Thread Andrew Scott
Joshua, will not work on the actual IE button! Or did I miss the addition to program these buttons? Regards, Andrew Scott -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Thursday, 27 September 2001 22:23 PM To: CF-Talk Subject: RE: Double back button history.b

RE: Reclaiming results of dynamic query

2001-09-27 Thread Andrew Scott
Lets say you have the following fields? Field1,Field2,Field3,Feild4 I would do this, default the sort on field 1:-) SELECT #form.fieldlist# FROM #form.tablelist# WHERE #form.wherefield# #form.conditional# #form.WhereClause# Order by #form.field1# Or you could just cache the query, this way

Last Record's Autonumber value.

2001-09-27 Thread Angel Stewart
Hey all, How can I tell what the Autonumber value of a record I just inserted is using Access? So I enter a User, and then I want to display that user's ID back to them. UserID is an Autonumber field, so I don't know it until after I insert. I can't search for First name or last name, because

RE: Last Record's Autonumber value.

2001-09-27 Thread Andy Ewings
upgrade to SQL Server :)sorry that's not very helpfull but as far as I know you can't easilly. You have no access to Inserted or @@IDENTITY as you do in SQL Server -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.

Possible Error in CF5, can anyone verify

2001-09-27 Thread Robert Everland
I have been using CF5 on my development server and have gotten this error in which I can find no workaround. I use cfexecute to issue a rmtcmd to an as/400. There is a program rmtcmd that sits in the winnt directory. When I try to send the command it just hangs and eventually times out, I

Re: Last Record's Autonumber value.

2001-09-27 Thread Howie Hamlin
Something like: Select Max(UserID) as NewUserID from ... Your user ID is #GetUserID.NewUserID# Of course you really should wrap a transaction around the above code and also have the db insert within the transaction as well. HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solution

RE: Last Record's Autonumber value.

2001-09-27 Thread Mark Smyth
you can use max to do it If its before you're inserting the record for the current user, just get the last id number and add 1 to it select MAX(id) as id_no from forms is that what you wanted? -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED]] Sent: 27 September 2001

Re: Last Record's Autonumber value.

2001-09-27 Thread Bruce Sorge
How about this? SELECT MAX (UserID) AS ID From Users #ID# - Original Message - From: "Angel Stewart" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, September 27, 2001 6:50 AM Subject: Last Record's Autonumber value. > Hey all, > > How can I tell w

Using VBScript from ColdFusion

2001-09-27 Thread kbutterly
Good morning, all. Excuse the very basic nature of this question, but how do I use VBScript with ColdFusion? All the documentation says that the