RE: Storing Credit Cards

2001-10-04 Thread DeVoil, Nick
Jeff > I would also be interested in knowing if anyone is aware of a third party clearing house or payment processor that can provide a very secure credit card storage service. Check out WorldPay's FuturePay service: http://www.worldpay.com/sg/products_services/product_selection/billing.shtml

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 *

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: 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: perl function for round-up

2001-09-25 Thread DeVoil, Nick
> what's the perl function to round up a decimal value? ceil() rounds up to the next integer. It's in the POSIX module. ** Information in this email is confidential and may be privileged. It is intended for the addressee only.

RE: SQL- Column datatype on an empty table

2001-09-25 Thread DeVoil, Nick
Bill >I'm needing to get a list of the datatypes and maxlength properties of the columns of an empty table Something like this: select column_name, data_type, character_maximum_length from information_schema.columns where table_name = 'whatever' Nick **

RE: MODIFY sql command

2001-09-24 Thread DeVoil, Nick
Will, Sorry, what do you mean by "it isn't - just says the format is blank"? Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, pl

RE: MODIFY sql command

2001-09-24 Thread DeVoil, Nick
Will > I need to modify a table on one of my Databases - to add 2 Yes/No fields. > The DB is Access, and the table name "Pending." alter table pending add column col1 yesno, col2 yesno; Nick ** Information in this email is co

RE: SQL question about JOIN

2001-09-19 Thread DeVoil, Nick
There is no reason to, unless you need to make sure that you will get all the relevant records from one or more of the tables regardless of whether they have corresponding records in the other tables. That's what an outer join is for. If you put a row into JOBINFO with no corresponding rows in th

RE: CFQUERYPARAM and version

2001-09-17 Thread DeVoil, Nick
Aidan, Yes, it was new in 4.5. Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete

RE: .biz domains ... what are the issues?

2001-09-10 Thread DeVoil, Nick
> .biz domains are global, so when you've got a name you've got it > worldwide, whereas .com, .co.nz, .com.au, .co.uk etc aren't. com is supposed to be global. Isn't it? Nick ** Information in this email is confidential and ma

RE: SQL SERVER Usage Question

2001-09-07 Thread DeVoil, Nick
It's a small record set. As long as the queries are designed properly and it's indexed you'll be fine with a shared SQL Server - unless you mean *really* intensive. The size of the database isn't really as significant as the number of concurrent accesses. Nick -Original Message- From: Br

RE: ColdFusion license agreement

2001-09-07 Thread DeVoil, Nick
ctioning even with an service contract and numerous calls to our allaire support guy. Thanks, GFrederic "DeVoil, Nick" wrote: > > Anything I should be aware of when installing CF Server > 5 on NT with Apache?? > > No, I have

RE: Off topic posts was (OT?) TomCat vs JRun

2001-09-05 Thread DeVoil, Nick
> It was just too complicated to set up, whereas TomCat is supposed to be a lot easier! You've got to be joking. My experience is exactly the opposite. Certainly for reasonably simple JSP's - that's as far as I've got - JRun works practically straight out of the box. It has a web-based administr

RE: ColdFusion license agreement

2001-09-05 Thread DeVoil, Nick
> Anything I should be aware of when installing CF Server 5 on NT with Apache?? No, I have that combination right here & it's fine. Nick ** Information in this email is confidential and may be privileged. It is intended for t

RE: ColdFusion license agreement

2001-09-04 Thread DeVoil, Nick
> If not, how do I get around the problem with out having to buy a copy? If you have CF Studio, you can use the single-user version that comes with that. I think that has all the tags. Unless you want Server 5, that is, in which case you have to wait for Studio 5. *

RE: help with moving from access to sql server

2001-09-04 Thread DeVoil, Nick
What I'm saying is, you don't need a GROUP BY *at all* in this query. Anyway, it worked, that's the main thing :-) Nick -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 4:18 PM To: CF-Talk Subject: RE: help with moving from access to sql

RE: help with moving from access to sql server

2001-09-04 Thread DeVoil, Nick
s. Cheers, Declan Maher Web Applications Developer Head Office 133-137 Lisburn Road Belfast Northern Ireland BT9 7AG T: +44 (0) 28 9022 3224 F: +44 (0) 28 9022 3223 E: [EMAIL PROTECTED] W: biznet-solutions.com -Original Message----- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: 04

RE: help with moving from access to sql server

2001-09-04 Thread DeVoil, Nick
Why do you need the GROUP BY clause at all? I don't see any aggregate functions (COUNT, SUM etc) Also, which column is a bit column and does it really need to be? Nick ** Information in this email is confidential and may be p

RE: Quick format question

2001-09-04 Thread DeVoil, Nick
> How is it done in the sql statement. As always with anything to do with string functions or date functions, the answer is, it depends what DBMS you're using. Nick ** Information in this email is confidential and may be pri

RE: Catching page timeouts

2001-09-03 Thread DeVoil, Nick
What if you put that code on your custom error page? -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Monday, September 03, 2001 2:39 PM To: CF-Talk Subject: RE: Catching page timeouts > COM.Allaire.ColdFusion.Request.Timeout Yeah, I have http://www.fusionauth

RE: Catching page timeouts

2001-09-03 Thread DeVoil, Nick
> Can I catch the page timeout error at all ? I haven't tried it myself but the list of Advanced Exception Types includes COM.Allaire.ColdFusion.Request.Timeout Nick ** Information in this email is confidential and may be pri

RE: CF5 Pro SN

2001-09-03 Thread DeVoil, Nick
> and me! If only they were that efficient about sending the fleeces from the Server 5 beta "Giveaway" ;-) Did *anyone* get one? Nick ** Information in this email is confidential and may be privileged. It is intended for the

RE: CF5 Pro SN

2001-08-30 Thread DeVoil, Nick
Call me sceptical, but I don't think someone called "Mr Warez" is likely to be in the business of making "honest mistakes". ** Information in this email is confidential and may be privileged. It is intended for the addressee on

RE: MS SQL 7/2k File Size

2001-08-29 Thread DeVoil, Nick
> Does anyone know of a way in SQL (as opposed to enterprise manager) to get the file size of a MS SQL database? sp_helpdb() Nick ** Information in this email is confidential and may be privileged. It is intended for the addr

RE: ms sql to ms access

2001-08-22 Thread DeVoil, Nick
, [Image] [varchar] (50) NULL , [LeftOver] [money] NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO this a part of the script L -----Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: mercoledì 22 agosto 2001 11.26 To: CF-Talk Subject: RE: ms sql to ms a

RE: db structure question

2001-08-22 Thread DeVoil, Nick
Paul, >wouldn't it be just as fast to stick the actual unique value of the look up table into the tbl_Mast_Table? Yes it would. However, I find that using a unique autonumber ID for every single table makes coding more standardised & therefore faster. Don't quite understand your second point. W

RE: Looping through lists

2001-08-22 Thread DeVoil, Nick
Chris, This isn't what you want to hear, but really your database design needs changing so that each keyword is in a separate row. If that's not an option, you could read the list of keywords and do a ListFindNoCase() on it. That will be incredibly slow though, if you do it for every entry in a

RE: ms sql to ms access

2001-08-22 Thread DeVoil, Nick
Lorenzo > i have a sql script and i wont this to became an access db Can you post the script? ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received

RE: History table

2001-08-20 Thread DeVoil, Nick
> Can anyone advise if its possible to extract the page title from the browser history table No, it's not possible (for security reasons). Nick ** Information in this email is confidential and may be privileged. It is intend

RE: Database query question

2001-08-17 Thread DeVoil, Nick
What do you mean by "output a single row"? You mean sth like FoodName MoreFoodInfo Nutrient1 Value Nutrient2 Value. - - - - Name more stuff ENERGY-SOA 191.574 PROT FAT where the number of columns is controlled by the number of

RE: SQL Syntax - table structure

2001-08-17 Thread DeVoil, Nick
Try sp_columns() Nick -Original Message- From: Mak Wing Lok [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 1:46 AM To: CF-Talk Subject: OT: SQL Syntax - table structure hi, this might sound stupid but i have forgotten the command. does anyone know the command to view a table

RE: GTE problem

2001-08-15 Thread DeVoil, Nick
> CF5 Pro, 2K - anyone got NT still ? Yes, it works for me on NT4.0 too. ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notif

cfusion_dbconnections_flush() - is it safe?

2001-07-20 Thread DeVoil, Nick
I'm using to unlock a database. Access 2000, NT4. The function does successfully delete the .ldb file and the .mdb file can then be re-opened OK. But afterwards, when I open the .mdb file using Access itself, on exiting Access I get an error message "There was a problem sending the command to

RE: XML db

2001-07-16 Thread DeVoil, Nick
I'd put XML documents into 2 categories - 1. Data-driven - containing a serialized version of some highly structured business data that might have come out of/be going into a relational DB, but is put in an XML form for standardized transport purposes; 2. Text-driven - where the data is much les

RE: JavaScript

2001-07-13 Thread DeVoil, Nick
Jerry Something like document.forms[0].total.value = parseInt(document.forms[0].a.value) + parseInt(document.forms[0].b.value) + parseInt(document.forms[0].c.value); Nick -Original Message- From: Jerry Staple [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 9:33 AM To: CF-Talk Su

RE: CF XML-RPC

2001-07-12 Thread DeVoil, Nick
e. I know that this is not true SOAP, but it seems that this is the only solution that I have seen that works. I can not go to CF5.0. The client wants us to stay with 4.5. Any other suggestions out there? --Michael - Original Message - From: "DeVoil, Nick" <[EMAIL PROTE

RE: Get Table names, and Field Names

2001-07-12 Thread DeVoil, Nick
> Is there a SQL command, or CF Function that can get the names of all the tables in a database? Chad It depends what DBMS you're using. If it's Access, look here http://www.thenetprofits.co.uk/coldfusion/faq/#answer77 Otherwise I believe the following queries are mostly correct: Ingres:

RE: CF XML-RPC

2001-07-12 Thread DeVoil, Nick
OK, it's not on the web, but the new Wrox book "Professional ColdFusion 5.0" has details on how to use SOAP with CF. Also (still not on the web) O'Reilly have a book on XML-RPC. But if it's SOAP you want, then why not go straight with SOAP? Nick -Original Message- From: Michael S. Kim

RE: Define and Call UD-Functions

2001-07-11 Thread DeVoil, Nick
Patrick You can certainly use the Caller scope in your custom tag. That will pick up a UDF defined in application.cfm. Nick -Original Message- From: Wagner Patrick [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 11, 2001 4:26 PM To: CF-Talk Subject: Define and Call UD-Functions Hi th

RE: SQL select all BUT

2001-07-05 Thread DeVoil, Nick
No. -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 28, 2001 5:21 PM To: CF-Talk Subject: ot: SQL select all BUT Is there a way to run a select statment that fetch ALL (*) colums BUT colum5,coulm6 something which is similiar to: SELECT colum1,co

WOT: Flash questions

2001-07-05 Thread DeVoil, Nick
I've asked this on a couple of Flash lists but I guess the question is so badly framed that no-one knows what I'm on about. But I know you guys are patient & some of you are pretty good with Flash so I'll try here. I am designing a database-driven web app which has 2 particular features: - some

RE: Purchasing a copy of ColdFusion Server in the UK

2001-07-04 Thread DeVoil, Nick
> Anyone know where I can purchase a copy of ColdFusion Server in the UK? http://www.highlander.co.uk Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have

RE: Window Size to fit desktop area

2001-07-03 Thread DeVoil, Nick
James How about window.open('http://www.houseoffusion.com','x','width='+screen.availWidth+', height='+screen.availHeight+',top=0,left=0') Nick -Original Message- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Monday, July 02, 2001 5:58 PM To: CF-Talk Subject: OT: Window Size to fi

RE: Dynamic variable names

2001-05-24 Thread DeVoil, Nick
How about Nick -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 4:23 PM To: CF-Talk Subject: Dynamic variable names Can you have dynamic variable names in CF?e.g in an action page could you have something like -

RE: OT Javascript question

2001-05-24 Thread DeVoil, Nick
Andy Does this work? function test(controlnum) { elt = document.forms[0]["interest" + interest]; elt.value = parseInt(elt.value) + 1; } Nick -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 24, 2001 12:18 PM To: CF-Talk Subject: OT Javascript ques

RE: Self-referencing constraint in SQL Server 7

2001-05-22 Thread DeVoil, Nick
Aidan, Yes, I think you can have a FOREIGN KEY constraint referencing another column in the same table. NULL values are OK too. Nick -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 22, 2001 12:08 PM To: CF-Talk Subject: Self-referencing constraint

RE: Setting Dynamic Variables

2001-05-21 Thread DeVoil, Nick
How about Nick -Original Message- From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 2:27 PM To: CF-Talk Subject: Setting Dynamic Variables Trying to create a set of variables dynamically but cannot think of how to do it. Here is what I am trying to do:

RE: SQL Server 7 book(s) recommendation

2001-05-15 Thread DeVoil, Nick
Aidan, I'm afraid this is a negative one as well, but on the strength of Amazon ratings I bought a very expensive M$ Press book called something like "SQL Server 7.0 Database Implementation Kit" which did include a 3-month eval of the DBMS but was very superficial. The only use I've found for it

RE: query error

2001-05-14 Thread DeVoil, Nick
This message is usually caused by a permissions problem with the database. Is it set to read-only? Also suggest making that thread_time field an ODBC date/time. Nick -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 12:36 PM To: CF-Talk Subject: q

RE: CFHTTP and port numbers

2001-05-11 Thread DeVoil, Nick
resolveurl="true"> I don't think that http://foo.bar.com:6660 will work in the address line. Jeff -Original Message- From: DeVoil, Nick To: CF-Talk Sent: 5/10/01 1:07 AM Subject: CFHTTP and port numbers It seems that CFHTTP cannot connect to an address of the form h

CFHTTP and port numbers

2001-05-10 Thread DeVoil, Nick
It seems that CFHTTP cannot connect to an address of the form http://foo.bar.com:6660 Can anyone confirm this and/or tell me how I can make an HTTP request to an address like this? Thanks Nick ** Information in this email is

RE: New Cold Fusion book, O'riely Press

2001-05-10 Thread DeVoil, Nick
Jeff, I agree that O'Reilly books are usually excellent. I don't know anything about this one. But you might like to know that Wrox are also bringing out a CF5 book. http://www.wrox.com/Books/Book_Details.asp?section=1_2&isbn=1861004540 Nick -Original Message- From: Jeff Fongemie [mai

RE: MS Access JOIN Error

2001-05-09 Thread DeVoil, Nick
Does this work? FROM [MPA log] LEFT JOIN [52 log] ON [MPA log].[MPA #] = [52 log].[MPA #] Those table names and field names are pretty confusing. Is it an option for you to change the names so that they do not contain spaces, pound signs etc? Nick -Original Message- From: [EMA

RE: ASP NumberFormat

2001-05-09 Thread DeVoil, Nick
WTF? Is this a joke? -Original Message- From: Chris Maloney [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 8:04 PM To: CF-Talk Subject: RE: ASP NumberFormat Nathan, At first only your newsletters made me wonder about your lack of professionalism. Chris -Original Message---

RE: [Object Oriented CFML]

2001-05-09 Thread DeVoil, Nick
>Can you call a JSP page as an object, pass parameters to it, have its variables and such encapsulated, etc? You can't do this with a JSP per se, but you can call Java classes from within a JSP. You can do it with a servlet. A servlet is a Java class. A JSP interpreter such as JRun turns JSP's

RE: ASP NumberFormat

2001-05-08 Thread DeVoil, Nick
http://msdn.microsoft.com/scripting/default.htm?/scripting/vbscript/doc/vsfc tFormatNumber.htm ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in

RE: WDDX shows all the data!!!

2001-05-08 Thread DeVoil, Nick
If you convert it to JavaScript and send it to the browser, then of course you can see the data. If there's data you want to hide, don't send it to the browser. Nick -Original Message- From: Akbar Pasha [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 3:03 PM To: CF-Talk Subject: W

RE: cfpop - how to display html content properly?

2001-05-08 Thread DeVoil, Nick
Try replacing < with < and > with > That does it for me. Nick -Original Message- From: Rudy Rustam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 1:41 PM To: CF-Talk Subject: cfpop - how to display html content properly? Here is my scenario: Go to any website with a complex ht

RE: using WDDX for next 'n' style browsing

2001-05-08 Thread DeVoil, Nick
n every page request as a user browses through results returned from a search KOla -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: 08 May 2001 12:05 To: CF-Talk Subject: RE: using WDDX for next 'n' style browsing I guess you mean the database server. You

RE: using WDDX for next 'n' style browsing

2001-05-08 Thread DeVoil, Nick
I guess you mean the database server. You're still making a trip to the *web* server for every page - and sending a lot of data. Without knowing exactly what you're trying to achieve, I'd guess cacheing the query would be better, yes. Nick -Original Message- From: Kola Oyedeji [mailto:[E

RE: cfmodule oddness

2001-05-03 Thread DeVoil, Nick
> I guess "nor does it try to find CFML tag variables" means you also have to prefix attribute scope variables as well. It's not very clear, is it? I took it to mean ERROR returned by , CFFTP returned by etc. As opposed to FILE returned by , . Of course, you're right that Attribute and Caller

RE: Large recordset = large whitespace???

2001-04-27 Thread DeVoil, Nick
Have you got a or lurking around somewhere in the table, not correctly enclosed in and ? Nick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 2:43 PM To: CF-Talk Subject: Large recordset = large whitespace??? I have a query that c

RE: slightly OT ADO vs DAO

2001-04-26 Thread DeVoil, Nick
DAO is a dead-end. ADO is more future-proof. Nick -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 10:51 AM To: CF-Talk Subject: slightly OT ADO vs DAO Hi all, I know this is slightly OT, but I wanted to get peoples opinions about ADO vs DA

RE: Storing structures in a DB

2001-04-26 Thread DeVoil, Nick
> as for normalizing; with a globally designed DB - it is not necessary; the logic is ported into the App. Well, sorry to bore people with this now slightly OT thread, but "there's the rub" - by storing all the data in one table you have thrown away all the inherent business-modelling capability

RE: Storing structures in a DB

2001-04-25 Thread DeVoil, Nick
How does that speed up development time though? -Original Message- From: Neil Clark [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 11:25 AM To: CF-Talk Subject: RE: Storing structures in a DB Well, data either stored as XML or defined by XML is the way DB's are going, there

RE: Storing structures in a DB

2001-04-25 Thread DeVoil, Nick
irect sales and VAR sections so I can store the extra details. Is it as simple creating a structure then inserting it into a DB field. When I want to display the data for a user can I query the database then access the structure as I normal ? -Original Message- From: DeVoil, Nick [mailto:[

RE: Storing structures in a DB

2001-04-25 Thread DeVoil, Nick
Darren The question isn't as simple as all that - the subject line says DB but the body says array. In both cases the answer is yes, but the details depend on what exactly you're trying to do. One way of storing a structure in a DB is to put it in a WDDX packet & put that in a large text field.

RE: Is CF still relevant?

2001-04-25 Thread DeVoil, Nick
> I shudder to recall those heady days when the popular challenge was "I can write that APL program in 1 line" but I don't remember what it does... and can't figure out how it does it! Unfortunately those days have not gone, on the contrary... s/APL/Perl/gi Nick

RE: Date Difference

2001-04-24 Thread DeVoil, Nick
Select DateDiff(d, GETDATE(), expdate) from ... where... -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 1:52 PM To: CF-Talk Subject: Date Difference cf talk. I want to find out the difference in days between select getdate() - expdate wh

RE: caller scope

2001-04-24 Thread DeVoil, Nick
Bryan I do it this way Calling page: Tag: select * from someTable This uses one more assignment than strictly necessary, but it just seems neater that way. Nick -Original Message- From: Bryan LaPlante [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 2:16

RE: graphing

2001-04-24 Thread DeVoil, Nick
Which, running CF5 in production, or expiring? The beta licenses expire on May 1 according to the docs. Nick -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Monday, April 23, 2001 1:24 AM To: CF-Talk Subject: RE: graphing I am doing so already :-) -Original

RE: populating the query result to IFRAME

2001-04-24 Thread DeVoil, Nick
Paul Not sure exactly why you get that message but try replacing with and Close with Close and the 2 JS functions with function doSection() { sec = getElementById("thesection"); sec.style.visibility = "visible"; } function noSection (secNum) { sec = getEleme

RE: Access/SQL/hosting question

2001-04-24 Thread DeVoil, Nick
Vernon, That is too much traffic to expect Access to handle. IMO you will possibbly get more performance improvement from going to SQL Server than going to a dedicated server. The amount of Access database activity done by other users on the server you're using shouldn't affect you that badly.

RE: It's not big and it's not clever...

2001-04-24 Thread DeVoil, Nick
And pretty bad news for anyone called John, Dick, Bob, Jay etc... -Original Message- From: Jon Gage [mailto:[EMAIL PROTECTED]] Sent: Monday, April 23, 2001 5:15 PM To: CF-Talk Subject: RE: It's not big and it's not clever... If you use the library below however, you may encounter words

RE: How to get Julian Date

2001-04-12 Thread DeVoil, Nick
Julian dates are normally based on something in the distant past, so if you want it to work with existing data you need to make sure the base date is the same. I think that the base date can be configured within Informix. Nick -Original Message- From: Paul Sizemore [mailto:[EMAIL PROTECT

RE: Passing a structure to JavaScript with wddx

2001-04-10 Thread DeVoil, Nick
Marius Looks like you have a structure member called "3" which is not a valid JavaScript variable name. The strange thing is, it's not a valid CF variable name either so I'm not sure how it got there. ? Nick -Original Message- From: Marius Milosav [mailto:[EMAIL PROTECTED]] Sent: Tues

RE: [Oracle Auto-Increment]

2001-04-02 Thread DeVoil, Nick
Just specify the column as an IDENTITY in your CREATE TABLE statement. -Original Message- From: Arden Weiss [mailto:[EMAIL PROTECTED]] Sent: Monday, April 02, 2001 2:58 PM To: CF-Talk Subject: RE: [Oracle Auto-Increment] What about SQL Server -- how to auto-increment?? ^ / \__

RE: Oracle Auto-Increment

2001-04-02 Thread DeVoil, Nick
WIth Oracle you can set up a "sequence" which gives you the same kind of functionality. eg CREATE SEQUENCE mytab_seq ON mytab INCREMENT BY 1; then in your insert statement you can say INSERT INTO mytab() VALUES (mytabseq.nextval, ) Nick -Original Message- From: Jamie Symonds [

RE: Java CFX tags

2001-04-02 Thread DeVoil, Nick
> Does anyone know when support for Java CFX introduced and where it is documented? It was new in 4.5. There is some stuff in chapter 18 of Developing Web Apps with CF. Nick ** Information in this email is confidential and may

RE: javascript add problem

2001-03-28 Thread DeVoil, Nick
Multiply each number by 1 first. Then the JS interpreter will know they're numbers not strings. Nick -Original Message- From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 5:13 PM To: CF-Talk Subject: OT: javascript add problem Sorry about the OT question,

RE: multilanguage site

2001-03-28 Thread DeVoil, Nick
Chad There have been 1 or 2 good threads on this, try starting at http://www.mail-archive.com/cf-talk@houseoffusion.com/msg16575.html -Original Message- From: chad jackson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 6:22 AM To: CF-Talk Subject: multilanguage site Hi guy

RE: session variable storage

2001-03-27 Thread DeVoil, Nick
And also it works with clustering. The downside is that it must tend to be slightly slower. Nick -Original Message- From: Bob Silverberg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 5:15 PM To: CF-Talk Subject: RE: session variable storage I believe you mean Client variabl

RE: Converting CFML to WML

2001-03-27 Thread DeVoil, Nick
No, you shouldn't need to change that at all. You're just delivering content to a different client. There are some examples somewhere on the Allaire site. The only reason you would need to change anything on the server is if the limitations of that client make your existing design unworkable. F

RE: OT CSS

2001-03-27 Thread DeVoil, Nick
> How many of you are using external CSS in your apps and can > anyone recommend a good reference book on CSS? I almost always use them & Danny Goodman's Dynamic HTML book (O'Reilly) works for me. Nick ** Information in this e

RE: Converting CFML to WML

2001-03-27 Thread DeVoil, Nick
It's the HTML you convert, not the CFML. Yes it is quite easy, depending on how clean the code was in the first place. However, you probably need to redesign the user interface, which may not be so easy. Nick -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECT

RE: any way to retrieve the actual SQL used

2001-03-26 Thread DeVoil, Nick
Why not write the query text into a session variable when you execute it the first time? Nick -Original Message- From: Chris Phillips [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 10:51 AM To: CF-Talk Subject: any way to retrieve the actual SQL used Hi all Is there any way t

RE: CF Status in UK

2001-03-26 Thread DeVoil, Nick
There are UK-based CF contracts every week on www.jobserve.com. There was a thread on CF status in the UK on the list a while back, you should be able to find it in the archives. Basically with your experience you shouldn't have any problems if your company know what they're doing. Also, try th

RE: Textbox validation

2001-03-23 Thread DeVoil, Nick
Really the best way is *both*. JavaScript is much nicer from a user interface point of view. But if the validation is important you need to do it again on the server, because you can't guarantee the user has JavaScript running in their browser. Nick -Original Message- From: W Luke [mailt

RE: CF and ORACLE

2001-03-20 Thread DeVoil, Nick
http://technet.oracle.com ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your

OT: RE: Need some quick help: Sorry

2001-03-16 Thread DeVoil, Nick
too quick on the button ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your s

RE: Need some quick help

2001-03-16 Thread DeVoil, Nick
apache on NT -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Friday, March 16, 2001 3:22 PM To: CF-Talk Subject: OT: Need some quick help Hi all, I need some quick help from developers using anyone the following with CF (I need one of each): - Netscape Enterprise

RE: XML

2001-03-16 Thread DeVoil, Nick
> Let me point out a very good reason NOT to use CF for XML. > When you get XML, you have to compare it to your DTD and > then parse it to get the data out. Pedantic point: you only have to look at the DTD if you need to validate the XML. No need to otherwise. As regards parsers, I've used MSXM

RE: What If Question

2001-03-15 Thread DeVoil, Nick
Maybe not the approach you're looking for, but I would do a JavaScript window.close(). That closes the current window. If you have popups and/or frames to deal with, you would need to do a recursive JS function to navigate up to the top of the window hierarchy and close the windows downwards. Hav

RE: Using javascript to create an Undo - the return

2001-03-14 Thread DeVoil, Nick
I think you would need to trap every key depression and mouse click while they were in the textarea. The problem is, you would need to know where the text pointer was at any moment, and I don't see how you could do that reliably if they used the mouse to reposition it. Nick -Original Messag

RE: XML

2001-03-14 Thread DeVoil, Nick
This is right, but you don't have to use a different *parser* to turn your XML into HTML, WML, etc. You can use XSLT (XML style sheet transformation) with different XSL stylesheets for each target format. The XML can be as complex as you like. Nick -Original Message- From: Andy Ewings [

RE: Accessing field names dynamically

2001-03-09 Thread DeVoil, Nick
This does it for me #fieldname# Nick -Original Message- From: Lockie Martin [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 2:36 AM To: CF-Talk Subject: Accessing field names dynamically This question comes into the category of I've seen it somewhere! I have a cross

RE: Another SQL statement question...

2001-03-07 Thread DeVoil, Nick
Yes, my bad, isnull not ifnull -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 07, 2001 4:24 PM To: CF-Talk Subject: RE: Another SQL statement question... > It's off-topic, but I know people here are experienced with SQL, so... > > I am usi

RE: Another SQL statement question...

2001-03-07 Thread DeVoil, Nick
how about SELECT TextID, IFNULL(TextColumn1, '') + IFNULL(TextColumn2, '') AS AllTextColumns FROM Table1 -Original Message- From: river [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 07, 2001 3:53 PM To: CF-Talk Subject: Another SQL statement question... It's off-topic, but I know

OT: Converting Microsoft Publisher/QuarkXpress to PDF

2001-03-07 Thread DeVoil, Nick
Kind of related to the Word/Powerpoint thread... Does anyone have any idea how to convert documents in the above 2 formats to PDF? Not automatically using CF, but manually on a PC. I'm being asked & have no clue about this stuff. I believe there is a plugin for QuarkXpress that does this? As for

  1   2   3   4   >