Database joins

2001-03-07 Thread Bjørn Jensen
Hi, I'm wondering if it's possible to make a join over 2 different databases on 2 different servers. What I'm trying to do is that I have my information on 1 server, including a customer id and the customer name is located on the other server. I can easily get all this info in multiple queries, th

Invalid data in message

2001-03-07 Thread Bjørn Jensen
We're recently enabled the feature to have all coldfusion error captured and an error page displayed. In this page we send ourselves an email with error info. The weird thing is that some of the messages go through and some of them dont, our cf server says: MAIL\spool\4D.cfmail. SMTP server replie

RE: random record

2001-01-17 Thread Bjørn Jensen
If your using a half-desent Database you can also do: SELECT top 1 * FROM Contacts ORDER BY rand() Some db's such as mysql doesn't like "top 1" but supports "limit 1", just can't remember that syntax right now Bjorn -Original Message- From: Jeremy Bunton [mailto:[EMAIL PROTECTED]]

RE: Help:Oracle Date Issues and Error Message.

2001-01-16 Thread Bjørn Jensen
You should also notice that CreateODBCDateTime automatically puts singleqoutes ' around the time so you should not put singlequotes around it Bjorn -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 3:45 PM To: CF-Talk Subject: RE: Help:Ora

Version Control

2001-01-15 Thread Bjørn Jensen
We could really need some Version Control software here at work, and I have found 2 products CS-RCS - http://www.componentsoftware.com/csrcs/addons/allaire.htm and CVS - http://www.cvshome.org/docs/index.html Does anyone know which is the best, or maybe even know a whole 3rd product that is even

RE: CFMAIL addresses & commas

2001-01-03 Thread Bjørn Jensen
I think this will work "Bromby, Dylan <[EMAIL PROTECTED]>","someone <[EMAIL PROTECTED]>" Bjorn -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 03, 2001 4:21 PM To: CF-Talk Subject: CFMAIL addresses & commas Running CF 4.0.1 Ent on WinNT4SP5.

RE: Insert error (String data right truncation)

2001-01-03 Thread Bjørn Jensen
Your variable is bigger than the column in the database, eg. variable is 50 chars, column is 10 chars HTH Bjorn Jensen -Original Message- From: Pardeep Singh [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 03, 2001 3:11 PM To: CF-Talk Subject: Re: Insert error (String data right tr