Hi Bill
Don't you have to have the file name in the file path
ie
file="c:\inetpub\wwwroot\myfolder\myfile.txt"
Seamus
You wrote
Greetings,
>>
>>I am trying to execute cffile
>>
>>
output="my string" addnewline="Yes">
>>
>>which is producing this error:
>>
>>Erro
Greetings,
I am trying to execute cffile
which is producing this error:
Error processing CFFILE
Error attempting to write data to target file 'c:\dbase\book.htm'.
Error: No error occurred.
I'm operating CF 4.5 on XP Pro and have been using it for several years since release and have never
I want to set up a new site that will be for a band, does anyone know of
any good:
1) Calendar applications for scheduling
2) Image gallery applications
3) Bulletin Boards
Been a while I looked at new tools, so I wanted to get the communities
input for eval purposes.
For example I like YaBB f
On Jul 9, 2004, at 8:17 PM, Claude Schneegans wrote:
> >>but I would also like to
> see it on a more-granular level:
>
> This would be more difficult to implement, since the status of a
> variable would not be proper only to the variable, but would also
> depend on its environment.
Yeah, I gu
>>but I would also like to
see it on a more-granular level:
This would be more difficult to implement, since the status of a variable would not be proper only to the variable, but would also depend on its environment.
--
___
REUSE CODE! Use custom tags;
See htt
> Yes, such a setup makes a server a vector in TRACE based
> cross domain exploits of certain browsers. Too bad for those
> that choose to use such browsers.
You, sir, are a cold-hearted man.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Toda
Dave Watts wrote:
>> IIRC the combination of IISLockDown and execute permissions
>> causes such problems. That's why I lock down IIS with my own
>> scripts and don't use IISLockDown or URLScan.
>
> I like URLScan, myself. Out of curiosity, do you use another ISAPI input
> filter instead?
No. I
> I just noticed that IIS5 considers directories that end in an
> extension which is also used for commands (.com or .exe) to
> be executables and not directories. This means you can't
> name a directory "123.com", which kinda sucks as I like
> naming my directories after the domain name. Doe
> I think I'll be able to come up with some good reasons, e.g.
> we wouldn't have been hacked in April if we weren't using
> IIS (!).
If you were hacked in April, it might have been because you didn't configure
IIS properly, not just because you were using IIS.
Dave Watts, CTO, Fig Leaf Softwar
> IIRC the combination of IISLockDown and execute permissions
> causes such problems. That's why I lock down IIS with my own
> scripts and don't use IISLockDown or URLScan.
I like URLScan, myself. Out of curiosity, do you use another ISAPI input
filter instead?
Dave Watts, CTO, Fig Leaf Softwar
On Jul 9, 2004, at 3:12 PM, Claude Schneegans wrote:
> >>1) all typed variables could be referenced w or w/o the "typed" scope
> >>2) in a block of strongly-typed code the "typed" scope would implied
> >>(roughly analogous to Java's import statement)
> >>3) Then The CF parser/compiler would hav
>>1) all typed variables could be referenced w or w/o the "typed" scope
>>2) in a block of strongly-typed code the "typed" scope would implied
>>(roughly analogous to Java's import statement)
>>3) Then The CF parser/compiler would have a set of readily-identifiable
>>strongly-typed variables, that
On Jul 9, 2004, at 5:47 PM, Barney Boisvert wrote:
> In 6.1, it converts CFML directly to bytecode, bypassing Java
> completely. This is significantly faster, as evidenced by the lack of
> a first-view delay.
Yeah, I definitely noticed this when we upgraded last week to 6.1 - it
screams!
--
D
6.0 converted CFML to Java, and then used a standard Java compiler to turn
it into bytecode, followed by deleting the java source. That was the reason
for the significant delay when viewing a page for the first time. In 6.1,
it converts CFML directly to bytecode, bypassing Java completely. This
Wait. Early adopters might get cool tools, but they also get lots of
headaches. And when you're learning a new language, headaches are the last
thing you want.
Cheers,
barneyb
> -Original Message-
> From: Dick Applebaum [mailto:[EMAIL PROTECTED]
> Sent: Friday, July 09, 2004 2:29 PM
>
On Jul 9, 2004, at 12:00 PM, Samuel Neff wrote:
> With 6.1 you have to decompile the generated class files. There are
> lots of
> tools to do that. Google.
Ahh... I was hopin' ya' knew of some way to get CF to gen source, like
it did in 6.0.
I wonder if there is an under-the-covers option t
I am in the process of learning Java on version 1.4.2). Sun has a
beta of Version 1.5 & Apple has a pre-release distro of 1.5 Release 1.
Any reason to install this, or should I wait for a more mature distro?
TIA
Dick
"In times like these, it helps to recall that
there have always been times
Damien McKenna wrote:
> I just noticed that IIS5 considers directories that end in an extension
> which is also used for commands (.com or .exe) to be executables and
> not directories. This means you can't name a directory "123.com",
> which kinda sucks as I like naming my directories after th
On Jul 9, 2004, at 5:15 PM, Barney Boisvert wrote:
> You can use apache on windows. Works like a champ. Haven't used IIS
> in
> years.
I've used it before but wasn't 100% happy. I could try again, I
suppose. Right now one of our key sites is ASP, though, but that'll
change to CFML by next m
On Jul 9, 2004, at 5:19 PM, Mark A. Kruger - CFG wrote:
> Um I name my directories "blah.com" all the time without issue.
> Can you give an example? How is it that you think
> this?
Doh!
I forgot one key aspect...
If I access the directory using a URL that does not contain the
directory na
You can use apache on windows. Works like a champ. Haven't used IIS in
years. Can't help you with policy, of course.
Cheers,
barneyb
> -Original Message-
> From: Damien McKenna [mailto:[EMAIL PROTECTED]
> Sent: Friday, July 09, 2004 2:05 PM
> To: CF-Talk
> Subject: OT: IIS considers "
Has anyone tried using Access files on UNIXes (Linux, FreeBSD, yadda)
that had linked tables, and if so did they still work?
--
Damien McKenna - Web Developer - [EMAIL PROTECTED]
The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
"Nothing endures but change." - Heraclitus
[Todays T
Um I name my directories "blah.com" all the time without issue. Can you give an example? How is it that you think
this?
-Mark
-Original Message-
From: Damien McKenna [mailto:[EMAIL PROTECTED]
Sent: Friday, July 09, 2004 4:05 PM
To: CF-Talk
Subject: OT: IIS considers "blah.
I just noticed that IIS5 considers directories that end in an extension
which is also used for commands (.com or .exe) to be executables and
not directories. This means you can't name a directory "123.com",
which kinda sucks as I like naming my directories after the domain
name. Does MS have
okay, so perhaps not so thoroughly. :)
but according to Forta the difference was minimal. Unfortunately I
can't seem to find the article now... it seems like I remember seeing
it in CFDJ though I could be misremembering. I didn't find it either
in the cfdj archives or on his blog. But I remember r
> S.Isaac Dealey wrote:
>> There are still a few things that are difficult (if not
>> impossible) to
>> accomplish with cfscript in spite of cffunction tags...
>> such as a
>> generic cfscript equivalent of cflock. Obviously there's
>> no equivalent
>> to cfsavecontent, and just plain forget using
If anyone get success to install this CFX can explain here, I am also trying to install it but its stuck on this error
Error processing CFX custom tag "CFX_ExcelQuery".
The CFX custom tag "CFX_ExcelQuery" was not found in the custom tag database. Please be sure to add custom tags to the database
> The script page generated a 51 line java file, 2 imports, and
> actually quite easy to read along to.
>
> The tags page generated an 89 line .java file, 5 imports,
> fairly difficult to read, but I noticed it kept mentioning
> whitespace chars, even though whitespace management was off.
>
>
> I like to run a cfmx template on dos command line. The file
> to run for CF5 is cfml.exe. What is the executable file to
> run for CFMX.
To the best of my knowledge, there is none. I generally use wget for this -
it's a command-line HTTP client.
Dave Watts, CTO, Fig Leaf Software
http://www
ugh, is the generated Java code really 'your code' The CFML is, but is the Java code generated by CF yours? The Macr tool created that code, not you. probably a big firebreathing discussion best left to cf-talk though, eh?
Doug
-Original Message-
From: Samuel Neff [mailto:[EMAIL
Well, I bit the bullet and tried it out. I made this page in CF:
var1 = "hello";
var2 = structNew();
var3 = arrayNew(1);
var3[1] = var2;
var3[1].var4 = var1;
for(i=1;i lte arrayLen(var3);i=i+1) {
writeOutput("hello " & i);
}
and this page:
hello #i#
Same thing, ju
has anyone done this?
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Hi,
I like to run a cfmx template on dos command line. The file to run for CF5 is cfml.exe. What is the executable file to run for CFMX.
Thanks
Sam
---
[This E-mail scanned for viruses.]
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and S
With 6.1 you have to decompile the generated class files. There are lots of
tools to do that. Google.
It's your code, so I'm pretty sure there are no legal issues. Besides, it's
a good debugging tool and always good to know what's going on to help with
optimization.
Sam
-Original Message-
lol. Exactly! And it's always something small like a comma or a
semi-colin. Those little sneaks!
Congrats on figuring this out.
-Jordan
--
Warm regards,
Jordan Michaels
Vivio Technologies
http://www.viviotech.net/
[EMAIL PROTECTED]
Seth Petry-Johnson wrote:
> >I think this may be caused by
My wife and I will be moving to the Canterbury / Kent area in late August. I should be available for contracts/job offers early September. I'm currently scouting some companies as the moment, would appreciate any help through the list.
Cheers
[Todays Threads]
[This Message]
[Subscription]
[
>I think this may be caused by a limitation in the maximum file
> size for CF files under CFMX.
I should have mentioned that I read about that also, and tried splitting the file up into seperate includes, but that didn't work either.
However, I finally figured this out just a few minutes ago. I
On Jul 9, 2004, at 7:35 AM, Samuel Neff wrote:
> You don't need access to the CFML source code to see how strong
> typing can
> benefit CF and how it can be implemented--only need to look at the
> Java
> files generated by CFMX.
How do you do that with CFMX 6.1 -- all I can get is the class
> I have a large (130k) query module that searches a database
> of songs according to supplied criteria. Its so large
> because there is seperate query and ranking logic for many
> types of queries: artist only, song only, artist and song
> together, etc, etc.
>
> Under MX 6.1, when I call th
MSSQL has Data Transformation Services. It can bring in data from lots of
different datasources. Should work with MySQL.
Sam
-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED]
Sent: Friday, July 09, 2004 2:08 PM
To: CF-Talk
Subject: Re: convert MySQL to MSSQL?
Damien,
Recently I tried upgrading my production server (CF 5) and my development box (CFMX) to the new CFMX 6.1. On both servers I hit the same problem.
I have a large (130k) query module that searches a database of songs according to supplied criteria. Its so large because there is seperate query and
Hey All,
First, I'm posting this for a friend, so my knowledge is a bit limited.
My colleague is trying to gauge how much interest there is in a ColdFusion
and Crystal Enterprise Integration widget/web service/consulting. What he's
explained is, that if you can do it in ePortfolio or the Crystal
Damien,
I do this in the other direction (into mySQL) all the time via
mySQLFront, which preserves all characteristics, indexes etc. Doesn't
SQL Server have similar functionality?
There is a way to back-door this, maybe:
set up your mySQL db as an odbc database. Then use Access to do an
ODBC im
This has to be something set by the mail server as CFPOP usually gets
the first chronological message first.
- Original Message -
From: Graham Lewis <[EMAIL PROTECTED]>
Date: Fri, 09 Jul 2004 18:46:20 +0100
Subject: CFPOP 100 message limit
To: CF-Talk <[EMAIL PROTECTED]>
I see that when I
S.Isaac Dealey wrote:
> There are still a few things that are difficult (if not impossible) to
> accomplish with cfscript in spite of cffunction tags... such as a
> generic cfscript equivalent of cflock. Obviously there's no equivalent
> to cfsavecontent, and just plain forget using query grouping
The mail server is probably limiting the mail to batches of 100. Also - if you want to keep things in synch you should use UID as this is guarnateed to be unique.
HTH,
- Original Message -
From: Graham Lewis
To: CF-Talk
Sent: Friday, July 09, 2004 1:46 PM
Subject: CFPOP 100
I see that when I CFPOP my mail server, I always get the last 100 messages. Not sure if this is set by the server or is something I can set via Cold Fusion. Either way though there is a problem that if I refer to messages via MESSAGENUMBER, this can change between grabbing them and deleting them
I've got a PHP tool that currently uses MySQL. Their new version
supports MSSQL, which we use for everything else, so I'd like to
migrate. Does anyone know of a _free_ tool to convert between MySQL
and MSSQL? There's one tool at http://www.convert-in.com/sql2mss.htm
but it isn't worth $40 fo
On Jul 9, 2004, at 9:39 AM, Jim Davis wrote:
> My impression from some of the people on the CF Development team is
> that
> this would be a nightmare to develop while maintaining backwards
> compatibility. Making the whole language typed, period, would be
> somewhat
> easier - but only in a
Indeed, many times have I wished that was not the case.
On Fri, 9 Jul 2004 13:03:00 -0400, S. Isaac Dealey <[EMAIL PROTECTED]> wrote:
> and just plain forget using query grouping for
> display in cfscript.
>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Sorry to say but he didn't. There was a debate and the bottom line was
that the savings were so small as to not matter much. There was a
difference and all you have to do is test it to see. As my article
said, the savings were in the fraction of a millisecond.
> IIRC Ben Forta debunked that on CF5
Isaac:
Where has this been "thoroughly debunked"?
- Original Message -
From: "S. Isaac Dealey" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, July 09, 2004 9:53 AM
Subject: Re: cfscript speed?
> It used to be rumored that cfscript was significantly more efficient
>
We use Visio.
Cary Gordon
The Cherry Hill Company
At 05:18 PM 7/8/2004, you wrote:
>All,
>
>I am looking for a tool/software so that I can create graphical
>respresentation of processes. I guess something like Visio.
>
>Any suggestions?
>
>Thanks,
>Troy
>
>--
>Troy Simpson
> Applications Anal
Are there any known problems with sessions in ColdFusion 6.1? I ask
this as I know there are with PHP sessions with IE 6 (maybe older
versions of IE too) and I'd like to cater for those in a new engine I'm
writing (multi-lingual, yummy!). Thanks.
--
Damien McKenna - Web Developer - [EMAIL PRO
There is a free Java decompiler called 'jad' available for download on the
net. It's not perfect, but in general, it does a pretty good job. I'm not
sure what the legal perspective on decompiling the CF-generated .class files
is, but that'd let you get at the java source on 6.1 as well.
Cheers,
In CF 5 it wasn't a rumor. In CFMX it seems to be
It used to be rumored that cfscript was significantly more efficient
than tags. With recent versions that rumor's been thoroughly debunked.
I don't know how much truth there was to it originally.
--
Michael Dinowitz
http://www.houseoffusion.com
F
There are still a few things that are difficult (if not impossible) to
accomplish with cfscript in spite of cffunction tags... such as a
generic cfscript equivalent of cflock. Obviously there's no equivalent
to cfsavecontent, and just plain forget using query grouping for
display in cfscript.
> On
IIRC Ben Forta debunked that on CF5 also...
> Pre CFMX there was a speed difference between CFSCRIPT and
> normal
> tags. If this speed difference still exists in CFMX is a
> point of
> debate with stats and evidence going both ways. You can
> read the
> original argument here:
> http://www.fusion
What is the easiest way to obtain the modification date of a file?
--
Damien McKenna - Web Developer - [EMAIL PROTECTED]
The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
"Nothing endures but change." - Heraclitus
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscri
On Jul 8, 2004, at 9:09 PM, S. Isaac Dealey wrote:
> >> I have my doubts. The closer CF comes to pure Java, the
> >> more people
> >> will ask "why bother when there's Java". In order to
> >> stay alive in the
> >> market (as with any market) CF has to provide something
> >> significan
If you looked at the Java generated by CFMX 6.0 from two templates of
identical logic -- one using CFML and the other using CFSCRIPT -- you could
plainly see the difference in efficiency. Each line of CFML-based logic was
wrapped in a Java do-while loop, while there was only a single do-while loop
It used to be rumored that cfscript was significantly more efficient
than tags. With recent versions that rumor's been thoroughly debunked.
I don't know how much truth there was to it originally.
> When I started my job in February I noticed a lot of code
> that used
> CFSCRIPT extensively, often
>>>In PHP you can define a variable and then define another
>>>variable to
>>>point to it, e.g.:
>>>$i = 123;
>>>$j = $$i;
>>>print $j;
>>>// output is "123"
> i = 123;
> j = "i";
> writeOutput(evaluate(j));
or that works too :)
s. isaac dealey 954.927.5117
new epoch : isn't it time for a ch
On Jul 9, 2004, at 5:54 AM, Dave Watts wrote:
> > Done right, CF doesn't need to give up anything to provide
> > optional support for strong typing any more than they had to
> > sacrifice anything to give us CFCs.
>
> How do you know this?
> We can all speculate on how easy or difficult somet
What Tony said.
Prior to CF6 there was supposedly a demonstrable speed increase for
blocks of code... but never, ever for just a single var assignment. I
like to use it where I can as its cleaner to read, especially if
setting a large block of variables.
--
--Matt Robertson--
MSB Designs, Inc
My impression from some of the people on the CF Development team is that
this would be a nightmare to develop while maintaining backwards
compatibility. Making the whole language typed, period, would be somewhat
easier - but only in a sense, as you would really just be ripping out the
massive amou
Pre CFMX there was a speed difference between CFSCRIPT and normal
tags. If this speed difference still exists in CFMX is a point of
debate with stats and evidence going both ways. You can read the
original argument here:
http://www.fusionauthority.com/Article1.cfm/ArticleID=2569
Note that this arti
On older versions of CF, doing I believe it was 5 or more sets on
variables would be faster when using a CFScript. I personally have
always tried to use CFScript for if/else, switch/case and variable
sets, mainly because I find it more readable than any other reason. I
do not use it for just one
pre cfmx days, some would say, cfscript was faster. with the advent
of compiled code, java bytecode in the background, some say its no
different now.
old style coders, like the script syntax, for readabilities sake.
tag style coders, like myself, certainly prefer tags to cfscript.
its all person
When I started my job in February I noticed a lot of code that used
CFSCRIPT extensively, often for minor things like setting a single
variable. Is there a reason why this would have been done? For
readability I've been changing them to the tag format.
--
Damien McKenna - Web Developer - [EMA
> I am looking around for a CF 4.5 workaround for CFCONTENT. I
> do not have the enterrpise version for sandboxes and I have
> seen the 5.0 workaround on the net but I do not believe it
> will work for 4.5 but I have not tried it.
I'm not sure what you mean by a workaround. Can you be more spec
>> Does CFML support variable variables?
>>
>> In PHP you can define a variable and then define another
>> variable to point to it, e.g.:
>>
>> $i = 123;
>> $j = $$i;
>> print $j;
>> // output is "123"
>>
>> Is there something similar in CFML? At a cursory glance
>> of
>> the books I have looks li
On Jul 9, 2004, at 10:59 AM, Aaron DC wrote:
> NB: As structures are by-reference variables (pointers!), you do not
> need to do this. Simply do:
> circuitlang = Application.language.circuitname;
> // circuitlang.stringname is now the equivalent of
> Application.language.circuitname.stringname
>
Aaron,
> INSERT INTO ()
> SELECT
> FROM <2.TABLE>
> WHERE
The WHERE clause of your example is tied to the sub-query that does the
SELECT. It is not part of the INSERT statement in your example. If you read
the MS SQL Books online and pay particular attention to the BNF
specification of the I
I am looking around for a CF 4.5 workaround for CFCONTENT. I do not have the enterrpise version for sandboxes and I have seen the 5.0 workaround on the net but I do not believe it will work for 4.5 but I have not tried it.
Thanks!
Kieran Mullen
[Todays Threads]
[This Message]
[Subscription]
Hey all,
"Faulting application jrun.exe, version 4.0.0.63824, faulting module
jvm.dll, version 0.0.0.0, fault address 0x0003cfd4."
I see this error about once every two weeks. I never, and neither has any
of my clients (i'm running approx 80 websites on my server), have noticed
this affect a
Yes, I have done this often, using evaluate. Don't tell anyone tho, as Evaluate is hated on for some reason, personally I love it.
An equivalent for your PHP code would be:
i = 123;
j = "i";
writeoutput(Evaluate(j));
// output is "123"
NB: As structures are by-reference variables (pointers!),
>>In PHP you can define a variable and then define another variable to
>>point to it, e.g.:
>>$i = 123;
>>$j = $$i;
>>print $j;
>>// output is "123"
i = 123;
j = "i";
writeOutput(evaluate(j));
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/cl
>Yes, you cannot specify a where clause in an insert. If you are updating
>a row then use update not insert.
>You can't have a where clause on an insert statement.
>Firstyl, you can't insert using a where clause are you wanting to do an
>UPDATE???
:)
It's late and I feel mischievous, so I will
> Does CFML support variable variables?
>
> In PHP you can define a variable and then define another
> variable to point to it, e.g.:
>
> $i = 123;
> $j = $$i;
> print $j;
> // output is "123"
>
> Is there something similar in CFML? At a cursory glance of
> the books I have looks like it isn'
> You don't need access to the CFML source code to see how
> strong typing can benefit CF and how it can be implemented--
> only need to look at the Java files generated by CFMX.
>
> If you look at these files you'll see how all variable
> references go through a complex set of Hashtable lookups
Dave,
You don't need access to the CFML source code to see how strong typing can
benefit CF and how it can be implemented--only need to look at the Java
files generated by CFMX.
If you look at these files you'll see how all variable references go through
a complex set of Hashtable lookups, custom
Does CFML support variable variables?
In PHP you can define a variable and then define another variable to
point to it, e.g.:
$i = 123;
$j = $$i;
print $j;
// output is "123"
Is there something similar in CFML? At a cursory glance of the books I
have looks like it isn't possible.
In my situa
On Thursday 08 Jul 2004 17:06 pm, Kim Mayhall wrote:
> Anyone have any ideas where to start looking to correct this problem?
A tcpdump / ethereal dump of the port 25 traffic to the mail server :-)
What happens if you just send to one at a time in the page ?
--
Tom Chiverton
Advanced ColdFusion
> You bulit this in Flash?
Yes.
Nick
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
You bulit this in Flash?
- Original Message -
From: Nick de Voil <[EMAIL PROTECTED]>
Date: Fri, 9 Jul 2004 11:43:42 +0100
Subject: Re: Process Modeling Tool
To: CF-Talk <[EMAIL PROTECTED]>
> I am looking for a tool/software so that I can create graphical
> respresentation of processes.
Anyone have recommendations for must-attend sessions at MAX? I know
it's dependent on what you want to do, but I'm looking for
recommendations based on presenter and/or past presentations? Thanks.
John Burns
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Setti
Thanks all. Too many cut-and-pastes and I didn't pay attention. Also, still am a newbie on some of this.
Robert O.
-Original Message-
From: Doug James [mailto:[EMAIL PROTECTED]
Sent: Friday, July 09, 2004 9:26 AM
To: CF-Talk
Subject: Re: SOT: keyword 'Where' error
Yes, you cannot speci
www.quilldesign.com
qdforum is the discussion board, its CFMX Based, its open source, it
costs money, but for the measly amount, WOW, what a product.
tw
On Fri, 9 Jul 2004 07:25:30 -0600, dana tierney <[EMAIL PROTECTED]> wrote:
> I believe I checked out the sourceforge project for this a couple
Robert,
Firstyl, you can't insert using a where clause are you wanting to do an
UPDATE???
Secondly and, you need to use CFQUERYPARAM for all of your values not just
the value for 'item'.
Paul
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donat
There is no WHERE clause here, you are adding a new record
> -Original Message-
> From: Robert Orlini [mailto:[EMAIL PROTECTED]
> Sent: 09 July 2004 15:18
> To: CF-Talk
> Subject: SOT: keyword 'Where' error
>
> Is there a problem with this Insert? I get an "Incorrect syntax near
the
> key
> Is there a problem with this Insert? I get an "Incorrect syntax near the
keyword 'Where'" error.
You can't have a where clause on an insert statement.
Nick
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Yes, you cannot specify a where clause in an insert. If you are updating
a row then use update not insert.
Doug
Robert Orlini wrote:
>Is there a problem with this Insert? I get an "Incorrect syntax near the keyword 'Where'" error. I added single quotes around #cnumber#
>and still get the error.
I believe I checked out the sourceforge project for this a couple of
months back and it's inactive, although it says it has a stable
release out. If there's a product I'd be interested in looking though
when I asked about it (possibly just on community) nobody seemed to
know. So I don't think so,
The way I test for null in CF is to knowingly assign a value from Java
into a CF variable. On the next line, if the variable is "undefined"
then we recieved a NULL value. If it's defined, then we didn't.
Doug
On Wed, 7 Jul 2004 11:46:01 -0400, Joe Rinehart <[EMAIL PROTECTED]> wrote:
> Dick,
>
>
Is there a problem with this Insert? I get an "Incorrect syntax near the keyword 'Where'" error. I added single quotes around #cnumber#
and still get the error.
INSERT INTO itemsordered
(cnumber,
line,
qty,
item,
priceeach,
totalprice
)
VALUES (#cnumber#,
'#line#',
'#qty#',
,
'#trim(item)#',
'#tr
Well,
I got it working. I had to remove the hotfix/security update (security
update mpsb04-04 and technote 18939) then everything started working.
Kind of annoying when a hot fix and a security patch breaks your server.
Steve
-Original Message-
From: Thomas Chiverton [mailto:[EMA
Greetings,
I'm seeing strange behavior when working with XML files that concerns me a
bit and I was hoping someone could help explain what was going on here. I
have a simple XML file:
Victor Hugo
French
Sophocles
Greek
Leo Tolstoy
Russian
Alexander Pushkin
Russian
> Done right, CF doesn't need to give up anything to provide
> optional support for strong typing any more than they had to
> sacrifice anything to give us CFCs.
How do you know this?
We can all speculate on how easy or difficult something would be, but I find
it hard to reach this sort of conc
On Friday 09 Jul 2004 13:26 pm, DURETTE, STEVEN J (AIT) wrote:
> The JRun4 that comes included with the enterprise edition of CFMX6.1
Oh, I'll leave it to someone else then, we're on WebLogic :-)
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
Bl
1 - 100 of 108 matches
Mail list logo