That's seriously a bug? Undoubtedly falls under the same train of
though as not having a CFCONTINUE tag?
Both of those constructs are very valuable to have in certain
situations. Nothing you can't avoid with conditionals (or recursion,
in the case of CFCONTINUE), but you can certainly make code
On 7/11/05, Johnny Le <[EMAIL PROTECTED]> wrote:
> CFbreak doesn't seem to work in cfswitch in CF 7 any more.
Correct. Allowing it was a bug in CFMX 6.x. If you tried it in CF5, it
was illegal.
> What tag do you use to break out of cfswitch now?
You don't need a tag. ends at the tag.
I blogg
No, he means to abort the current case, without having to put the
remainder inside a conditional.
switch (myval) {
case "one":
...
if (condition) break;
...
break;
case "two":
...
}
...
...
cheers,
barneyb
On 7/11/05
Do you mean to stop each successive cfcase from executing? You don't need to
do that in cfswitch, only in the cfscript switch().
-Original Message-
From: Johnny Le [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 12 July 2005 2:12 p.m.
To: CF-Talk
Subject: cfbreak in cfswitch in CFMX 7?
Hi,
CF
Hi,
CFbreak doesn't seem to work in cfswitch in CF 7 any more. What tag do you use
to break out of cfswitch now?
Johnny
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and
> SELECT p.si_id,s.food_store_id,s.gs_price, SUM(s.gs_price) AS total_price
> FROM fsnep_food_store_purchases p, fsnep_food_store
> s,fsnep_food_store_game_info g
> WHERE p.food_store_id = s.food_store_id
>AND g.gi_id = #cookie.fsnep_bargain_hunt_gi_id#
> GROUP BY p.si_id,s.food_store_id,s.gs_
Here's what I'd suggest...
1) Learn how to use CFCs properly. Place your business logic in CFCs and
then build your display pages to call your CFCs.
2) Next learn how to write custom tags with start and end tags like this:
...content...
And use them to build layout elements such as box
I see, thanks.
>first ooops:
>
>> RETURNING ID
>> INTO newid;
>
>should be
>
>> RETURNING GI_ID
>> INTO newid;
>
>(obviously)
>
>/t
>
>>
~|
Logware (www.logware.us): a new and convenient web-based time t
Greetings,
I am new to ColdFusion and just started to learn. Before I get set in my
ways, I have read many posts about things like Fuse Builder and other module
building blocks for creating applications. My question is which one would be
the easiest to learn and is it a good practice to use one
I am trying to SUM a column in oracle. The query works fine until I add the
SUM. It seems from the error, that I then have to have a GROUP BY. I guess I
don't understand how to use the GROUP BY in this instance or choose which
column to GROUP BY. I have googled around.
SELECT p.si_id,s.food
On 7/11/05, Douglas Knudsen <[EMAIL PROTECTED]> wrote:
>
> On 7/11/05, Aaron Rouse <[EMAIL PROTECTED]> wrote:
> >
> > How many times would it really matter if it did? I have seen sometimes
> > where
> > a "new app" would start off at say ID value of 143 just because of all
> the
> > testing and n
On 7/11/05, Aaron Rouse <[EMAIL PROTECTED]> wrote:
>
> How many times would it really matter if it did? I have seen sometimes
> where
> a "new app" would start off at say ID value of 143 just because of all the
> testing and not resetting the sequence never seemed to be an issue though.
I suppo
I have a Java class that runs fine as an application with main(), but
when I call it form CF it errors, I made sure the right constructor is
called - I just cannot figure out what the difference is and why it
errors.
The error is:
There was an error reading the Input Stream. The error is Conne
Thanks. We wound up finding an admin with more permissions than the
one I am working with and he squared us away. I didn't have access to
the xml files, either.
--
--mattRobertson--
Janitor, MSB Web Systems
mysecretbase.com
~|
> The first thing that comes to mind is "permissions". When you
> run it from the command line, what account are you using? Does
> this account have permissions to change the password?
>
> Then, what about ColdFusion? Are you running the CF service(s)
> with an account that has permission to c
If you are trying to select a value in your dropdown based on the
input box vsomething like this should do the trick:
funtion correctSelect(inputBoxValue,selectBoxObject)
{
var i=0;
for(i;i wrote:
> I have a text box for client number and a drop down box for client name.
>
> Using data bi
Well that's not the only reason to avoid cftransaction where it's not
needed... You can't nest cftransactions, so if for some (who knows)
reason you found yourself needing to cfinclude two separate templates
within a cftransaction (or different method calls or whatever) you'd
get an error if the in
Good point...
Jeff
> -Original Message-
> From: Paul Hastings [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 11, 2005 4:44 PM
> To: CF-Talk
> Subject: Re: Query to text file.
>
>
> Jeff Waris wrote:
> > project. DTS also seems like trying to kill a fly with a
> sledgehammer.
> > So
No worries. Glad to be of service.
If you want more help with RegEx, I suggest subscribing to the HoF regex
list. It's very low-traffic, but if you post a question, it WILL get
answered. Sometimes in more detail than you actually needed! And
everyone on it is happy to help you learn.
--Ben
P
Speaking of DTS, the DTS on the new SQL 2005 looks pretty
cool. The sledgehammer beta is out.
Lee Surma
On Mon, 11 Jul 2005 16:16:37 -0400
Jeff Waris <[EMAIL PROTECTED]> wrote:
> I am running SQL7. I have actually thought about using
>DTS to a text file
> but I would run into other issues t
Jeff Waris wrote:
> project. DTS also seems like trying to kill a fly with a sledgehammer. So I
> was hoping a more simple solution could be found for a plain text file dump.
considering your "fly" is choking your server to death, i think you're
looking at this the wrong way.
~~
How many times would it really matter if it did? I have seen sometimes where
a "new app" would start off at say ID value of 143 just because of all the
testing and not resetting the sequence never seemed to be an issue though.
Guess I just look at it differently, because the way I look at it is
The first thing that comes to mind is "permissions". When you run it
from the command line, what account are you using? Does this account
have permissions to change the password?
Then, what about ColdFusion? Are you running the CF service(s) with an
account that has permission to change the pas
I am running SQL7. I have actually thought about using DTS to a text file
but I would run into other issues that I don't want to tackle for this
project. DTS also seems like trying to kill a fly with a sledgehammer. So I
was hoping a more simple solution could be found for a plain text file dump.
i see no reason to use it in Daniels case. once you get the next value from
a sequence in Oracle, no other request will get that id.
Now, if Daniel needed to perform several inserts, updates, etc in one
request based on this id, then yes, by all means use cftransaction. In his
case he had only
> What is the best way to dump a HUGE query to a text file.
the db itself?
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Messag
Thanks Ben,
it really seems to work. Now I have to crawl the source html
backwards and have a look at what happens :)
Thanks a lot!
Patric
> More or less. I would probably skip the backreferences and rewrite the
> img tag from scratch, or specify which attributes I want to keep. But
> if you w
Did you tried to pass the Query Object to CFX using request and then loop
over the query using the Query object.. (both from com.allaire.cfx)
-Mensaje original-
De: Jeff Waris [mailto:[EMAIL PROTECTED]
Enviado el: Monday, July 11, 2005 3:18 PM
Para: CF-Talk
Asunto: Query to text file.
W
i've working on some CFX tags and could be if i can
pass the Java Exception captured by try catch statement to CF using query or
structs or something , but dont know how do it cause
Exception getStackTrace() method return Throwable and i cant see that in CF
only in console... but cant run this
i've working on some CFX tags and could be if i can
pass the Java Exception captured by try catch statement to CF using query or
structs or something , but dont know how do it cause
Exception getStackTrace() method return Throwable and i cant see that in CF
only in console... but cant run this
What is the best way to dump a HUGE query to a text file.
There used to be a CFX tag long ago called CFX_dumptext that did this. This
doesn't work on MX6.1.
I have rolled my own with little success on extremely large queries. Each
works below on small queries just fine. In no particular order:
More or less. I would probably skip the backreferences and rewrite the
img tag from scratch, or specify which attributes I want to keep. But
if you want to keep all additional attributes (style, alt, title, etc.)
then you're right -- that'd be how to go about it.
--Ben
Patric Stumpe wrote:
> Hi
Hi Howie,
I did already solve that part. Manually geneerated messages are
properly sent. So now I (hopefully) only need to concentrate on that
replacment for the WYSIWYG-submitted mailbody.
Greets
Patric
> FYI - Even if you replace the source with a CID you still need to
> encode the image into
Thanks Mike.
--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 942-5378
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/
Mike Chabot wrote:
> The scheduled event would be missed entirely.
Mosh Teitelbaum wrote:
> > Quick question concerning the CF Scheduler... what happens if the
FYI - Even if you replace the source with a CID you still need to encode the
image into the email using that same CID as a reference.
Regards,
Howie
--- On Monday, July 11, 2005 2:41 PM, Patric Stumpe scribed: ---
>
> Hi Ben,
>
> thanks for the quick reply.
> Am I right that I could embrace th
Hi Ben,
thanks for the quick reply.
Am I right that I could embrace the different parts of that regex for
simple back-reference? I have to grab the complete URL of the
src-attribute (need to work with that a bit) and replace it with a
known string:
e.g.:
would lead to:
cid:inlineImage01"; heigh
I have a text box for client number and a drop down box for client name.
Using data binding, when you choose a client name from the drop down
box, the client number is populated.
How can I make the drop down box move to the appropriate name when a
clientnum is entered in the text box?
To summari
The location of the default web root depends on how you're set up. For
instance, on Jboss, it's located in the file WEB-INF/jboss-web.xml. If
you're running Jrun, it's in WEB-INF/jrun-web.xml. However, the error
handlers are located in the WEB-INF/web.xml file. You need to add an
attribute aft
Finding the img tags should be easy. Replacing them with inline tags
is, unfortunately, something I'm not familiar with.
To find an img tag, you would look for something like this:
]*src="[^"]+"[^>]*>
Hopefully, someone can help with the other half (9/10ths?) of the problem.
--Ben
Patric Stump
The scheduled event would be missed entirely.
-Mike Chabot
On 7/11/05, Mosh Teitelbaum <[EMAIL PROTECTED]> wrote:
>
> All:
>
> Quick question concerning the CF Scheduler... what happens if the server
> is
> down during the time when an event is scheduled to occur? Does the
> Scheduler just i
Hi folks,
i did already search the web and the archives but without any success.
I'm trying to build a HTML-Email-Interface which runs on an old CF4.5.
The input and some parts of the processing are running quite fine. But
now I'm stuck on the img-tags, where I have to replace the relative
image-
All:
Quick question concerning the CF Scheduler... what happens if the server is
down during the time when an event is scheduled to occur? Does the
Scheduler just ignore the event and wait until the next recurrence or does
it fire the event whenever the server is restarted?
TIA
--
Mosh Teitelba
Is there a reason to want to avoid using cftransaction?
On 7/11/05, Douglas Knudsen <[EMAIL PROTECTED]> wrote:
>
> and you do not need cftansaction either. once query 1 executes, you have
> the
> id in hand. if another request came in it would get a differnt id. simply
> based on the uniqueness
> I have a hierarchical set of data stored in tree format. The tree may or
> may not be a binary tree ... i.e. each node could have 0 thru N sub-nodes.
> Now, I need to calculate the length of the longest branch, or otherwise, the
> depth of the tree. My comp. sci. days are a long way behind me,
and you do not need cftansaction either. once query 1 executes, you have the
id in hand. if another request came in it would get a differnt id. simply
based on the uniqueness of the sequence.
DK
On 7/11/05, Greg Morphis <[EMAIL PROTECTED]> wrote:
>
> Like Doug suggested, I've found the best wa
How would the NOCOUNT setting affect the @@IDENTITY being returned? Doesn't
seem like it from the sql docs:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_
set-set_3ed0.asp
SET NOCOUNT
Stops the message indicating the number of rows affected by a Transact-SQL
statemen
Steve,
>
>context = createObject("java", "coldfusion.runtime.NeoPageContext");
>isLocked = context.getNamedLock();
>
>
>
>
>
>
><< put some code that meets a race condition here >>
>
>
>
>
Even if you can figure out any locked statements, you wouldn't be able to
use the syntax you had pos
Sometimes you need to fiddle with the "NOCOUNT" setting to make it work
reliably. It depends on how the SQL server is configured.
SET NOCOUNT ON
Insert into table (cols) values (values)
select @@IDENTITY as maxid
SET NOCOUNT OFF
This is especially true if you are updating more than 1 sta
On 7/11/05, Aaron Rouse <[EMAIL PROTECTED]> wrote:
> I always just use triggers for when inserting, but it seemed like the worry
> here was to know the ID after the insert to I'd guess display to the user.
> How would a trigger help for that need?
The trigger won't help for that need. I was just s
There's an xml file that stores where the default web root is, right?
I need to install a site-wide error handler and I'm confronted with a
server admin who doesn't seem to know where that is. I know there's a
way to pull it out but I haven't found it offhand.
--
--mattRobertson--
Janitor, MSB
Hello all-
I have spent many sleepless nights on this one and I feel like I am
getting close to the solution, but I will need some help as my Java
experience is *very* limited.
I found some Java code that resets the AD password via LDAP/SSL. The
code works successfully and the password is changed
I always just use triggers for when inserting, but it seemed like the worry
here was to know the ID after the insert to I'd guess display to the user.
How would a trigger help for that need?
On 7/11/05, Eddie Awad <[EMAIL PROTECTED]> wrote:
>
>
> Of course, you could also just create a "when-
That syntax is invalid for Oracle.
As far as SQL Server, I believe it is fine but I have watched a couple of
debates on it via this mailing list so as with all things best to just
research over taking someones word. :)
On 7/11/05, Russ <[EMAIL PROTECTED]> wrote:
>
> This does work properly i
Like Doug suggested, I've found the best way to do this is 2 queries..
First
select game_id.nextval as id from dual
Then store that value in a session variable or however you want to.
Then you can use that to insert into different queries.
On 7/11/05, Aaron Rouse <[EMAIL PROTECTED]> wrote:
My bet as well would be that the cold fusion service does not have
access to those folders.
If you give the user that the cf service uses the proper rights, you
should be golden.
You might also want to look into ldap for a longer-term solution.
On 7/11/05, Claremont, Timothy <[EMAIL PROTECTED]>
> I don't know SPs yet, but that's an interesting idea. I'll have to look into
> that when I get time.
Well, it's simple. Here is a working example of how you would do it in
Oracle using a stored procedure:
create table t (id number, colname varchar2(50))
/
create sequence t_seq
start with 1
i
This does work properly in SQL Server, right? I mean we haven't seen any
issues, but I'd hate to think that we have a bug in our code...
Does the same syntax work in oracle? What kind of situations could cause
this to not work properly?
Russ
-Original Message-
From: Aaron Rouse [mailto
I've been looking through many of the classes inside the ColdFusion Java
libraries trying to find something that would help me determine if the code
is currently inside a scoped or named lock. Has anyone else run across
anything that relates to inspecting or determining lock status?
Basically, I
Right, so Im assuming the webserver does not have access to the directory
and therefore you cant just use cfdirectory.
Some ideas:
Use frames
Use javascript to popup a window with no address bar
Setup a website with a home directory set to use that directory
Setup a share on the server e.g. so
I'm not sure. As in the classic game of "phone," I probably have this wrong.
But as I understood the explanation, the DBA thought the query was being
restarted when new data was added to the underlying tables. It seemed odd to
me as well, but I'm just the web programmer.
Any the plan current
James Smith wrote:
>
> SELECT max(stockid) as stockid, data1, data2
> FROM table
> HAVING data1 = 5
>
> Unfortunately this is returning the following data
>
> StockID | Data1 | Data2
> ---
> 3 | 5 | 2
>
> Ie: the correct stockid and data1 but data2 from a
Thanks, Jerry,
I made a couple of syntax correction to your suggestion, but I get a
"Connection Failure" on the result page.
Note that if I merely copy and paste the URL into the browser it works
just fine, so I know I can "see" the URL.
Subject: Simple Directory Listing
From: Jerry Johnson <[E
> What RDBM are you using? Wouldn't this do it?
>
> -- MySQL
> SELECT *
> FROM table
> WHERE data1 = '5'
> ORDER BY DESC
> LIMIT 1
Unfortunately not. If you view the larger query you will get a better idea,
and to explain the process...
The query returns about 7500 records. AddedToFile is a f
I have yet to see a way of doing this in Oracle/CFQUERY that works in all
situations. Actually I have yet to see it work, but have heard of it working
which is why I put "situations"
On 7/11/05, Russ <[EMAIL PROTECTED]> wrote:
>
> Why not just do something like this (sql server)
>
> Insert in
Why not just do something like this (sql server)
Insert into table (cols) values (values)
select @@IDENTITY as maxid
-Original Message-
From: daniel kessler [mailto:[EMAIL PROTECTED]
Sent: Monday, July 11, 2005 11:32 AM
To: CF-Talk
Subject: Re: retrieve ID from db insert
I don't know SP
Crude, but...
then make a dir_listing.cfm page
#cfhttp.fileContent#
Jerry Johnson
On 7/11/05, Claremont, Timothy <[EMAIL PROTECTED]> wrote:
> I want to place a button on my form that brings up a directory listing.
> I am currently using the following method to merely open the directory
>
I don't know SPs yet, but that's an interesting idea. I'll have to look into
that when I get time.
>Or if you wanted to do it all in one "tag" you could just put it into a SP
>and run it that way. There are of course various views as to the added
>advantage of doing this, you can swearch throu
first ooops:
> RETURNING ID
> INTO newid;
should be
> RETURNING GI_ID
> INTO newid;
(obviously)
/t
>-Original Message-
>From: RADEMAKERS Tanguy
>Sent: Monday, July 11, 2005 5:19 PM
>To: 'cf-talk@houseoffusion.com'
>Subject: RE: CF-Talk: Digest every hour
>
thanks everyone for your help!
>search the archives, this has been discussed several times here. In short,
>do two queries. query 1, get the next val in your sequence. now you have
>your id in hand. query 2, do your insert using the id. do whatever you want
>with the id.
~~
Or if you wanted to do it all in one "tag" you could just put it into a SP
and run it that way. There are of course various views as to the added
advantage of doing this, you can swearch through the list archives for all
of those. :)
On 7/11/05, daniel kessler <[EMAIL PROTECTED]> wrote:
>
> o
ok, this actually answers my question of how to assure that the 2nd query
actually returns the correct id and not allow another to be inserted until I
have it. That was my worry.
Thanks!
>In reference to the first email, you would do a CFTRANSACTION and not a
>CFLOCK.
~~~
Hello,
1) Do two queries in a CFTRANSACTION (not CFLOCK) - one to insert and
one to get the value of the new ID.
2) Write a stored procedure that returns the value of the inserted id
(see the SQL guide for the syntax of RETURNING INTO clause)
start with this:
CREATE OR REPLACE PROCEDURE insert_
I want to place a button on my form that brings up a directory listing.
I am currently using the following method to merely open the directory
on the end users machine:
This works great, but the manager wants the ADDRESS BAR in the new
window to be hidden, so the 'not-computer-
In reference to the first email, you would do a CFTRANSACTION and not a
CFLOCK.
On 7/11/05, Douglas Knudsen <[EMAIL PROTECTED]> wrote:
>
> search the archives, this has been discussed several times here. In short,
> do two queries. query 1, get the next val in your sequence. now you have
> your
What RDBM are you using? Wouldn't this do it?
-- MySQL
SELECT *
FROM table
WHERE data1 = '5'
ORDER BY DESC
LIMIT 1
-- SQLServer
SELECT Top 1 *
FROM table
WHERE data1 = '5'
ORDER BY DESC
- Original Message -
From: "James Smith" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Monday, July 11
search the archives, this has been discussed several times here. In short,
do two queries. query 1, get the next val in your sequence. now you have
your id in hand. query 2, do your insert using the id. do whatever you want
with the id.
DK
On 7/11/05, Daniel Kessler <[EMAIL PROTECTED]> wrote:
I create a new game and insert it into my Oracle database. From
there I want to have the game ID and put it into a cookie. I've used
NEXTVAL AND CURVAL for inserting the value into the db, but not for
any external use, like my insert into a cookie. I guess I can do a
CFLock and then do a quer
Hello,
I've never heard of oracle "restarting" a query because the underlying
data had changed. Oracle uses a multi-version view of data to show you
results consistent with what the database looked like at the start of
the query (at the very least - it can also do "consistent with the start
of the
I have a problem I am sure is simple to solve but it has proved to be beyond
me.
Imagine I have the following data...
StockID | Data1 | Data2
---
1 | 1 | 2
2 | 3 | 4
3 | 5 | 6
And I want a query to return
StockID | Data1 | Data2
Thanx S. Isaac Dealey... Sun... i'll be there... ;-)
Cheers.
MD
2005/7/11, S. Isaac Dealey <[EMAIL PROTECTED]>:
> > Thank you S. Isaac... I'll be change our code to
> > Java.io.File
> > routines... Do you have any example about? Tutorials, how
> > to use that
> > Java classes?
>
> > Thanks once
One possibility for "using CFMX Admin" is to not use the CFMX Admin GUI. You
can edit the neo*.xml files then deploy them to configure CFMX, without using
the CFMX Admin GUI.
We did this on a WebSphere cluster because the CFMX Admin settings won't
progagate across the cluster. However, a scrip
CFMX *is* Java
In fact, it's Sun-certified J2EE compliant. That's pretty pure.
Chris Norloff
-- Original Message --
From: "Mosh Teitelbaum" <[EMAIL PROTECTED]>
Reply-To: cf-talk@houseoffusion.com
Date: Thu, 30 Jun 2005 14:17:36 -0400
>All:
>
>I have a
Do you mean a true breadcrumb trail (a clicktrace, or where the user
has been) or do you mean a page heirarchy, or a drilldown path?
(page heirarchy)
Site: Section: Subsection: Page
(drilldown path)
Home: Books: Family Law: Probate and Family Court Handbook
(clicktrace)
Home: Top Stories: Home:
> Thank you S. Isaac... I'll be change our code to
> Java.io.File
> routines... Do you have any example about? Tutorials, how
> to use that
> Java classes?
> Thanks once more again.
Welcome,
I just read the API documentation on the sun site myself...
http://java.sun.com/j2se/1.4.2/docs/api/java
> I was trying to think of a good way to create a breadcrumb trail for
> my users as they navigate through my app. The first thing that comes
> to mind is setting a session variable in onRequestStart in App.cfc.
> Then using that to create the links.
>
> Could someone expand on this? Or offer
Thank you S. Isaac... I'll be change our code to Java.io.File
routines... Do you have any example about? Tutorials, how to use that
Java classes?
Thanks once more again.
MD
2005/7/7, S. Isaac Dealey <[EMAIL PROTECTED]>:
> > Thanks S. Isaac Dealey
>
> > Yes. I need to use FSO with CF(CreateObjec
Thats an interesting bug! heres a sorta workaround:
function Hex7toStr(Char){
var newchar = "";
var asciiChar = "";
var i=0;
for(i=1;i lte len(char);i=i+1){
asciiChar = asciiChar&asc(mid(char,i,1));
}
switch (asciiChar)
{
87 matches
Mail list logo
