Re: Date Format 1/1/1900

2002-10-29 Thread Jochem van Dieten
Bryan F. Hogan wrote: Hello all, I remember when CF5 first came out that people where having problems with DateFormat() returning 1/1/1900. Do any of you remember how to correct this? By using a valid datetime object instead of a string as the attribute. Jochem

=?iso-8859-1?Q?Re: Re: =3D?iso-8859-1?Q?=3DC2_before_=3DA3_with_MX_form_posts??=C2_before_=A3_with_MX_form_posts?=

2002-10-29 Thread Jochem van Dieten
Paul Wilson wrote: I am posting some information from one cf page to another but every £ sign is proceeded with Â. You can see an example here (Look at Binasys Ltd) http://efilesystem.com/Computer/Web_Hosting/Technical_Web_Hosting/more4.html You are sending unicode but you are not using

RE: MySQL for Windows and CF

2002-10-30 Thread Jochem van Dieten
I was using Acess but have now installed mySQL for Windows. I'm a little confused on how to create a database. With Access its a snap but there are no tools for me to create the databases? How about: http://www.mysql.com/doc/en/Connecting-disconnecting.html

Re: CF4.5/5 cfqueryparam differences

2002-10-30 Thread Jochem van Dieten
Quoting Everett, Al [EMAIL PROTECTED]: I'm finding an issue with how 4.5 and 5 treat DATE columns using CFQUERYPARAM. I have the following (snippet) in one of my queries: AND AUTHORIZATION_EMAIL_NEXT_DATE cfqueryparam cfsqltype=CF_SQL_DATE value=#CreateODBCDate(10/31/2002)#

Re: CF4.5/5 cfqueryparam differences

2002-10-30 Thread Jochem van Dieten
Everett, Al wrote: Well I'll be damned. It looks like that worked. Thanks. Here's the magic code: cfset checkdate = DateFormat(DateAdd(d,1,Now()),'-mm-dd') cfquery ... .. WHERE AUTHORIZATION_EMAIL_NEXT_DATE cfqueryparam cfsqltype=CF_SQL_TIMESTAMP value=#Variables.checkdate# Well,

Re: How secure is encrypt

2002-10-30 Thread Jochem van Dieten
John Gedeon wrote: how good is the encryption that the built in cf function use? good enough for cc's or passwords? Totally insecure. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4

Re: How secure is encrypt

2002-10-30 Thread Jochem van Dieten
Robertson-Ravo, Neil (REC) wrote: expand/explain? It is more obfuscated as encrypted. So if a hacker has sufficient data with some common characteristic, like creditcards of which you know they follow the MOD 10 algorithm and have predictable starting numbers, it is hackable. But the deeper

Re: Times Return Wrong

2002-10-30 Thread Jochem van Dieten
Tyler Clendenin wrote: I am using Cold Fusion MX and connecting to an informix database through an odbc source. The problem is that all times being reutrned from the queries are actually three hours greater then what is in the database. Anyone know what this could be. I am guessing some

Re: CFMX Scheduled tasks

2002-10-30 Thread Jochem van Dieten
Rob Rohan wrote: Anyone know where schedule tasks are kept in MX. They used to be kept in HKEY_LOCAL_MACHINE\SOFTWARE\Allaire\ColdFusion\CurrentVersion\Schedule in 5. I have a process that needs to list the items in the current Schedule; however, I can't find them. They don't seem to be in

Re: CFMX Scheduled tasks

2002-10-30 Thread Jochem van Dieten
Rob Rohan wrote: Wow nuts. if you do cfdump var=#factory# that is a bit overwhelming. ooof. I am nowhere near to knowing all the options, but it is cool stuff. You can access some functionality that is not in the administrator, like changing the location of the mail spool and flushing

Re: OT:Yahoo moving to PHP

2002-10-30 Thread Jochem van Dieten
/me votes this thread goes to Michaels mailbox Jochem -- If it weren't for Quirk's exception, this would be a nice time to make a reference to Hitler. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4

[OT] DevCon Community Suite Broadcast wrap-up

2002-10-30 Thread Jochem van Dieten
Upon request, this is a writeup of the broadcast of the videostreams from the Community Suite. This is only about technical/operational issues, a more 'community oriented' message will be sent to cf-community, accessible through the archives at

[Fwd: S-02-104: Microsoft: MS02-062 Cumulative Patch for IIS]

2002-10-31 Thread Jochem van Dieten
FYI: IIS 4: reboot required IIS 5: possibly reboot required (I had to, but the message suggested was that was for a problem due to my specific configuration) Jochem Original Message === Security

Re: CF MX Query of Query Lower() Function

2002-10-31 Thread Jochem van Dieten
DDE wrote: Looks like the usage of Lower() function in a query of query does not work as in standard SQL. Simple example: if you have a table containing names ( first_name middle_name and last_name) the following query of query : cfquery name=”myquery” dbtype=”query” select * from

Re: [Fwd: S-02-104: Microsoft: MS02-062 Cumulative Patch for IIS]

2002-10-31 Thread Jochem van Dieten
Joshua Miller wrote: Where do you signup to be alerted about such vulnerabilities and patches? Probably http://www.cert.org/ Most countries have their own, so you could also Google on CERT and your ccTLD. Jochem ~|

Re: basic question - testing for no reuslts from query

2002-10-31 Thread Jochem van Dieten
Tim Laureska wrote: I'm ashamed to say I've been banging my head on this for an hour. what is a simple way to code a statement that displays a message when a query produces no results.. like: Use queryname.recordcount Jochem

Re: [Fwd: S-02-104: Microsoft: MS02-062 Cumulative Patch for IIS]

2002-10-31 Thread Jochem van Dieten
Robertson-Ravo, Neil (REC) wrote: Start Windows Update or Tools Windows Update from IE. You can then download all the necessary updates and the Critical Update notification package which will run in your system tray. It can download and alert you of all the latest patches and fixes for

Re: CF MX Query of Query Lower() Function

2002-10-31 Thread Jochem van Dieten
D. Delcomminette wrote: by the way what does the mean time exactly means ?? It is a typo, it is supposed to be meantime :) Which in this case is the time between submitting the bug to Macromedia, for which I posted the link, and the time Macromedia fixes it. Jochem

Re: CF MX Query of Query Lower() Function

2002-10-31 Thread Jochem van Dieten
Raymond Camden wrote: CFMX Query of Query has an lcase function. You could use this to do a non-case sensitive type search. This function did not exist in CF5 QofQ however. LCase() throws an syntax error and is not in the docs [1], whereas Lower() is and only throws a null exception when it

Re: CF MX Query of Query Lower() Function

2002-10-31 Thread Jochem van Dieten
Raymond Camden wrote: It's what I get for posting before coffee. Yes, Lower() is right, not Lcase. So the issue is that it's not handling a null value in the column? Yes. But I presume Dominique has already filled out the bug form. Jochem

Re: CFMX Schedule Tasks - Keep on truckin'

2002-10-31 Thread Jochem van Dieten
Have you tried restarting the CronService through the Factory (CronSevice.Restart())? It works for other 'subservices', and you don't loose all session and application variables. Jochem ~| Archives:

Re: Internationalization Theme

2003-02-13 Thread Jochem van Dieten
Adam Churvis wrote: -- How to leverage the XML handling capabilities of SQL Server 2000 and Oracle 9iR2. Please, no db-vendor specific content, there is more than enough content claiming you need database X for feature Y already, and it tends to outlive the thruth of the statement by years

Re: Internationalization Theme

2003-02-13 Thread Jochem van Dieten
Paul Hastings wrote: ISO/IEC 9075-14:200x(E), available through the usual channels, will tell you how the upcomming SQL:2003 standard will define what the behaviour of XML and SQL combined has to be. Please base any best practices documents on the current working drafts of that standard. that

Re: Internationalization Theme

2003-02-13 Thread Jochem van Dieten
Christian Cantrell wrote: There is an internationalization and globalization theme coming up on DevNet in the next few months. Would anyone like to suggest some specific ColdFusion topics? We obviously want to cover areas where people have the most difficulty and questions. Please make

Re: Internationalization Theme

2003-02-13 Thread Jochem van Dieten
Adam Churvis wrote: Adam Churvis wrote: -- How to leverage the XML handling capabilities of SQL Server 2000 and Oracle 9iR2. Please, no db-vendor specific content, there is more than enough content claiming you need database X for feature Y already, and it tends to outlive the thruth of the

Re: CF MX Enterprise Security

2003-02-13 Thread Jochem van Dieten
David Brown wrote: Well, thank you both for responding. In a word that SUCKS big time. Sometimes I have to ask where is Macromedia brain at? Tossing out RDS security (or maybe just RDS completely), but providing a free developers edition instead seems a reasonable solution to me. Jochem

Re: CFQUERYPARAM

2003-02-13 Thread Jochem van Dieten
,Greg wrote: OK, I'm trying to use cfqueryparam on a varchar field insert and it's inserting a ? even though I'm entering a value in the form field that's posting to this query. Anyone know what's wrong here? VALUES ('cfqueryparam value=#Trim(Attributes.firstname)# cfsqltype=CF_SQL_CHAR

Re: Cflogin

2003-02-13 Thread Jochem van Dieten
Scott Dowling wrote: Hey guys I cab get cflogin to work but when I use cfloginuser to set name and password and role how to access them in my app. GetAuthUser() and IsUserInRole(role) Jochem ~| Archives:

Re: OT: spam...

2003-02-13 Thread Jochem van Dieten
Lee Fuller wrote: Did you also get back a message from them stating that it's a spammer who's pretending to be them? I did, and they have an announcement about it now. Seems someone who was caught by them is simply getting even. It is pretty hard to verify that claim without the full headers.

Re: Internationalization Theme

2003-02-13 Thread Jochem van Dieten
Adam Churvis wrote: Any my suggestion was using ColdFusion with two very popular XML-capable databases, namely MS SQL Server and Oracle 9iR2. And mine is not to lock the examples into some specific propietary database that makes them unuseable and untranslateable for everybody that happens

Re: Internationalization Theme

2003-02-13 Thread Jochem van Dieten
Adam Churvis wrote: That is a nice _theory_, but it is only that: a theory. It isn't a simple matter of a change in syntax; there are completely different techniques available in some very popular products. To disregard these very valuable and popular techniques is to say, You guys

Re: Refresh error on CFMX...

2003-02-13 Thread Jochem van Dieten
Tyler Silcox wrote: Does anyone else get the following error everytime they change code and hit refresh? Index: 219, Size: 194 The Error Occurred in Z:\somedomain\fbx_fusebox30_cf50.cfm: line 159 If the error continues with something about an array index out of range during

Re: Verity and Clustered Servers

2003-02-13 Thread Jochem van Dieten
Ryan wrote: If I have a set of clustered servers (with clustercats) and they all need to access a verity collection. Does each server need to create and index its own collection? We are trying to place the verity directory on an nfs share so that all servers would see the collections as

Re: any ideas on this error?

2003-02-13 Thread Jochem van Dieten
Dave Lyons wrote: Parameter validation error for function DATEDIFF. The value of the parameter 2, which is currently CreateDateTime(Now()), must be a class java.util.Date value. You are using CreateDateTime() incorrectly. First, the syntax is different:

Re: SQL Help Requested: Unique Same Field Sum Combinations

2003-02-13 Thread Jochem van Dieten
Thomas Sammons wrote: How would you do this in CF (any version 4.5 or higher): return all unique combinations of rows where the unique row field value combination has a certain summed value? For example: I have a SocksTable with 6 SockDrawers, and each SockDrawer has a number of Socks in

Re: Use a list in where clause?

2003-02-14 Thread Jochem van Dieten
Tony Gruen wrote: SELECT Subscribers.SubscriberID, Subscribers.EMail FROM (Subscribers INNER JOIN SubscriberAddress ON (Subscribers.SubscriberID = SubscriberAddress.ASubscriberID)) WHERE SubscriberAddress.state IN ('#FORM.EmailState#') Use cfqueryparam with the list attribute. Jochem

Re: best way to enter currency format

2003-02-14 Thread Jochem van Dieten
Paul Hastings wrote: (say user is bidding $1,000.00) $1,000.00 $1,000 $1000 1,000.00 1,000 1000 use currency datatype on the backend. I would have said Don't use currency on the backend because it is not an official datatype, but since you are using Access the correct alternative, using

Re: Problems with mysql

2003-02-14 Thread Jochem van Dieten
Ryan Mitchell wrote: Hey Im runnign CFMX with mysql as my db. Until about a month a go I was using access, but now with mysql, when I insert info into a database I get certian characters (' , ... etc) replaced by just mental stuff. It makes no sense!! Use cfqueryparam. In the

Re: Problems with mysql

2003-02-14 Thread Jochem van Dieten
Ryan Mitchell wrote: Ok to answer all questions... Im using the last 3 version of mysql (ie 3.x), im using cfinsert + cfupdate. Jochem, how do u specify unicode and charset in the connection string? Use the following in the connectstring:

Re: Bad External Date Representation

2003-02-14 Thread Jochem van Dieten
Jillian Carroll wrote: cfquery name=update datasource=#DSN# UPDATEattendee SET cfif IsDate(Trim(Form[regreceived Indx])) regreceived = #CreateODBCDate(ParseDateTime(Trim(Form[regreceived Indx])))#, cfelse regreceived = NULL,

Re: Why is this?

2003-02-16 Thread Jochem van Dieten
CFDEV wrote: Why does this still present an area around the outside of the table. I set the table border to equal 1 so I can see it. I want the table FLUSHED at 100%. It seems like it is using like 98% with 1% around the top, bottom, left and rights. Here is the code: (Suggestions on why

Re: http requests through Satellite

2003-02-17 Thread Jochem van Dieten
John McCosker wrote: On average twice out of every ten requests an error msg is returned in the hidden IFRAME, saying, A FAULT HAS OCCURRED, A MALFORMED HTTP REQUEST HAS BEEN MADE, PLEASE CONTACT YOUR WEB BROWSER TECHNICAL SUPPORT TEAM AND HAVE YOUR ACCOUNT NUMBER READY FOR THE TEAM.

Re: http requests through Satellite

2003-02-17 Thread Jochem van Dieten
John McCosker wrote: Well we only develop for I.E. which is a luxuary, Also if IE doesn't work? but I have tried this over multible versions of i.e. fro 5 up, over dial up, broadband as well as other customers, and it works just fine, yes I have just found out its using proxies. Append a

Re: CFMX Upgrade Woes

2003-02-17 Thread Jochem van Dieten
Candace Cottrell wrote: Here's the problem and I have racked my brain and caused an aneurism trying to figure this out. You should be carefull with those. Setup: Win 2000, CFMX Pro w/updater 1, IIS 5.0, SQL Server 2000 Why not Updater 2? cfoutput query=searchByDate tr

Re: CFMX Upgrade Woes - Jochem

2003-02-17 Thread Jochem van Dieten
Candace Cottrell wrote: [EMAIL PROTECTED] 02/17/03 15:11 PM Candace Cottrell wrote: Here's the problem and I have racked my brain and caused an aneurism trying to figure this out. You should be carefull with those. I KNOW IT HRRRTS ;) It kills. 10-30-2002 , MIBG SCAN @0830

Re: highlight MULTIPLE keywords in search results...

2003-02-17 Thread Jochem van Dieten
Tuan wrote: Can somebody provide me with an example of how to highlight multiple keywords in a search result? For example say I wanted to search for macromedia coldfusion, studio the search results will highlight every instance of macromedia, coldfusion, and studio in the document. 2 step

Re: OT: Oracle Foreign Key Constraint

2003-02-17 Thread Jochem van Dieten
S. Isaac Dealey wrote: create table tship_location ( locationid varchar(35) primary key, locationname varchar(25) not null, locationorder int not null ) create table tship_xref ( locationid varchar(35) not null, priceid varchar(35) not null,

Re: CFlocation in a Site-wide Error Handler with CFMX and caffeine

2003-02-18 Thread Jochem van Dieten
Mark W. Breneman wrote: cfheader statuscode=301 cfheader name=Location value=http://domain/; I am not familiar with your problem, but *don't* use a 301 for an error- redirect. A 301 is a permanent redirect which a browser is allowed to cache. Use a 302 or if a change from POST to GET is

Re: Set HTTP Headers

2003-02-18 Thread Jochem van Dieten
Jeff Chastain wrote: The headers that are sent by the browser are all that I am interested in at this point. I am just trying to figure out how to pass in some test data. You need a custom browser for that. Telnet is a nice one ;-) The reason for this is quite simple actually. Suppose that

Re: Set HTTP Headers

2003-02-18 Thread Jochem van Dieten
Jeff Chastain wrote: -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 11:23 AM To: CF-Talk Subject: Re: Set HTTP Headers Jeff Chastain wrote: The headers that are sent by the browser are all that I am interested

Re: WOT: Email Archive

2003-02-20 Thread Jochem van Dieten
Jeff Chastain wrote: I am needing to put together a simple web based archive for email messages. My question is how to build the threading - how do you tell how one message relates to another? You obviously cannot rely on the subject line as people can modify that and their email programs can

Re: AS400 Admin ODBC Setup

2003-02-20 Thread Jochem van Dieten
Lee Surma wrote: I'm working in a new environment that uses the Clinet Access ODBC driver that creates a connection with an AS/400. The driver is installed on the Web/ColdFusion server and I know it works because Microsoft Access can connect to it. A system DSN is set up in data sources

Re: Free?

2003-02-21 Thread Jochem van Dieten
Randell B Adkins wrote: OK, before I jump on this bandwagon, I have seen a lot of talk about BlueDragon. How stable of a server is it for development needs? I have no complaints about stability. The only thing is I have to run it in standalone mode, because it refuses to detect IIS and

Re: cfqueryparam question

2003-02-21 Thread Jochem van Dieten
David Collie (itndac) wrote: cfquery name=qIF_GetQuestion datasource=#APPLICATION.sIF_DSN# SELECT cfqueryparam value=#sColName# cfsqltype=CF_SQL_VARCHAR AS QUESTION FROMcfqueryparam value=#sTableName# cfsqltype=CF_SQL_VARCHAR WHERE cfqueryparam

Re: numbers only

2003-02-21 Thread Jochem van Dieten
Bruce, Rodney S HQISEC/Veridian IT Services wrote: I am trying to remove commas from numbers being inputted by user like 3,333 changed to . This works: tempstring = tempstring.replace(/[^0-9]/g,); but it removes periods 3.33, which I want to keep. so I tried: tempstring =

Re: Installation Advice (was: FREE BlueDragon Server Released!)

2003-02-21 Thread Jochem van Dieten
Eric Dawson wrote: Are there any issues with installing Blue Dragon on an existing W2K, IIS, CF4.5.2 box? or will it be a clean install? I would recommend a standalone install, shouldn't give any problems. Then you should be able to verify your code works using the BlueDragon internal

Re: Parsing Mail Headers

2003-02-21 Thread Jochem van Dieten
Jeff Chastain wrote: Does anybody know of a tag or script somewhere that will parse out email headers? What do you need to extract? Does it need to run under CF MX (which has a ug in CFPOP which strips all linebreaks)? Jochem

Re: Parsing Mail Headers

2003-02-21 Thread Jochem van Dieten
Jeff Chastain wrote: I am running CFMX and am specifically looking for the message ID and reply information. cfscript mID = REReplaceNoCase(headers,^.*messageid: ([^]*).*$,\1); irt = REReplaceNoCase(headers,^.*in-reply-to: ([^]*).*$,\1); etc. /cfscript I tried parsing by linebreak, which did

Re: Parsing Mail Headers

2003-02-21 Thread Jochem van Dieten
Michael Dinowitz wrote: Um, the code I sent you does that already. Otherwise, you can do a RegEx looking for the start text of Message-ID and an end text of . The regex below will get the message ID for you from a raw header Message-ID: ([^]+) The and are part of the messageid, without them

Re: Parsing Mail Headers

2003-02-21 Thread Jochem van Dieten
Michael Dinowitz wrote: Ah. It does some other stuff with the message's body, but that's besides the point. Its just a parser tag and does nothing else. Once I get a free second (yeh right!) I'll probably write some regex patterns for parsing mail headers. RFC compliant ones that'll reject

RE: Updating Multiple Records

2003-02-22 Thread Jochem van Dieten
Quoting Russ [EMAIL PROTECTED]: 12 : commentActive='#Evaluate(FORM.commentActive#i#)#' 13 : WHERE commentID=#Evaluate(FORM.commentID#i#)# 14 : /cfquery 15 : /cfloop Use cfqueryparam. Jochem ~| Archives:

Re: cfqueryparam and mysql problem

2003-02-22 Thread Jochem van Dieten
Quoting Diarmuid King [EMAIL PROTECTED]: I am using cfmx pro version (with updater 2) on a RedHat Linux 7.2 system connecting to MySQL 3.23.36 I just started updating my querys to use cfqueryparam and its not working. CFQUERY datasource=#request.dsn# name=getText SELECT text

Re: OT: SQL math question

2003-02-22 Thread Jochem van Dieten
Quoting Owens, Howard [EMAIL PROTECTED]: 1) How many orders have been place 2) What the total income from those orders ad up to. SELECT COUNT(STATUS) AS TotalOrders, PRICE * QUANTITY AS Revenue FROM store_orders WHERE (MERC_ID = 1) GROUP BY PRICE, QUANTITY Alternatively,

RE: Form validation

2003-02-23 Thread Jochem van Dieten
Quoting Murat Demirci [EMAIL PROTECTED]: I know the FusionScript a little, it is a rich tool. But I'm not sure that it's security, has no bug. All software is either trivial or has bugs. Jochem ~| Archives:

Re: unexpeted result with cfqueryparam

2003-02-23 Thread Jochem van Dieten
Quoting [EMAIL PROTECTED], [EMAIL PROTECTED] [EMAIL PROTECTED]: This behavior isn't a bug, although I can't explain why your code works in CF 5. I would disagree. I think it is a bug. CF's normal behavior is to escape a single quote contained in a SQL string value by doubling it. This is

Re: [OT] CSS Question

2003-02-24 Thread Jochem van Dieten
Taco Fleur wrote: Anyone know how to get rid of that inner border line that appears on a submit button when it is active?? Or even change the color? onClick=blur() Jochem ~| Archives:

Re: unexpeted result with cfqueryparam

2003-02-24 Thread Jochem van Dieten
Dina Hess wrote: But not when using cfqueryparam. Using cfqueryparam is meant to call the functionality of the database driver to do the escaping. Any escaping done by CF before that will only result in doubling the quotes twice, and therefore CF should do no escaping whatsoever of any value

Re: anti-cfflush

2003-02-24 Thread Jochem van Dieten
Hugo Ahlenius wrote: I thought it would be natural to have a tag that just deletes the current rendered page from memory, and starts off again. Kind of like cfflush, which flushes the page to the client, but instead flushes it from memory. cfcontent reset=yes Jochem

Re: Inserting into MySQL database

2003-02-24 Thread Jochem van Dieten
FlashGuy wrote: cfquery name=qInsertData DATASOURCE=results Insert into myresults (strFileName, strCommand, strCreatedOn, strLastAcc, strLastMod, strSize, strDirectory, strDateCommand, strUsername) VALUES ('#Filename#', cfqueryparam value=#strFilename# cfsqltype=CF_SQL_LONGVARCHAR)

Re: URGENT, cfmx interprets MYSQL date (yyyy-mm-dd hh:mm:ss) as INVALID!

2003-02-24 Thread Jochem van Dieten
Leonardo Crespo - Cftop.COM wrote: That's wierd and definitly not nice =/. Maybe i should post a bug @ MM page. I think you should. I have always found it weird that -mm-dd hh:mm:ss (which is one of the 2 formats from ISO-8601) is not an officially supported format, but that it behaves

Re: SQL: How do I a get list of everybody that doesn't meet a certain criteria

2003-02-24 Thread Jochem van Dieten
Kronenberger, Douglas wrote: I have a table that has multiple courses taken (CourseName) entries for each employee (EmpID) This gets me everybody that took the coures. SELECT EmpID, CourseName FROM Course WHERE CourseName = Preventing Sexual Harassment But how do I

Re: SQL: How do I a get list of everybody that doesn't meet a cer tain criteria

2003-02-24 Thread Jochem van Dieten
Everett, Al wrote: From: Jochem van Dieten [mailto:[EMAIL PROTECTED] SELECT EmpID FROM Employees WHERE NOT EXISTS ( SELECT 1 FROM Course WHERE CourseName = Preventing Sexual Harassment

Re: unexpeted result with cfqueryparam

2003-02-24 Thread Jochem van Dieten
Dina Hess wrote: cfset value = String cfquery .. INSERT INTO table (field) VALUES (cfqueryparam cfsqltype=cf_sql_varchar value=#value# /cfquery Make the value anything you want, quotes, backslashes etc., it will work. I did...and it doesn't. But I think I know why now. It doesn't? Even if you

Re: unexpeted result with cfqueryparam

2003-02-24 Thread Jochem van Dieten
Andrew Tyrone wrote: If it's a bug, it's been there since CF 4.0 at least, which is the version I started with. Like I said in my first response, it makes sense to me that CF doesn't escape the single quotes when you are running other functions on the value. It doesn't? How do you explain

Re: unexpeted result with cfqueryparam

2003-02-24 Thread Jochem van Dieten
Dina Hess wrote: Dina Hess wrote: cfset value = String cfquery .. INSERT INTO table (field) VALUES (cfqueryparam cfsqltype=cf_sql_varchar value=#value# /cfquery Make the value anything you want, quotes, backslashes etc., it will work. I did...and it doesn't. But I think I know why now. It

Re: Take a look at the BUG

2003-02-25 Thread Jochem van Dieten
Leonardo Crespo - Cftop.COM wrote: http://webforums.macromedia.com/coldfusion/mm_login.cfm?FTVAR_REDIRECTURLFRM=messagepost%2Ecfm%3Fpostaction%3Dpost%26catid%3D274postaction=Yes The login page is a cfform. Try to put anything and hit submit to see you got a JAVASCRIPT error, because of

Re: CFMX Datasource Connections Limit

2003-02-25 Thread Jochem van Dieten
John Stanley wrote: Problem: The SQL System stored proc sp_who2 lists more connections for the web server than the connections limit specified in the Restrict connections to settings under Advanced Settings for the specific datasource. Known bug. Does this setting not apply to the results

Re: dsn on cfmx - can't create

2003-02-25 Thread Jochem van Dieten
Rich Wild wrote: I've checked the archive on this + the forums + the technotes, but haven't been able to resolve it. We cannot add a DSN to a SQL Server 2000 database through CFMX. What is the error message? Jochem ~|

Re: cf admin 4.01 (screwed up)

2003-02-26 Thread Jochem van Dieten
Tangorre, Michael wrote: we are experiencing errors while trying to connect to the cfadministrator. The error below is what we encounter: ODBC Error Code = IM002 (Data source not found and no default driver specified) [Microsoft][ODBC Driver Manager] Data source name not found and no

Re: Loss of CLIENT variables due to empty quotes in an HTML tag?

2003-02-26 Thread Jochem van Dieten
Kevin Langevin wrote: The weirdest part of it all is that we've narrowed the cause of this to four lines of code in a page that you land on after logging in (which sets a number of these client variables). These lines of code were four tds each of which contains an img tag with an empty src

Re: BIG CFFORM problem :-()

2003-02-26 Thread Jochem van Dieten
Bryan Stevenson wrote: FYIA local ISP here recently upgraded (admittedly a live server) to CFMX and had all kinds of troubles. They contacted MM and were told flat out that CFMX is not considered stable enough for shared hosting. Now if they're telling customers that it kinda makes you

Re: CFFILE - Time Last Modified

2003-02-27 Thread Jochem van Dieten
Thomas, Jeffrey R HQISEC/Veridian IT Services wrote: When using CFFILE with the upload action the file gets saved with the time the file was written to the server. I would like to maintain the original file date. You would first need some clientside utility to read the timestamp from the

Re: Email Attachment encoding problem

2003-02-27 Thread Jochem van Dieten
Craig Snyder wrote: Anyone ever encounter an issue with sending email with attachment? It is being sent from a user-generated script for sending email to a list. Instead of the attachment being sent as an attachment, it is being encoded in the body of the email. Date: Tue, 25 Feb 2003

Re: Resolving Remote IP Address in a CMXF App

2003-02-27 Thread Jochem van Dieten
John Stanley wrote: Is there a custom tag or code to do this for a users IP address to get the company or network info on the fly? Check the DevEx, keyword nslookup. Jochem ~| Archives:

Re: Windows Popup Login

2003-02-28 Thread Jochem van Dieten
David Collie (itndac) wrote: Would you not do it within IIS Properties Directory Security (or very similar)? Hope you are using this over an Intranet with all of your users using IE cos a while ago we learned the hard way that using any sort of Windows log on was limited only to IE (in a

Re: Strange characters after MX upgrade

2003-02-28 Thread Jochem van Dieten
Phillip Cave wrote: Has anyone experienced problems with inserting and updating nText fields after upgrading to CFMX. We have a system that worked fine until the upgrade. Now the system will sometimes (and I mean randomly) insert chr(25) 'end of medium' characters where apostrophes are

Re: CFC's and transactions

2003-02-28 Thread Jochem van Dieten
Sean A Corfield wrote: cftransaction ... some code ... callAnotherDatabaseMethod() ... more code ... /cftransaction Any database activity in callAnotherdatabaseMethod() would not be rolled back if you tried to rollback the

Re: SQL Multiple Reference Tables Question

2003-02-28 Thread Jochem van Dieten
James Brown wrote: CFQUERY name=thinglist datasource=mydata SELECT tblThing.ThingKey, tblThing.ThingName, tblColor.ColorDescription, tblCategory.CatDescription, tblMaker.MakerName FROM tblThing, tblColor, tblCategory, tblMaker WHERE

Re: SQL Multiple Reference Tables Question

2003-02-28 Thread Jochem van Dieten
James Brown wrote: Doesn't work, get the message: the correlation name NATURAL is specified multiple times in a FROM clause I think that is a limitation of MS SQL Server, I can't find any such thing in the SQL standard and it works fine for me in PostgreSQL: jochemd= create table test1 (id1

Re: PHP versus CF Development Speed?

2003-02-28 Thread Jochem van Dieten
Matt Robertson wrote: Jim wrote, snip and unless a free CFML-compliant application server comes around that can be used in a large hosting environment snip BD, baby. in the grand scheme could be the biggest thing to happen to cfml yet, for precisely the reason you state. There's a

Re: SQL Multiple Reference Tables Question

2003-03-01 Thread Jochem van Dieten
Paul Hastings wrote: I think that is a limitation of MS SQL Server, I can't find any such thing in the SQL standard and it works fine for me in PostgreSQL: a plain jane inner join with identitical columns removed (manually) from the select list is a natural join for sql server. SELECT *

Re: msft taking over macromedia

2003-03-02 Thread Jochem van Dieten
Gyrus wrote: anyone tried the url mscromedia.com lately? I imagine Macromedia quite intelligently bought that as S is next to A on the keyboard, so they're directing typos their way. http://www.enom.com/domains/WhoIs.asp?DomainName=mscromedia.com Jochem

Re: msft taking over macromedia

2003-03-02 Thread Jochem van Dieten
Sean A Corfield wrote: On Sunday, Mar 2, 2003, at 12:41 US/Pacific, Jochem van Dieten wrote: http://www.enom.com/domains/WhoIs.asp?DomainName=mscromedia.com Which redirects to addressmuncher which is obviously intended to route typo URLs and, guess what? http://www.enom.com/domains

Re: ODBC Problems?

2003-03-04 Thread Jochem van Dieten
Botts, Tom wrote: I'm getting errors with my MX box trying to connect to an AS/400. After about an hour the MX server hangs. Stopping and starting the ODBC services generally clears it up. Just wondering if anyone has any ideas or if anyone is experiencing similar problems ? Here is one of

Re: Database Connection

2003-03-04 Thread Jochem van Dieten
Double Down, Inc. wrote: I get the following error when I try to go to any cold fusion page in my site. The error reads: Error Executing Database Query. SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity

Re: win 2000 professional for web server?

2003-03-04 Thread Jochem van Dieten
dan martin wrote: I am setting up a web server with CF 5.0 on a win2kpro box and I read in the CF 5.0 installation manual that win2kpro is not recommended because it only allows 10 concurrent TCP/IP connections. This means that only 10 concurrent users can access the website right? Or are

Re: ODBC Problems?

2003-03-04 Thread Jochem van Dieten
Joe Eugene wrote: IF something like CFHttp doens't work in CFMX, the answer to that is NOT.. Hey go download CFX_HTTPVer2 (written by...).. is it? It shouldn't be, but that would depend on issues like deadlines, delayed delivery fines etc. There might be valid reasons not to use a pure Java

Re: CFMX Insert query problem

2003-03-04 Thread Jochem van Dieten
Bud wrote: On 3/4/03, Marius Milosav penned: The only time I have seen that single quotes are doubled when using cfqueryparam is when the string is trimmed prior to be used in a database transaction. If I remember correctly there was a discussion last week on the list to this effect.

Re: CFMX Insert query problem

2003-03-04 Thread Jochem van Dieten
Bud wrote: On 3/4/03, Jochem van Dieten penned: It is a bug in CF MX, not in the JDBC driver. Thanks Jochem. Are they aware of it? Is there a bug report form I can fill out? I would expect MM is aware of this issue, but I don't know how many people that discover this issue actually

Re: Apache on Win2k - WAS: win 2000 professional for web server?

2003-03-04 Thread Jochem van Dieten
samcfug wrote: I use serv-U for my FTP accounts. In IIS it seems to require a unique port number for each FTP account IIS does not require unique port numbers. Jochem ~| Archives:

<    1   2   3   4   5   6   7   8   9   10   >