Hi all,
I have a problem. I have a page that I want to populate a section of the
form with data from my database based on the selection in a drop down list.
I have got the query to pull the records and use that to populate the pull
down list. I know that to change the values of the fields with
On Friday 23 Jul 2004 15:23 pm, Adkins, Randy wrote:
Can anyone enlighten me on how in the world will a CFX Tag still
What are your page cache settings in the CF Admin ?
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
You can use cfwddx to create JS objects/arrays from CF variables. If you
use the query directly, you will need to have the JS wddx object in your
page. Find more info in the cf docs:
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/xml51.htm
Pascal
-Original Message-
From: Kevin
Kevin
1) Are you talking about populating something like 3 selects related
2) do you want populate it in CF then change it in _javascript_
3) How much data are we talking about
4) Why do you think you need it in a _javascript_ array
The reason I ask, is that there are several alternatives, that,
Thanks Pascal,
I read the pages on the wddx object and got the query loaded into an array.
Problem is I am now unsure how to reference it. :-( Unfortunately the docs
are not very specific on the syntax to actually use and reference the array.
Or at least not to a newbie. :-( If I post the code
Hi Dick,
What I am doing is this. I am creating an Order Entry form and when the user
selects the customer from the list created from the query the address and
other customer information is then filled in automatically. I am talking
about a total of 5 fields that need to be filled in. I had
Do you know how to do _javascript_ arrays? Wrap your _javascript_ array creation code in a CFOUTPUT and create them in CF, the browser will load the page and create the _javascript_ array.
rough example:
script
// create your _javascript_ array
CFOUTPUT QUERY=your query
Kevin
how many customers in the list?
What I am trying to determine is:
1) Is it practical to download the list of customers AND all their data
with the page from CF
2) OR Just download the list of customers, have the user select one,
then make a request to the server for another page with
Hi Aaron,
Up to this point I had only worked in a one dimensional array. (i.e.
bannerImg[0] = somebanner1.gif, bannerImg[1] = somabanner2.gif etc.) Now
I need to capture 6 fields for each row. I had thought to do what you
outlined but got lost with the multi-dimensional array. Would the code for
Aaron
That's OK for small arrays, but for large arrays it is a real hog of
bandwidth and client-side memory cycles (similar to the way WDDX does
it).
Dick
The reason there are two senators for each state is so that one can be
the designated driver.
-Jay Leno -
On Jul 26, 2004, at 2:47 AM,
Hi again,
Well, the number of customers are probably going to be around 10 - 20 to
start, but I am not sure of the totals as I had neglected to ask that
question. :-( For now I would feel safe with 50 as a total number of
customers. The only information I am going to need to pull in is the
OK
You could do it with WDDX -- CF has a tag, cfwddx, that
converts/transmits CF arrays on the server to _javascript_ arrays on the
client.
CFWDDX is the easiest way to go if you have a small number of users and
a small amount of data.
CFWDDX sends/receives the data and the _javascript_ code
Yes Kevin, that is exactly the way you would do it... I think. Do a google on 2 dimensional _javascript_ array to get the syntax just right.
As a suggestion, give it a go anyway, and see what happens :) the worst that can happen is you get errors and we'll help you with them. You cant break
I'm curious how cfwddx is easier than the cfoutput junk code sample i submitted.
Aaron
- Original Message -
From: Dick Applebaum
To: CF-Talk
Sent: Monday, July 26, 2004 8:42 PM
Subject: Re: HELP. CF and _javascript_ question
OK
You could do it with WDDX -- CF has a tag, cfwddx,
Something like this:
cfquery name=q datasource=#dsn#
SELECT id, name, address,phone
FROM users
/cfquery
!--- Load the wddx.js file ---
script type=text/_javascript_ src="">
script
// Use WDDX to move from CFML data to _javascript_
cfwddx action="" input=#q# topLevelVariable=qj
function
The function is not correct:
function Populate(f){
var i = f.User.selectedIndex - 1; // take the blank option into
account
if(i0){
f.UserAddress.value = ;
f.UserPhone.value = ;
}
else{
f.UserAddress.value = qj.getField(i,address);
f.UserPhone.value = qj.getField(i,phone);
}
}
Pascal
Hey Peter!
THANKS!!! I was able to decipher the code and adapt it t my form design and
query. Now that I have implemented it once I shall be able to do this again
on my own. I thank you from the bottom of my heart! You saved my day. :-D
I have one more question if you don't mind. On some one of
Does it actually have the string null??
In that case:
function ReplaceNull(val){
return (val==null)?:val;
}
...
f.addressLine2.value = ReplaceNull(qj.getField(i,addressLine2));
If it is the null value:
function ReplaceNull(val){
return (val==null)?:val;
}
Pascal
-Original Message-
I'm looking to get into Java for some integration with CF etc.
What would you recommend as a free Java IDE?
Thanks,
Frank
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Hi Michael,
This is trivial to do using VBScript in Excel, assuming that you're able to
run macros.Are your dynamic rows on the same worksheet as the cell
containing your number of customers? If you decrease the number of
customers, are rows deleted?
If you want, send me your spreadsheet off
Eclipse and CFEclipse
MD
On Mon, 26 Jul 2004 09:41:23 -0400, Frank Mamone [EMAIL PROTECTED] wrote:
I'm looking to get into Java for some integration with CF etc.
What would you recommend as a free Java IDE?
Thanks,
Frank
[Todays Threads]
[This Message]
[Subscription]
[Fast
I'm looking to get into Java for some integration with CF etc.
What would you recommend as a free Java IDE?
http://www.netbeans.org/
http://www.eclipse.org/
They are both worth a try
Massimo Foti
http://www.massimocorner.com
I wonder if anyone here can comment on this?
http://www.turnkey.to/ontap/forum/?thr_20040722234850_zZaHW6BEab4YCTHu
s. isaac dealey954.927.5117
new epoch : isn't it time for a change?
add features without fixtures with
the onTap open source framework
Was undecided about posting this here versus CF-Jobs-Talk but since it
involves a technical question versus being job-related, decided to post
to CF-Talk.
I've recently read the book Hackers and Painters (by Paul Graham) and
it was a very exciting book to read for those of us involved in
Hi
How can I load an XML file and display the contents on my CFM page i.e.
there is an XML file at (lets say http://www.abc.com/test.xml). How can
I get the data from this file and loop over a particular item in my CFM
page?
Thanks
Shaz
On Monday 26 Jul 2004 15:09 pm, Shahzad.Butt wrote:
there is an XML file at (lets say http://www.abc.com/test.xml). How can
I get the data from this file and loop over a particular item in my CFM
See cfhttp, xmlparse() and xmlsearch().
--
Tom Chiverton
Advanced ColdFusion Programmer
[Todays
Well, WDDX gives you some well defined and documented ways of handling
a recordset with _javascript_, on the client -- and approximates the way
you handle a recordset with CF.
In fact, if you look at the code that cfwddx generates it is similar to
yours:
// Use WDDX to move from CFML data to
You're likely to get a ton of responses on this Chuck, running the gamut from CF is God, to CF is the devil. I look at it this way: The single greatest advantage of CF is rapid application development of dynamic web pages.
This works great if you need to...rapidly develop a dynamic web
Does it actually have the string null??
The function returns an empty string if the argument (val) is the string null,
or the argument itself if not.
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send
On Monday 26 Jul 2004 15:09 pm, Shahzad.Butt wrote:
there is an XML file at (lets say
http://www.abc.com/test.xml). How can
I get the data from this file and loop over a particular
item in my CFM
See cfhttp, xmlparse() and xmlsearch().
also XMLTranslate() (?) I think that's the name of the
Well, looks like Michael is enforcing message length
I generalized this a little into a concept I call thinArray.
which looks like this (you should display this in a fixed-width font,
and no wrap):
|6 | Emp_ID | LastName | FirstName | Department | Phone | email | 1
| Peterson | Carolyn |
On Monday 26 Jul 2004 15:25 pm, S. Isaac Dealey wrote:
also XMLTranslate() (?) I think that's the name of the XSLT
function...
Well, yes :-)
If the question hadn't so specific, I'd have pointed at
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/functi20.htm#wp3468770
and
Firtht, I think iths pronounthed Lithp!
Bad!
Second, you gotta love parentheses.
I've done a little PHP and ASP -- too granular for most of my needs.
(IMO).
I done several years of Perl -- can't even read my code anymore.
Don't know Ruby or Python.
I plan to use CF Anywhere I can (maybe
I was looking at Eclipse but I didn't see a free version. I saw only
trial versions.
I'll take a second look.
Thanks for your suggestions,
Frank Mamone
- Original Message -
From: Massimo Foti [EMAIL PROTECTED]
Date: Mon, 26 Jul 2004 15:41:59 +0200
Subject: Re: Best Free Java IDE
To:
XMLTransform ... duh... :) You can see how much I've used it. :)
On Monday 26 Jul 2004 15:25 pm, S. Isaac Dealey wrote:
also XMLTranslate() (?) I think that's the name of the
XSLT
function...
Well, yes :-)
If the question hadn't so specific, I'd have pointed at
Not Michael's fault -- some thing doesn't handle a caret (UC6) symbol--
here's a third try.
I generalized this a little into a concept I call thinArray.
which looks like this (you should display this in a fixed-width font,
and no wrap):
|6 | Emp_ID | LastName | FirstName | Department |
Will XMLParse() work on CF5.0? currently its giving an error on CF5.0.
On CFMX6.1 it gives error Document root element is missing.
Any ideas on that?
Shaz
_
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: 26 July 2004 15:47
To: CF-Talk
Subject: Re: XML load
XMLTransform ...
Dave, we are also planning on using NLB and CFMX on JRun.Are you
saying that if we are using NLB, there is no need to cluster CFMX as
well?
We will have two separate servers that will use NLB in single affinity
(sticky session) mode.I am assuming that, as long as both CFMX
installations are
XMLParse() was introduced in CFMX, CF5 did not have XML processing built in.
--- Ben
_
From: Shahzad.Butt [mailto:[EMAIL PROTECTED]
Sent: Monday, July 26, 2004 10:52 AM
To: CF-Talk
Subject: RE: XML load
Will XMLParse() work on CF5.0? currently its giving an error on CF5.0.
On CFMX6.1
Hi gang I remember hearing something a while back where someone wanted
to grab the id of an item they just entered into the database all in one
sql statement.
Does anyone remember the sql for that?
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
On Monday 26 Jul 2004 15:51 pm, Shahzad.Butt wrote:
On CFMX6.1 it gives error Document root element is missing.
It probably is.
What are the first few lines of the XML string ?
--
Tom Chiverton
Advanced ColdFusion Programmer
[Todays Threads]
[This Message]
[Subscription]
[Fast
Hi all,
After the awesome help that Dick and others have provided throughout the night has given me the ability to do what I need. Now I only have one more problem that I can not seem to fix. I want to make the fields that I filled in with my java function to be inaccessible to the user. I have
At 11:00 AM 7/26/2004, you wrote:
Hi gang I remember hearing something a while back where someone wanted
to grab the id of an item they just entered into the database all in one
sql statement.
[sql query here]
SELECT @@IDENTITY AS 'NEW_ID'
Usually you access the NEW_ID as a column in a
SELECT MAX(id) from tablename
Daniel Farmer [EMAIL PROTECTED] wrote:Hi gang I remember hearing something a while back where someone wanted
to grab the id of an item they just entered into the database all in one
sql statement.
Does anyone remember the sql for that?
-
http://services.postcodeanywhere.co.uk/xml.aspx?account_code=JJFAS1
license_code=XE47-EP93-RD59-GW24action="">
e=EN8%208RZ##
PostcodeAnywhere Server=WS02 Version=2.0 Date=26/07/2004
14:35:22 Duration=0.016s
-
http://services.postcodeanywhere.co.uk/xml.aspx?account_code=JJFAS1
Not the caret -- final try (diagram last)
I generalized this a little into a concept I call thinArray.
which looks like this (you should display this in a fixed-width font,
and no wrap):
Refers to the diagram at the end:
This is just a string repreesntation of a List with some special
Readonly attribute isn't supported by all browsers.Try something along the
lines of:
input name= type=text id= size= >
-Original Message-
From: Kevin [mailto:[EMAIL PROTECTED]
Sent: Monday, July 26, 2004 11:07 AM
To: CF-Talk
Subject: Problem preventing a text input field from getting
for sql server:
cfquery
SET NOCOUNT ON
INSERT INTO users (firstname)
VALUES ('george')
SELECT @@Identity AS userId
SET NOCOUNT OFF
/cfquery
-joe
- Original Message -
From: Daniel Farmer [EMAIL PROTECTED]
Date: Mon, 26 Jul 2004 11:00:00 -0400
Subject: grabbing the id of an item just
If you are using SQL Server you can use @@identity or scopeIdentity()
-Original Message-
From: Milan Mushran [mailto:[EMAIL PROTECTED]
Sent: Monday, July 26, 2004 10:08 AM
To: CF-Talk
Subject: Re: grabbing the id of an item just entered into DB
SELECT MAX(id) from tablename
Daniel
On Monday 26 Jul 2004 16:07 pm, Kevin wrote:
READONLY parameter to the input tag but it still allows me to tab into it.
disable ?
--
Tom Chiverton
Advanced ColdFusion Programmer
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
This will not necessarily work. If a concurrent user has inserted something between the time your process did, and the retrieval, you are not gauranteed to be retreiving the correct row.
either use @@Identity or some sort of unique identifier in the retrieval, such as max(primarykey) and userid
On Monday 26 Jul 2004 16:10 pm, Shahzad.Butt wrote:
http://services.postcodeanywhere.co.uk/xml.aspx?account_code=JJFAS1
license_code=XE47-EP93-RD59-GW24action="">
e=EN8%208RZ##
That isn't returning valid XML.
Try looking at something like http://www.stg.brown.edu/service/xmlvalid/
You
If you are using SQL Server, the functions you need are
SCOPE_IDENTITY() and IDENT_CURRENT().
These will grab the last id inserted into a table, etc. but be sure to
make yourself aware of their scopes. I would highly recommend checking
out the t-sql reference here:
Figured I would bring this up as I have noticed issues with it in the
past. This is a quote from the microsoft site about the various
current identity functions of sql server.
IDENT_CURRENT is similar to the Microsoft® SQL Server¢ 2000 identity
functions SCOPE_IDENTITY and @@IDENTITY. All three
Readonly will allow the focus. It will not be editable (and is not
supported by all browsers). You can use disabled, but that means the
value will not be sent to the action page (no form variable will be
created). If you need to pass it to the action page, you can make a
disabled text field and a
Use cftransaction tags--
cftransaction
1) insert query
2) MAX (id) query
i.e. select max(id) as newid from tablename
/cftransaction
G [EMAIL PROTECTED] wrote:
This will not necessarily work. If a concurrent user has inserted something between the time your process did, and the retrieval,
Hi all,
I've a section of development ongoing with PHP developers and it has come to
the stage where we'd like to share session variables between php and cfml
code in order to fully integrate our applications. Has anyone had much luck
in accessing CF's session scope directly from php?
We're
Dave, we are also planning on using NLB and CFMX on JRun.
Are you saying that if we are using NLB, there is no need to
cluster CFMX as well?
We will have two separate servers that will use NLB in single
affinity (sticky session) mode.I am assuming that, as long
as both CFMX installations
Has anyone had much luck in accessing CF's session scope
directly from php?
You'll be struggling to share session data because it's all stored in
memory internally inside CF.A better option would be to use client
variables stored in a database, which can then be queried from PHP like
any other
Will XMLParse() work on CF5.0? currently its giving an error
on CF5.0.
No. It was introduced with CFMX.
On CFMX6.1 it gives error Document root element is missing.
My initial guess would be that your document isn't well-formed, and is
missing a root element. But you'd have to post your XML
I was looking at Eclipse but I didn't see a free version. I
saw only trial versions.
There are no non-free versions of Eclipse to the best of my knowledge,
although IBM WebSphere Studio, which shares a lot of Eclipse's
functionality, is commercial, and there may be commercial third-party
I've got an application that I've been developing on a standalone server for a while, and now that I've moved the application into our staging environment I've run into a problem. Our staging environment is running in distributed mode. I have a few templates that generate PDF documents for
CF is the devil.
Is G.W.Bush working in ASP?
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
[Todays Threads]
[This Message]
[Subscription]
I have a few ideas, none of which answer your question. What are you trying
to do?
I might populate the data to the maximum number of queue depth and in the
formulas for the simulated queue data I would check to see of the data
applies.
Otherwise, I guess a macro to generate or copy the formulas
Err.. www.eclipse.org , completely free a in beer :)
On Mon, 26 Jul 2004 10:39:14 -0400, Frank Mamone [EMAIL PROTECTED] wrote:
I was looking at Eclipse but I didn't see a free version. I saw only
trial versions.
I'll take a second look.
Thanks for your suggestions,
Frank Mamone
You'll be struggling to share session data because it's all stored in
memory internally inside CF.A better option would be to use client
variables stored in a database, which can then be queried from PHP like
any other DB.
Hmm, This is pretty much what my first thoughts were but would rather have
Is google down?
Kristopher Pilles
Website Manager
Western Suffolk BOCES
507 Deer Park Rd., Building C
Phone: 631-549-4900 x 267
E-mail: [EMAIL PROTECTED]
Kristopher Pilles.vcf
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Can you use a script to read the file from the cf server and deliver
it with cfcontent?
e.g.:
myserver.com/readpdf.cfm?pdid=12345678
in readpdf.cfm
cfcontent type=application/pdf file=h:\pathtopdf\somepdf.pdf
deletefile=yes
the deletefile attribute would allow you to delete the file once
On Monday 26 Jul 2004 17:07 pm, Dave Wilson wrote:
Perhaps if we knew where within memory and CF the session variables are
being stored, our developers might be able to hash something together.
By the time you write that, you could have written code in the hand-off CFML
page to copy the things
sure isnt...im on it, and sending email from it :)
tw
On Mon, 26 Jul 2004 12:12:09 -0400, Kristopher Pilles
[EMAIL PROTECTED] wrote:
Is google down?
Kristopher Pilles
Website Manager
Western Suffolk BOCES
507 Deer Park Rd., Building C
Phone: 631-549-4900 x 267
E-mail: [EMAIL PROTECTED]
http://www.google.com/search?q=no
On Mon, 26 Jul 2004 12:12:09 -0400, Kristopher Pilles
[EMAIL PROTECTED] wrote:
Is google down?
Kristopher Pilles
Website Manager
Western Suffolk BOCES
507 Deer Park Rd., Building C
Phone: 631-549-4900 x 267
E-mail: [EMAIL PROTECTED]
Kristopher
Hi,
With CF5.0, I'm trying to count 'unique' visitors to our site and how many
pages each visitor views, with this code in Application.cfm. This works
except that logSW does not reset when the visitor closes his browser; only
when the time span expires. How do I determine/force when a session
ASP has a better set of WMD search functions.
- Original Message -
From: Claude Schneegans
To: CF-Talk
Sent: Monday, July 26, 2004 9:31 AM
Subject: Re: Hackers and Painters - Applied to Cold Fusion
CF is the devil.
Is G.W.Bush working in ASP?
--
Thanks Dave...I was using a link from a Google search last night and
was on the wrong site.
I am however having trouble connecting to eclipse.org right now.
-Frank
- Original Message -
From: Dave Watts [EMAIL PROTECTED]
Date: Mon, 26 Jul 2004 11:54:21 -0400
Subject: RE: Best Free Java
nope
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
- Original Message -
From: Kristopher Pilles
To: CF-Talk
Sent: Monday, July 26, 2004 9:12 AM
Subject: Google?
Is google down?
Kristopher Pilles
Use cftransaction tags--
This horse has been whipped over and over here.Archives.
--
--Matt Robertson--
MSB Designs, Inc.
mysecretbase.com
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Not from here.
From: Kristopher Pilles [mailto:[EMAIL PROTECTED]
Sent: Monday, July 26, 2004 11:12 AM
To: CF-Talk
Subject: Google?
Is google down?
Kristopher Pilles
Website Manager
Western Suffolk BOCES
507 Deer Park Rd., Building C
Phone:
yeah I'm getting a Service Error -27 on the search portion of Google.
On Mon, 26 Jul 2004 18:15:51 +0200, Mark Drew [EMAIL PROTECTED] wrote:
http://www.google.com/search?q=no
On Mon, 26 Jul 2004 12:12:09 -0400, Kristopher Pilles
[EMAIL PROTECTED] wrote:
Is google down?
Kristopher
Is google down?
It just came back.
May be someone was searching for mass destruction arms and the search was too hard ;-)
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address:
Good Yeahhh!!! ;-)
On Mon, 26 Jul 2004 12:24:27 -0400, Claude Schneegans
[EMAIL PROTECTED] wrote:
Is google down?
It just came back.
May be someone was searching for mass destruction arms and the search was too hard ;-)
--
___
REUSE CODE! Use
Hey Dave,
Here's a scheme I've used to pass off session-based data into ASP.
May or may not be appropriate.
Create a table with three columns:id, token, and sessionData.When
leaving CF, do a CF - WDDX of the session struct (or implement your
own native way of serializing the session data),
This one has me really confused.Can anybody tell me why this query returns
three records
cfquery name=getOpenItems datasource=myDS
SELECT * FROM CADMODEL WHERE ITEMNAME IN ('211D1234','211D4567')
/cfquery
And this query returns an empty recordset?
cfset itemNames = 211D1234','211D4567
cfquery
Kristopher Pilles wrote:
Is google down?
Sometimes spyware/viruses will alter your hosts file and point google somewhere else. Check out C:\WINDOWS\system32\drivers\etc\hosts if there is a line in there for google or any other sites you didn't add, delete them.
huh doesnt work for us here at all...
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Monday, July 26, 2004 12:22 PM
To: CF-Talk
Subject: Re: Google?
nope
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems
This one has me really confused.Can anybody tell me why
this query returns three records
cfquery name=getOpenItems datasource=myDS
SELECT * FROM CADMODEL WHERE ITEMNAME IN
('211D1234','211D4567') /cfquery
And this query returns an empty recordset?
cfset itemNames =
The official web site for Eclipse (eclipse.org) is currently down. If you
like, you can download the He3 beta from richpalette.com, which includes
latest version of Eclipse, which He3 is built on. You'll find that it
includes all the wonderful Java functionality of Eclipse along with
CFML-specific
The second one translates to:
cfset itemNames = 211D1234','211D4567
cfquery name=getOpenItems datasource=myDS
SELECT * FROM CADMODEL WHERE ITEMNAME IN (''211D1234','211D4567'')
/cfquery
Note the extra outer single quotes ;-)
Cheers
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Nope
- Original Message -
From: Kristopher Pilles
To: CF-Talk
Sent: Monday, July 26, 2004 11:12 AM
Subject: Google?
Is google down?
Kristopher Pilles
Website Manager
Western Suffolk BOCES
507 Deer Park Rd., Building C
Phone: 631-549-4900 x 267
E-mail: [EMAIL PROTECTED]
Kristopher
Anyone see duplicte email issues with CFMX?Have a couple apps that send
emails, CFMX is sending the same one twice.I saw this once before, resarting
the JRun service nipped it, but restarting CFMX process does not.Strange.
anyone?
running CFMX in J2EE style on JRun.
[Todays Threads]
[This
Because you're not using cfqueryparam. ;)
Try it like this:
cfset itemNames = 211D1234','211D4567
cfquery name=getOpenItems datasource=myDS
SELECT * FROM CADMODEL WHERE ITEMNAME IN (cfqueryparam
cfsqltype=cf_sql_varchar value=#itemNames# list=yes)
/cfquery
(Honestly, it's because CF is escaping
Oh yeahI always seem to forget this one.Thanks!My mind is obviously
not up to full speed yet today.
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Monday, July 26, 2004 10:47 AM
To: CF-Talk
Subject: RE: Weird SQL query behavior
This one has me really
Nancy,
CF provides a nice function for the single-quotes issue you're running
into.Try this:
!--- Note that there a NO single quotes here ---
cfset itemNames = 211D1234,211D4567
!--- Listqualify takes care of it for you ---
cfquery name=getOpenItems datasource=myDS
SELECT * FROM CADMODEL WHERE
http://www.searchenginelowdown.com/2004/07/google-under-dns-attack.html
Stephen Milligan
Code poet for hire
http://www.spike.org.uk
Do you cfeclipse? http://cfeclipse.tigris.org
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
I have a form that resides on an SSL site.It submits to another SSL page and after inserting the data into our SQL Server db (via cfstoredproc), it does a cfcontent to display a pdf, using the following:
cfset variables.pdf_to_display = Request.fileRoot \ variables.filepath \
I _finally_ figured this one out.In most of my form action scripts I
employ a tag which strips white space from all form fields.If that tag
is allowed to touch the file upload fields, then I get the error message.
I've built in an exception list attribute into the trimming tag and if I
except
I've been given the following task:
I've got a page with a 500px div containing text.I'm displaying an
image that is to the top-right of the div and it works well (I've got
the borders, etc, that they want).Now I need to add a caption to the
image, have the caption centered underneath the
This works great if you need to...rapidly develop a dynamic web
application! When you try to get cold fusion (or any language for that
matter) to perform functions outside of its' skill set, thats when you
start getting into trouble.
It depends on what you mean by the next best software
You probably will need to do something like this to parse it
cfxml variable=myxml
rootelement#mypacket#/rootelement
/cfxml
I believe (though I could be mistaken) that error indicates that there
are multiple tag-pairs at the root. Valid XML must have only one
tag-pair at the root with all other
make a div containing both the image and the caption, and float the
div.dont' float the image, just use whatever alignment you need to
get it and the caption to lay out how you want it.
cheers,
barneyb
On Mon, 26 Jul 2004 13:16:13 -0400, Damien McKenna
[EMAIL PROTECTED] wrote:
I've been given
I have a page that lists all the variables from all the scopes. In CF5, I
had variable existence conditions, so that I would not output the cfcatch
scope unless it was both defined and a structure. However, this block of
code did not work under CFMX 6.1, so I poked around to find out why.
1 - 100 of 168 matches
Mail list logo