You also have the option.. of @@IDENTITY.. if you are SQL Server...
and it autmatically incremented...can remember what it is on Oracle.
Cfquery...
insert into... whatever
select @@IDENTITY as MAXID from tableName
Joe
-Original Message-
From: Bryan Love [mailto:[EMAIL PROTECTED]]
Wouldn't it be easier to just make the link go to a page on your website
that can then record the click, figure out where to go and then redirect to
whereever you want to go?
The downside to using the idea below is that it will slow down the
original page from loading especially when your
On Wednesday, September 18, 2002, at 07:44 PM, Joe Eugene wrote:
instead of atypical test cases like looping a million times.
I think it's more than equal in its competitiveness with other web
application servers. The fact is, most business apps aren't doing
the sorts of calculations that
Aw, 'cmon Ben, one of the great advantages of CF is it can address a
broad range of applications -- all Joe wants do to is extend the range
help MM sell into a broader range of solutions.
Will MM get them all? --Never!.Can MM get more? All of us
certainly hope so!
What if optimizing
Dick,
Oh, I agree. CF should keep getting better (and I believe it has been
doing just that).
My only point is that they'll always be a better way to do something,
whether it is a small piece of code or a complex process, and whenever
that is the case the solution is to use the right add-on or
Issac,
I hope you understand that CURSORS are not the FASTEST thing
in SQL Server.. i have personally written many cursors apps to
do BATCH Processing.. but i wouldnt recommend SQL Server Cursors
for a REAL TIME processing.. Well in Oracle its a different Story...
Depends on the DB. I agree T-SQL
At 11:17 PM 9/18/2002 -0400, Ben Forta wrote:
So, yep, suggestions on how to improve CF are useful, and we'll keep
doing just that. Just don't expect CF to do it all, it can't and frankly
it shouldn't.
--- Ben
Yet
C'mon Ben! :)
~Todd
Todd Rafferty ([EMAIL PROTECTED])
Yea!!! thanks a lot Ben .
We are looking forward to any improvements...and will defnitely brag on it..
when its out...
Oh, I agree. CF should keep getting better (and I believe it has been
doing just that).
So, yep, suggestions on how to improve CF are useful, and we'll keep
doing just
Issac,
Isaac actually...
I hope you understand that CURSORS are not the FASTEST
thing in SQL Server..
Absolutely... i use them ever so sparingly...
i have personally written many cursors
apps to
do BATCH Processing.. but i wouldnt recommend SQL Server
Cursors
for a REAL TIME
We combine CF and ASP for processing and use Recrystallize as a productivity
tool. It generates the web pages. We only use the asp processing pages. The
input forms which need, in our case, to be very dynamic and based on other
systems with varying security are done with CF. Note that we have
On Wednesday, September 18, 2002, at 08:17 PM, Ben Forta wrote:
Dick,
Oh, I agree. CF should keep getting better (and I believe it has been
doing just that).
I've been on board since 3.0 and I totally agree -- the books are
getting so big (and the type so small) I can hardly lift or read
But then, to know for sure, we'd have to load test both. :)
Am getting Brain Farted with all the testing am doing...
Nah..NOT Another One :)
Joe
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 11:41 PM
To: CF-Talk
Subject:
What makes this so compelling (and so frustrating) is that we all are
on the same side!
Dick
On Wednesday, September 18, 2002, at 08:34 PM, Joe Eugene wrote:
Yea!!! thanks a lot Ben .
We are looking forward to any improvements...and will defnitely brag
on it..
when its out...
Oh, I
No particular wisdom to impart -- I just wanted to post to this thread
that is using so much bandwith that could otherwise be devoted to the
Re: Jsp Vs Cfm (CFMX) -- Test Code thread-- %-0)
Apologize in advance!
Dick
__
I hope MM DOESNT need a better reasoning to impove CFMX than the below.
Gosh, we are trying to help improve CFMX..!
Well said Dick..
I've been on board since 3.0 and I totally agree -- the books are
getting so big (and the ***type so small) I can hardly lift or read
them!
The same is
Well... I think I've gone through all of my ask these first questions.
The only other thing I can think of is a code review of the complete code.
Dunno.
--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 625-9191
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/
-Original
On Wednesday, September 18, 2002, at 05:26 , Tony Weeg wrote:
no dice, flash movie just doesn't load, only get
broken image looking thing. guess it cant find
the codebase on the server that is referenced in
the flash-html code when using https://
Sorry... we're fixing it!
My team is
On Wednesday, September 18, 2002, at 01:12 , Jochem van Dieten wrote:
That would make ColdFusion quite a different language! :)
Would it? Doesn't for instance cfparam do type checking?
As Matt correctly pointed out, cfparam is runtime validation not
compile-time type checking.
It turns out
Hi All
Our site users are entering text into a Textarea field and we are finding
that if they hit enter twice they get a new paragraph but if they only hit
enter once it looks like a new line (in the textarea box) but when it is
displayed on another page within a #ParagraphFormat()# tag the
I use this (that I got from this list some months ago)
This before UPDATE or INSERT:
cfset my_text = #ReplaceList(my_text,#Chr(10)#,#Chr(10)##Chr(13)#,
BR,P)#
This before showing in FORM and/or final page:
cfset my_text =
#ReplaceList(my_text,BR,P,#Chr(10)#,#Chr(10)##Chr(13)#)#
Seamus
Sean,
I would love to see this happen... an option to declare Types...
same a locksnothing is enforced.. kinda deal..
Yes, it's certainly one possible approach, allowing the user to declare
variables with a type (and extending the CF types to include integer
would also be a useful
Would the below be an easy change in CFMX?
cfset int foobar = 1
or
cfscript
int foobar = 1;
/cfscript
Would declare a coldfusion.runtime.Integer instead of the following.
cfset foobar = 1
or
cfscript
foobar = 1;
/cfscript
Would declare a coldfusion.runtime.Variable.
Joe
Jeez. Well, I can't see any problems in the code that you posted.
If you try to CFOUTPUT FORM.FormFields, what does it give you? And, if it
gives you a list as you would expect, try iterating over that list,
evaluating each one as in:
CFIF IsDefined(FORM.FormFields)
I am not sure that is entirely correct.
I use evaluate() and de() and it works fine.
cfoutput#evaluate(de(getContentTypes.CTEmailTemplate))#/cfoutput
It is not fast but definetly works. evaluate() and de() together are really
slow, but they work even with HTML tags in the database.
example:
Hal Helms wrote:
I haven't tried this trick with CFMX, but 18 months ago or so, Rick Moon
and I were faced with this problem: the situation required a LOT of code
to be stored in the DB and then executed dynamically. That meant writing
and then reading a file, which I was very concerned with
Use a database. SELECT Now() AT TIME ZONE '#your_time_zone#' AS MyTime
It is part of SQL-92 and it handles DST and dates correctly.
IRL YMMV
Jochem
__
Your ad could be here. Monies from ads go to support these lists and
Sean A Corfield wrote:
On Tuesday, September 17, 2002, at 09:41 , Dick Applebaum wrote:
Rather I suggest that CFMX allow us to tell it a variable's type
(optionally) so that it can use that to generate efficient code,
That would make ColdFusion quite a different language! :)
Would it?
Matt Liotta wrote:
Every idea/technique that has been suggested thus far for code
optimization is a waste of time for almost all applications. Sure some
of these ideas/techniques code save a few milliseconds here and there,
but they offer very small gains in scalability. There are much
It really sounds like an intelligent, well-thought-out concept
It sounds like a service pack with a different name.
Thomas Chiverton
__
Structure your ColdFusion code with Fusebox. Get the official book at
S. Isaac Dealey wrote:
Yea, it turned out to be the cf_sql_date that was causing the wrong number
of parameters error message... so changing that to cf_sql_timestamp solved
the problem... Better support for cfstoredproc ( naming and better error
handling in particular. ) would be _great_ to
What DB are you using?
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 4:08 AM
To: CF-Talk
Subject: Re: Timezones and CF
Use a database. SELECT Now() AT TIME ZONE '#your_time_zone#' AS MyTime
It is part of SQL-92 and it handles
I have to say I've never grasped what de() actually does!
:-(
- Original Message -
From: Shlomy Gantz [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, September 18, 2002 10:47 PM
Subject: RE: run CF from db
I am not sure that is entirely correct.
I use evaluate() and
Just curious, has anybody tried mac-on-linux(http://maconlinux.org)...it
supports OSX.
-Original Message-
From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 12:01 AM
To: CF-Talk
Subject: Re: For Jesse
Absolutely--- Not!
I once ragged a contemporary
It's main use is within IF and Evaluate, preventing them from treating
strings as expressions and trying to evaluate them (hence the name : delay
evaluation).ColdFusion will try to evaluate anything within pound signs
first, using DE() allows you to have it evaluate the internal parts
surrounded
Thanks Shlomy.
- Original Message -
From: Shlomy Gantz [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, September 19, 2002 3:25 AM
Subject: RE: run CF from db
It's main use is within IF and Evaluate, preventing them from treating
strings as expressions and trying to
ok.
uninstall flash player, go back to page
https://www.navtrak.net/login.html
no dice, flash movie just doesn't load, only get
broken image looking thing. guess it cant find
the codebase on the server that is referenced in
the flash-html code when using https://
so, what the F!
microsoft
I don't like or hate any of them, does that just make me an l-user?
Use the right tool for the job.
-jesse
-Original Message-
From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 17, 2002 8:39 PM
To: CF-Talk
Subject: For Jesse
BSD is for people who love Unix.
Hey all!
Just wondering if anyone might have any suggestions on what to look for
in troubleshooting why my MX server freezes up each day. (Win 2K, 1 GB
RAM, tons of free HD space - a brand new system.)
It's a dedicated server, only this one application running.
It is a kind of Enterprise
While locking the applications doesn't hurt, I think you should lock the
cffile process (with named locks) when writing to the log file. This way you
are single threading access to the file.
Marius Milosav
www.scorpiosoft.com
It's not about technology, it's about people.
Virtual Company (VICO)
Perhaps you should start doing some testing... and come with some numbers.
Would it? Doesn't for instance cfparam do type checking?
Besides, I don't see much difference with using var to declare a non
typed variable to be local inside a function and to use int to declare
a variable to be an
Sorry Jesse
I apologize!
No offense meant!
You have been a strong advocate of Linux on this list, and I hoped you
would get a laugh out of the quote -- as I did!
Dick
On Wednesday, September 18, 2002, at 05:28 AM, Jesse Noller wrote:
I don't like or hate any of them, does that just make
Obviously I shouldn't send emails before my morning dosage. I was joking with ya Dick,
no offense taken.
Jesse Noller
[EMAIL PROTECTED]
Macromedia Server Development
Unix/Linux special guy
But I ned tacos! I need them or I will
explode! That happens to me sometimes! -GIR
-Original
I am wondering if there is a way to put a CFMail inside of the error
page that CF generates?
That way we can be notified if an error occurs on the web site, and
email the exact error.
Is the error page a CF template? Is it encrypted?
We tried wrapping all of the pages with cftry/cfcatch in
I have a few sites that do this...
In your application.cfm file put something like
cfapplication name=Builda
clientmanagement=Yes
sessionmanagement=Yes
setclientcookies=Yes
!---
cferror type=REQUEST template=ALLERRORS.cfm
cferror type=EXCEPTION
Hi Chad,
This works well for us in CF 5. Just make absolutely sure that this code is
error free after you edit it - otherwise it loops and getting 2,000 error
e-mails is no fun :) :
cfset errorto = your e-mail here
cfset errorfrom = replyto here
cfset errorsubject = DB error
cfset errortourl =
Hi Stace,
thanks for your input and offer to help testing this. I'll need one week or so before
sharing it. I'll keep you posted.
Regards,
Marcello.
Well one thing I can tell ya...dunno if it applies in your case but CFLDAP
does not function properly against an Active Directory under SSL
Can soemeone send me a query of a query examples... I need to write one
and I cant remember the syntax (working off site today so I don't have
any of my code handy.
Thanks!!
Kris Pilles
Website Manager
Western Suffolk BOCES
507 Deer Park Rd., Building C
Phone: 631-549-4900 x 267
E-mail: [EMAIL
But Matt's point is extremely valid and I think a technique way to many
developers overlook too consider with keeping the code dynamic.
Caching can mean many things, on a heavily trafficked site, cache
portions of content for seconds can increase performance of the box
tenfold, without losing the
Beware: cfloginuser does not work outside cflogin! It
seems to for the page you are on but it does not
maintain the information beyond that single page
invocation. That might be part of your problem.
I intentionally set the cfloginuser / outside the cflogin because I
want the user
Ok, I have installed CFMX on 5 or 6 systems, all without a hitch. Now I go
out to a client location today and attempt to install CFMX on an
NT4(6a)/IIS4 system and everything goes totally haywire.
Problem one: During installation, after choosing all the options, entering
the serials etc, it
cfquery dbtype=query name=subQuery
-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: 18 September 2002 14:51
To: CF-Talk
Subject: Query of query examples
Can soemeone send me a query of a query examples... I need to write one
and I cant remember the syntax (working
This works well for us in CF 5. Just make absolutely sure that
this code is
error free after you edit it - otherwise it loops and getting 2,000 error
e-mails is no fun :) :
Just add
cfif cgi.CF_TEMPLATE_PATH does not contain error.cfm
to the top and a /cfif to the bottom :-)
I wondered how the code ran. :)
-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 9:09 AM
To: CF-Talk
Subject: RE: CFmail inside of CF error page
This works well for us in CF 5. Just make absolutely sure that
this code
The error is:
error expected ';'
If I try top run it I get:
a.temp1 is not defined
Here is the code:
CFQUERY NAME=search DATASOURCE=brinventory
SELECT DISTINCT lookup.type
FROMsteel, lookup
WHERE steel.type_id = lookup.type_id
/CFQUERY
CFQUERY NAME=search2
I wondered how the code ran. :)
Just add
cfif cgi.CF_TEMPLATE_PATH does not contain error.cfm
Of course, use cgi.http_referer if you don't cfinclude but cflocate your
error pages ;-)
__
Structure your ColdFusion code
The error is:
error expected ';'
From which line ?
What happens if you save the output as a html page and view that - I find
that a useful way of debugging CF generated javascript. ?
Thomas Chiverton
__
This list and all
Wow. Sometimes it's staring you right in the face...
Thanks for the help!
-Original Message-
From: Chad [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 7:17 AM
To: CF-Talk
Subject: RE: CFmail inside of CF error page
I wondered how the code ran. :)
-Original
Curious as to what everyone is using for IIS 5 and a error-redirect
processor? IEP was something many of us used for redirecting 404 (and
other) errors in Website Pro. But with IIS.. What are y'all using?
TTAIA
__
Structure
line 5 char 22
-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 9:24 AM
To: CF-Talk
Subject: RE: OT problem with Javascript..
The error is:
error expected ';'
From which line ?
What happens if you save the output as a html page
I've got a structure in the Application scope that I use to store different
types of information, depending on circumstances.
When the structure's contents need replacing, I just initiate the process
with
cfset myStruct = StructNew()
My question is: if 'myStruct' already contains a set of
Hi -
I could really use some help getting at a query result in round about ways.
Someone suggested to me that I could use array syntax to do this. Something
along the line of:
cfquery name=foo .../cfquery
cfoutput query=foo
#foo[1]#
/cfoutput
This doesn't work (just an example of
I doubt anyone outside of Macromedia can answer that.
Matt Liotta
President CEO
Montara Software, Inc.
http://www.montarasoftware.com/
888-408-0900 x901
-Original Message-
From: Joe Eugene [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 17, 2002 11:41 PM
To: CF-Talk
Subject:
Would it? Doesn't for instance cfparam do type checking?
But it doesn't do type checking; it does type validation. This was
discussed a while back during a CFC thread where I explained why CFCs
don't do type checking either.
-Matt
Use bracket notation:
cfset col = 1
cfoutput#foo[col][1]#/cfoutput
===
Raymond Camden, ColdFusion Jedi Master for Hire
Email: [EMAIL PROTECTED]
Yahoo IM : cfjedimaster
My ally is the Force, and a powerful ally it is. -
I'm developing a shopping cart. Can anyone give me some ideas as to how to
calculate shipping? I know the first question is going to be Who is doing the
shipping?. The answer to that is I don't know. Whoever the owner of the
shopping cart wants. It could be UPS, Fed Ex, USPS...If there are
structNew will kill the old data.
===
Raymond Camden, ColdFusion Jedi Master for Hire
Email: [EMAIL PROTECTED]
Yahoo IM : cfjedimaster
My ally is the Force, and a powerful ally it is. - Yoda
-Original Message-
Replace this #type# with #trim(jsstringformat(type))#
That may solve the problem
-Original Message-
From: Webmaster [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 10:36 AM
To: CF-Talk
Subject: RE: OT problem with Javascript..
line 5 char 22
-Original Message-
In working with our MX development server (Win2K w/.NET framework), I've
noticed a problem with cached errors with stored procedures (oracle db).
Here's what I've determined so far:
1. If I run a .cfm page that calls a sp, and an error is returned (usually due
to some programming error, like
line 5 char 22
Which is ?
With some context ?
Thomas Chiverton
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ:
As you said it yourself (it was you, right?) there is a difference
between performance and scalability. And I think most people are
discussing performance here.
There is a difference between performance and scalability and most
people are discussing performance, which is my point. If people
The
variable foo.1 is illegal in ColdFusion.
cfset foo.1 =rar
cfoutput#foo.1#/cfoutput
Works fine here on MX.
The syntax you want is like qQuery.columname[index] i.e. qList.1[1]
Thomas Chiverton
__
Your ad could be
You are giving reasons that it would be hard to do it right --
admittedly true! However the question should be: is it worth doing?
Not today or tomorrow, but whenever it makes sense for competitive,
sales and technical reasons!
Good Point..
We all love CF and CF has come a long way to a
Check these links out.
http://www.ec.ups.com/ecommerce/solutions/c1.html#tools
https://www.fedex.com/solutions/go/Overview?link=4#shipping
http://164.109.64.180/front2.asp --- usps
-Original Message-
From: Yager, Brian T Contractor/Sverdrup
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday,
Try javacast, which is a new function in cfmx
cfscript
x = 1;
y = javacast(int,x);
/cfscript
-Original Message-
From: Matt Liotta [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 10:30 AM
To: CF-Talk
Subject: RE: Jsp Vs Cfm (CFMX) -- Test Code
I doubt anyone outside of
It sounds like you are having the same problem I had yesterday. Make sure
that your Trusted Cache is turned off in the CF admin.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 10:18 AM
To: CF-Talk
Subject: Cached Stored Procedure
There are many ways to create shipping modules and methods for calculating
shipping. Take a look at a few different shopping cart programs and see how
they are implementing shipping. SiteDirector has a pretty robust amont of
choices in our v2.0 and even more in v3.0...
We came up with various
I know that UPS bases shipping charges on shipping type (overnight, ground,
etc), destination (in the US based on zip), weight, whether the destination
is commercial or residential, and box size.
Generally, if the box is not defined as oversize, you can ignore it.
So, if you know the zips of
cfset foo.1 =rar
cfoutput#foo.1#/cfoutput
The same code breaks CF5. It's cool that it works on CFMX. I haven't had a
chance to use MX yet, but it sounds like the parser is a little more
forgiving.
Thanks for the correct syntax (and also from the earlier post from Raymond)!
-Original
Is there a way to write a MSSQL 2k query that will return a result set that
contains only columns with null values when you don't know explicitly which
columns those will be?
So if I have this data
pk | col 1 | col 2 | col 3 | col 4|
1 1 2nullnull
2null4
We've used the CFINTERSHIPPER tag from Michael Sheldon before. The
Intershipper service is a supports UPS, FedEx, US Postal Service, Airborne,
Bax Global, DHL, Emery, and Airnet.. The service seemed to be down quite a
bit during the three years we used it, but it was nice. We could let the
I use... don't hate me Acesss! For the scale of things it's fine..
I used the code...
cfset austime= #now()# + #createTimeSpan(0,8,0,0)# from Michael Kear...
and it's worked fine... with the time dunno about the day yet... but he says
it works.
What DB are you using?
Is there any way to get the directory that a custom tag is in
and use that info IN the custom tag itself when called with CFmodule?
I have a tag that plays two roles-
first its a custom tag that generates some code in the calling
template
second it is an html page that gats called into a
The only thing I can think to do is create a bunch of OR statements i.e.:
WHERE colA IS NULL OR colB IS NULL OR colN IS NULL
~Simon
Simon Horwith
Macromedia Certified Instructor
Certified Advanced ColdFusion 5 Developer
Fig Leaf Software
1400 16th St NW, # 220
Washington DC 20036
JavaCast isn't new for CFMX as it has been around since CF 4.5. Its
purpose is for helping CF determine which method to call in Java classes
that have overloaded methods.
Matt Liotta
President CEO
Montara Software, Inc.
http://www.montarasoftware.com/
888-408-0900 x901
-Original
When you say none of the other pages will load, what error are you getting?
Also this an ugrade or clean install?
Were all other installtions the same - upgrade or clean install?
- Original Message -
From: Cameron Childress [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent:
How do you send the email? I am not sure if this is a MX thing, but the
ALLERRORS.cfm page in your example cannot run any CF code. It ignores
tags like CFMail.
-Original Message-
From: Mark Stephenson - Evolution Internet
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18,
Hey everybody
The boss wants to know what the advantages are for running CFMX on
Win2K vs. Linux and vise-versa.
Any good websites, or is this one of those Check the archives you
fool questions?
;) (lol)
Candace K. Cottrell, Web Developer
The Children's Medical Center
One Children's Plaza
Thanks, but that doesn't get me where I want.
I ONLY want to return the columns that ARE null, and I never know which ones
those are when I run this query... so what I need is something for the
select statement.
-Patti
- Original Message -
The only thing I can think to do is create a
Hi I have a client who wants other poeple to like to their site - but I want
to be able to control it to a certain degree - because once they have copied
and pasted the link I have little control apart from atering the graphic -
is there a way I can embed some javascript or something - that will
GetCurrentTemplatePath(), or a similar CF function?
Chris Norloff
-- Original Message --
from: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
date: Wed, 18 Sep 2002 10:58:11 -0400
Is there any way to get the directory that a custom tag is in
and use that
Why does this work? Variables and structure names have never been able
to start with number before. Is CF looking at the number and making
foo an array or what?
I don't have an MX box handy right now or I would test it...
--
jon
mailto:[EMAIL PROTECTED]
Wednesday, September 18, 2002,
Find out what the shipping charges/criteria are and write a function. Then
call the function.
On Wed, 18 Sep 2002, Yager, Brian T Contractor/Sverdrup wrote:
I'm developing a shopping cart. Can anyone give me some ideas as to how to
calculate shipping? I know the first question is going to
Erm... I wrote the sites when using 4.5... Now using 5... I'll test see if
it still works!!!
Does it ignore CFINCLUDE???
Mark Stephenson
New Media Director
Evolution Internet
T: 0870 757 1631
F: 0870 757 1632
W: www.evolutioninternet.co.uk
E: [EMAIL PROTECTED]
This email, together with any
I defined a datasource using the Merant text file driver. What do I use for table
names in the where clause of my query? What would it be if I used the MS driver?
TIA
Sam
Changed your e-mail? Keep your contacts! Use this free e-mail
SELECT CASE WHEN pk = 1 THEN col3 END AS newcol1,
CASE WHEN pk = 1 THEN col4 END AS newcol2,
CASE WHEN pk = 2 THEN col1 END AS newcol1,
CASE WHEN pk = 2 THEN col2 END AS newcol2
FROM mytable
-Original Message-
From: Patti G. L. Hall
How about this or am I still missing something
Select * from TABLENAME
WHERE col1 IS NULL OR col2 IS NULL OR col3 IS NULL OR col4 IS NULL
Candace K. Cottrell, Web Developer
The Children's Medical Center
One Children's Plaza
Dayton, OH 45404
937-641-4293
http://www.childrensdayton.org
I have just found this... and this is the kind of thing I am looking for a
way of using Javascript to call a cfm file
http://fuselets.com/cftips/index.html
__
Get the mailserver that powers this list at
Initially it was an upgrade - now I've wiped the old version 4.5 off (client
had it) and have tried a number of times from scratch. I have a feeling
that if I could get beyond the Error 1303 : The Installer has insufficient
privileges to access this directory when installing the CFIDE. I'm
How can I restrict IIS access to 127.0.0.1 only running wk2pro?
Dave
HTC Disclaimer: The information contained in this message may be privileged and
confidential and protected from disclosure. If the reader of this message is not the
intended recipient, or an employee or agent
Actually I started poking around the MX directories and found this
folder:
\CFusionMX\wwwroot\WEB-INF\exception
It appears that all the error templates are open source. I going to
start playing with them and see if I can get the results I want.
-Original Message-
From: Chad
1 - 100 of 287 matches
Mail list logo