This is incorrect use of DESCRIBE. If you want a table struct you should
use a select query which cross references the sysobjects table.
This should give you what you need.
select syscolumns.name,systypes.name,syscolumns.length from sysobjects
inner join syscolumns on syscolumns.id =
DESCRIBE is an SQL Plus command, if i recall. You could easily enough
make a stored procedure to do it in MS SQL I suppose though...heck
someone may have already done it. You could just use Neil's SQL
statement he posted and put it into a cursor and output it all nifty
dandy like SQL Plus does,
So I asssume the JSeditor works the same way...you have to work in a
.js file for it to kick in?
Adam H
On Mon, 31 Jan 2005 00:06:41 -0500, Michael T. Tangorre
[EMAIL PROTECTED] wrote:
From: Nathan Strutz [mailto:[EMAIL PROTECTED]
To expand on what Rob said, the CSS Editor plugin doesn't
Paul,
You are correct, I guess I should have added a disclaimer that while
it is possible to usse keywords, it is not good practice to do so.
On Sun, 30 Jan 2005 11:35:10 +0700, Paul Hastings
[EMAIL PROTECTED] wrote:
Scott Stroz wrote:
You can still use keywords, you just need to put [ ]
OR, you could specify the content in a persistent variable scope (such
as session) and then output th econtent on the printer-friendly
version.
On Sat, 29 Jan 2005 19:36:41 -0800, Bob Haroche
[EMAIL PROTECTED] wrote:
This is exactly what the CFSaveContent tag does. It saves whatever
Yep...if you go under behaiviors in the design panel, you'll see a
Open Browser Window behaivior (or something like that) where you set
the url, size, options, etc...
-joe
On Sun, 30 Jan 2005 20:17:38 -0400, Will Tomlinson [EMAIL PROTECTED] wrote:
Will, do you have Dreamweaver MX?
Yes Joe,
Yep...if you go under behaiviors in the design panel, you'll see a
Open Browser Window behaivior (or something like that) where you set
the url, size, options, etc...
And, in case you need more, you can get this:
http://www.massimocorner.com/dw/behaviors/win_suite.mxp
Have you considered using cfinclude rather than cflocation?
eg:
cfswitch expression=#cgi.server_name#
cfcase value=mysite1.com
cfset brand = mysite1
/cfcase
cfcase value=mysite2.com
cfset brand = mysite2
/cfcase
cfdefaultcase
Johnny
Just to clarify, are you referring to lots of if statements in code in
general or lots of if statements in a fusebox switch file? If you were
referring to the latter then I would agree and say that in fusebox - you
should not have the majority of your logic within the switch file..is that
check out google
http://www.google.com/search?q=wap+simulatorssourceid=mozilla-searchstart=0start=0ie=utf-8oe=utf-8client=firefox-arls=org.mozilla:en-US:official
look at developer.openwave.com for an emu. Some mobile
manufactures/carriers have developer programs too.
In light of this discussion, how about lots of cfif statements buried in
html...?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, January 31, 2005 8:46 AM
To: CF-Talk
Subject: RE: better way to code?
Johnny
Just to clarify, are you referring to lots
I've written a small app that parses the SQL Server metadata stored
procedures. It will display all the relevant data for any SQL Server
table, view, or sproc, including indexes, columns and datatypes, and
sproc CREATE text.
It also generates lists of columns names in several formats,
CFARGUMENT
Look into a sourceforge project called OneJar - let's you bundle an
entire application with all required libraries into a single jar using
classloaders. Lets you get around classpath problems, but at the cost of
a significantly larger installation!
/t
-Original Message-
From: [EMAIL
Correction, a demo of the application can be viewed here:
http://w2ksrv1.neo.servequake.com/dbanalyzer/index.cfm
This is using the SQL Server Northwind sample application.
The userID/Password are admin/admin.
Have a good one.
J
On Mon, 31 Jan 2005 08:11:03 -0600, Jared Rypka-Hauer - CMG, LLC
Calvin
Depends, In most cases you can do any conditional logic before rendering
your page but obviously there are exceptions such as when the result of the
condition determines what html is being displayed (and not something else
such as if the user should be redirected or a session variable
Anyone out there with experience with CFWebstore that wouldn't mind
helping me through an issue (off list)?
Cutter
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.8.2 - Release Date: 1/28/2005
Cutter (CF related) wrote:
Anyone out there with experience with CFWebstore that wouldn't mind
helping me through an issue (off list)?
Cutter
Kick ass product.
As I understand it, their support is pretty good, too.
--
Alex Sherwood
Director, Internet Services
PHS Collection Agency
I'm hoping that the collective brainpower out there can come to the rescue!
We've been running into problems with our current processor (Suntrust) with
terminal-based processing. We have a terminal on a dedicated analog line that
works fine, and pulled our spare out of the close to test it
I'm trying to open iexplore in the appserver with a template that contains
the following:
cfexecute name=C:\...\run_test.cmd timeout=10
/cfexecute
run_test.cmd has the following line in it:
start iexplore.exe
But I can't get it to open iexplore on the server. I also tried using a
batch
Hi all,
I'm using a simple XML doc to populate image captions in a Flash photo
gallery. One of the caption/caption statements in the XML has the need
to display multiple paragraphs. I don't care about any other formatting
beyond that. Is there a good/easy way to force line breaks in XML (like
On Sun, 30 Jan 2005 21:43:35 -0400, Terry Ford [EMAIL PROTECTED] wrote:
Hey all,
In the process of performing a yearly upgrade I was quite surprised to find
that my CGLOBAL and CDATA tables contained over 20 million (yes, million)
entries each, and the CGLOBAL.MYD file alone had a size of
As a partial answer, remember that you are executing commands under
the account that the CF Service is logged in as. You may in fact be
launching your program, but nobody can see it because it is opening up
under a different user account. Task Manager should tell you whether
these tasks are
I have only read a little about this but it looks interesting...does
anyone know if this can be used on CF5? We are stuck in CF5 still and
the company wants to move towards RUP, which is strongly tied to OOP,
so there is a need to get OOP kick started now until we can get intoMX
or Blackstone or
Line break as in [br] or linebreak as in CHR10+CHR13?
Mark Leder wrote:
Hi all,
I'm using a simple XML doc to populate image captions in a Flash photo
gallery. One of the caption/caption statements in the XML has the need
to display multiple paragraphs. I don't care about any other
Which ever works, I'm not concerned about HTML display at all here, just
showing a space between a couple lines of text.
-Original Message-
From: Alex Sherwood [mailto:[EMAIL PROTECTED]
Sent: Monday, January 31, 2005 10:46 AM
To: CF-Talk
Subject: Re: XML/XSLT Line Break
Line break as
Dear list,
In my task management system, certain people have access to certain
projects.
I'd like an admin screen for each project that displays all the people
with a checkbox beside their name. The sysad can check or uncheck
people as necessary.
But I'm a bit confused how best to execute
I'm a little confused. Can you post a sample XML document, and mark
where the line breaks should be?
If I understand, you want to be able to embed line breaks in the caption
text and then have the line breaks be refelected when the caption text
is displayed? The front end is Flash, right?
Jared,
I can't log in. Does your app require cookies to be enabled?
Andy
-Original Message-
From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED]
Sent: Monday, January 31, 2005 8:21 AM
To: CF-Talk
Subject: Re: MS SQL 2000 Table Structure Print out
Correction, a demo of the
Chris,
1) in the htmp project form, give all the employee checkboxes the same
NAME, but use the employee id as the VALUE. That way, when you submit
the form, you will have one single variable (the NAME) with a list of
employee ids (the VALUES).
2) first delete all the entries for this PROJECT in
How would I modify an insert query to grab the id ( autonum, primary key ) of
the item that I just inserted?
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
Which DB are you using?
-Original Message-
From: Protoculture [mailto:[EMAIL PROTECTED]
Sent: 31 January 2005 15:10
To: CF-Talk
Subject: grabbing the id of a newly created item..
How would I modify an insert query to grab the id ( autonum, primary key
) of the item that I just
ACCESS
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192335
Archives:
select @@identity from tableName
will return the last inserted id, assuming mssql
tw
On Mon, 31 Jan 2005 16:09:10 -, Craig Dudley [EMAIL PROTECTED] wrote:
Which DB are you using?
-Original Message-
From: Protoculture [mailto:[EMAIL PROTECTED]
Sent: 31 January 2005 15:10
To:
Alex,
Thanks for looking into this with me.
Here's an XML snip, showing two different pic captions. The second
caption, I inserted a br / to show where I would want a break for a new
paragraph.
To see the actual flash, go to http://www.pearlywhitesmile.com/testimonials/
==
?xml
If you're using SQL Server, you can put the insert in a procedure, wrap
it in a transaction, and run something like this at the end:
SET @NEWID = SCOPE_IDENTITY()
This will return the most recent primary key created.
- Jim
Protoculture wrote:
How would I modify an insert query to grab the id
what about using access
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message:
I don't think there's a neat way of doing it for Access, I could be
wrong though.
So, I suggest just doing a select for max(your_autonum_ID) in another
cfquery directly after the insert, probably safer to wrap both the
queries in a cftransaction too.
-Original Message-
From: Protoculture
Thanks Craig. Just to confirm that code..
Select For Max(ID)
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message:
More like;
Select Max(ID) as MyNewID FROM yourtablename
-Original Message-
From: Protoculture [mailto:[EMAIL PROTECTED]
Sent: 31 January 2005 15:34
To: CF-Talk
Subject: Re: grabbing the id of a newly created item..
Thanks Craig. Just to confirm that code..
Select For Max(ID)
I don't think there's a neat way of doing it for Access, I
could be wrong though.
http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=79
Couple of methods ... Could be rewritten in CF if needed
--
dc
~|
Logware
Hmmm... I'm using cflogin with session storage... it shouldn't.
I'll post the info again...
http://w2ksrv1.neo.servequake.com/dbanalyzer/
userID/pwd is admin/admin
That SHOULD get you in, if it doesn't let me know and I'll try something else...
Laterz,
J
On Mon, 31 Jan 2005 09:58:48 -0600,
Okay, so I'm running a little cflogin. I run it on localhost, and it works
fine. In fact, it's calling the right SQL database, and everything's fine.
Now, I move the page over to my development server. Same page, same code,
same *database*...different results. It doesn't tell me that the data
Unfortunately, I don't think that CF/MX actually saves a session cookie, but
saves a permanent cookie. Or, perhaps I've got IE set up wrong :-)
-Original Message-
From: Jared Rypka-Hauer
Hmmm... I'm using cflogin with session storage... it shouldn't.
I'll post the info again...
What's the way in which you can restart CFMX service with CFML code
natively?
Jon
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project
I've been having trouble with a server where the CFMX process gets hung up
and it logs all kinds of bizarre error messages in the Jrun default log
file. I think its because I was using the newest version of apache 2 which,
I'm assuming, must not be compatible with the newest version of CFMX. Since
I see now.
I have very little experience with Flash as a font end, but it seems to
me that you would need to have Flash recognize the line break some how.
I don't know how flash renders text, but if it can render basic HTML,
then your fine.
Try embedding a CFLF where the br/ tags are, ala:
Typically, I would recommend using a UUID for a primary key, have CF
generate it (consider altering the function to do a MS version of a UUID,
since you are using access and will likely go to MSSSQL Server, check
cflib.org for that), and then you can reference it easily without any
question that
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jon Block wrote:
|What's the way in which you can restart CFMX service with CFML code
|natively?
|
|Jon
|
CFEXECUTE NAME=/opt/coldfusionmx/bin/coldfusion ARGUMENTS=restart
Note that you must allow whatever user CFMX/Apache is running as
permissions
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jon Block wrote:
| I've been having trouble with a server where the CFMX process gets
| hung up and it logs all kinds of bizarre error messages in the Jrun
| default log file. I think its because I was using the newest
| version of apache 2 which,
Actually IIRC this is now possible in access (although I haven't tried it
myself)
http://cfmxplus.blogspot.com/2002/08/oh-my-select-identity-works-in-access.h
tml
Kola
-Original Message-
From: COLLIE David [mailto:[EMAIL PROTECTED]
Sent: 31 January 2005 16:37
To: CF-Talk
Subject:
I only download stable releases but I downloaded the latest stable release
of apache 2 and I had big time problem swhere the cfmx process would seize,
log errors in the default jrun error log, and I haid to restart the whole
machine to get it to begin to work again. Downgrading to apache 1.3.33
I thought about this but I don't have a good method of marking rows. I
have been looking in to javascript but I don't know how to get at js
vars with coldfusion.
- Charles
On Jan 29, 2005, at 1:35 AM, Martin Parry wrote:
If you have distinct blocks or rows of a table etc. in the page you
You are on the right track having this link table.
I would probably maintain an active flag, a start date, and an end date, in
my link table. When a person becomes inactive on a project, I'd switch the
flag and establish the end date. Each reassignment of a person to a project
would get a new
That is correct, I used it a few years ago when Access 2000 came out.
- Matt Small
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, January 31, 2005 12:03 PM
To: CF-Talk
Subject: RE: grabbing the id of a newly created item..
Actually IIRC this is now
CS can output JS code just as well as it outputs HTML code. You just write the
dynamic JS; this is then sent to the client and acted on. You are not getting
at JS variables; you are creating dynamic JS code.
cfoutput
script
function foobar()
{
var JSvar = #CFvalue#;
}
/script
Unfortunately, I don't think that CF/MX actually saves a
session cookie, but saves a permanent cookie.
By default, if you're using CF session management, CF will set two
persistent cookies, CFID and CFTOKEN. If you're using J2EE session
management, CF will set a single session cookie,
I'm trying to open iexplore in the appserver with a template
that contains the following:
cfexecute name=C:\...\run_test.cmd timeout=10 /cfexecute
run_test.cmd has the following line in it:
start iexplore.exe
But I can't get it to open iexplore on the server. I also
tried
OK, then...
For purposes of demonstration, I have removed the cflogin restriction
to the application. Since it's just hitting the Northwind datasource,
I'm not terribly concerned.
SO, without further ado, please use this URL:
http://w2ksrv1.neo.servequake.com/dbanalyzer/index.cfm
NO USERNAME, NO
Yup yup
On Mon, 31 Jan 2005 07:00:56 -0500, Adam Haskell [EMAIL PROTECTED] wrote:
So I asssume the JSeditor works the same way...you have to work in a
.js file for it to kick in?
Adam H
On Mon, 31 Jan 2005 00:06:41 -0500, Michael T. Tangorre
[EMAIL PROTECTED] wrote:
From: Nathan
There are a couple tricks to do this, but I think your best bet would
be to add a cdata section to your xml - I think that will solve your
problem. So:
caption![CDATA[ I now have a natural looking radiant smile that receives
constant compliments and additionally have no more headaches! --
Gina
I see plenty of tools to create pdf's with cf but can any tools create a jpg
out of a pdf?
Emmet
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours
Dear list,
I'm getting this error message:
--
Attribute validation error for tag cfloop.
The value of the attribute query, which is currently insert_people,
is invalid.
--
I guess there's something wrong with my INSERT statement but I can't
figure out what it is. I've tried permutations
Thanks. I've got to change my site!
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Monday, January 31, 2005 11:27 AM
To: CF-Talk
Subject: RE: MS SQL 2000 Table Structure Print out
Unfortunately, I don't think that CF/MX actually saves a
session cookie, but saves
Nice. Can you email me the code off-line?
Andy
-Original Message-
From: Jared Rypka-Hauer -
OK, then...
For purposes of demonstration, I have removed the cflogin restriction
to the application. Since it's just hitting the Northwind datasource,
I'm not terribly concerned.
SO, without
This is actually pretty easy in ACCESS:
1) put the enire transaction within a CFLOCK block
2) do the insert
3) then select max(id) assuming you have an autonumber field for the id
Which will give you the id of the record just inserted.
This is so easy that even I can do it.
Rick Colman
Hey all, anyone got a simple method to protect a var used in a where clause
where we cannot use cfqueryparam?
Example:
OR P.Keywords LIKE '%#Url.SearchString#%'
And search string can be entered by the public
thanks
~|
Great, I'll try this.
Thanks,
- Charles
On Jan 31, 2005, at 9:16 AM, Ian Skinner wrote:
CS can output JS code just as well as it outputs HTML code. You just
write the dynamic JS; this is then sent to the client and acted on.
You are not getting at JS variables; you are creating dynamic
gabriel l smallman wrote:
Hey all, anyone got a simple method to protect a var used in a where clause
where we cannot use cfqueryparam?
Example:
OR P.Keywords LIKE '%#Url.SearchString#%'
Use cfqueryparam:
P.Keywords LIKE cfqueryparam value=%#Url.SearchString#% ...
Jochem
You can't loop over the results of an insert query, because an insert
query produces no results.
You can only use CFLOOP with select queries.
- Rick
Chris Kavanagh wrote:
Dear list,
I'm getting this error message:
--
Attribute validation error for tag cfloop.
The value of the
Ummm...don't you mean CFTRANSACTION...and not CFLOCK??
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com
Hello,
I'm new to using XML parsing in coldfusion so I hope I'm phrasing this
question properly. I was wondering if it's possible to query a xml doc
and return all of the attribute names (Name, Address, City). I have a
long list of them and I would like to make my form as dynamic as
possible.
gabriel l smallman wrote:
Hey all, anyone got a simple method to protect a var used in a where clause
where we cannot use cfqueryparam?
Why can't you use cfqueryparam?
OR P.Keywords LIKE '%#Url.SearchString#%'
OR P.KEYWORDS LIKE cfqueryparam cfsqltype=cf_sql_varchar
Hi,
I usually add my custom code to CFML templates that return a lot of
records from a db query to add the paging functionality (next/previous
page buttons).
Is there any UDF or CFC that can be easily plugged into any CFML
template that requires paging functionality?
I checked the cflib.org and
Hi,
I found this great article about the undocumented ColdFusion query object:
http://www.cfdev.com/mx/undocumentation/query.cfm
Does anyone know if the undocumented feature still work with
ColdFusion MX 7 (Blackstone)?
Thanks.
I've got one that I use. It's just a UDF. I'll send it to you off-list.
- Original Message -
From: xxx xxx [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Monday, January 31, 2005 12:37 PM
Subject: query paging UDF or CFC
Hi,
I usually add my custom code to CFML
Search for cfpagnation was a custom tag but I suspect with a little
tinkering could be made into udf or cfc. Works quite well and is pretty
flexable
~|
Logware (www.logware.us): a new and convenient web-based time tracking
[EMAIL PROTECTED] wrote:
Ummm...don't you mean CFTRANSACTION...and not CFLOCK??
It should be both if using that kinda dated method.
http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_17000
That article is a golden oldie but it explains the reasons why rather well.
I personally do
Have you looked into using XMLSearch function?
On Mon, 31 Jan 2005 10:38:16 -0800, Charles Heizer [EMAIL PROTECTED] wrote:
Hello,
I'm new to using XML parsing in coldfusion so I hope I'm phrasing this
question properly. I was wondering if it's possible to query a xml doc
and return all of
That's a horrible way to do it. Quite inefficient.
A better route is to check your DB's docs and see how they expose the
last inserted sequence value. In MySQL it's LAST_INSERT_ID(), with MS
SQL Server its one of three @IDENTITY variables. Run your INSERT, and
then select the value back out
Well to start with, in your code example, name, address and city are child
notes, not attributes.
SERVICE
NameCharles/Name
Address123 Main St./Address
CityLivermore/City
/SERVICE
If your document was formatted like this, they would be attributes.
SERVICE
Dear list,
My CFLOOP doesn't seem to be looping my INSERTS.
A form passes the variables #person_id# #project_id# to this page:
head
CFQUERY NAME=get_people DATASOURCE=taskomatic
SELECT person_id FROM people
WHERE person_id = '#Form.person_id#'
/CFQUERY
/head
body
CFLOOP
Barney Boisvert wrote:
That's a horrible way to do it. Quite inefficient.
A better route is to check your DB's docs and see how they expose the
last inserted sequence value. In MySQL it's LAST_INSERT_ID(), with MS
SQL Server its one of three @IDENTITY variables. Run your INSERT, and
then
are you sure your query is returning records? do a
cfoutput#get_people.recordcount#/cfoutput after your /cfquery to
make sure.
On Mon, 31 Jan 2005 19:07:13 +, Chris Kavanagh [EMAIL PROTECTED] wrote:
Dear list,
My CFLOOP doesn't seem to be looping my INSERTS.
A form passes the
I made one called CF_PageList which creates the Next/Previous links and the
pages very much like Google. It'll move the page range as you go through the
links. Check out www.cornfeed.com for a demo and the download.
Thanks,
Cedric
Hi,
I usually add my custom code to CFML templates that return
Rob and Alex,
The CDATA trick worked well for this application.
Thanks for your help.
Mark
-Original Message-
From: Rob [mailto:[EMAIL PROTECTED]
Sent: Monday, January 31, 2005 12:42 PM
To: CF-Talk
Subject: Re: XML/XSLT Line Break
There are a couple tricks to do this, but I think
For a low volume site it works alright, as efficiency probably isn't your
biggest concern. If you're using Access it can probably be assumed that
the application is fairly low volume.
There are some added considerations, though, that make this approach less
than foolproof:
- You have to make
Why can't you use cfqueryparam?
I have actually experienced this myself with the following, and only
on MS SQL Server. The same statement works great in mySQL, Access and
Oracle. In the code below, if we are running SQL Server
(localgrid.usedb=2) execution branches to bypass cfqueryparam.
Not necessarily. One of the SQL Server variables is a global
variable, so you can call it anytime for the last ID, with no
knowledge of who inserted it or even what table. If that's what you
care about, then a transaction is irrelevant. WIth MySQL's
LAST_INSERT_ID() it's tracked by connection
Your person_IDs var probably holds a list of IDs (or a single ID)so you
need to use an IN cluse in your first SELECT to get multuple records to then
use to loop over and do your inserts.
like so:
head
CFQUERY NAME=get_people DATASOURCE=taskomatic
SELECT person_id FROM people
WHERE
If you are on SQL Server 2000 you can use the SCOPE_IDENTITY() function
which will work independant of Triggers and other transactions on the same
table.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sa-ses_6n8p.asp
I've switched all of my code to use this
CFQUERY NAME=get_people DATASOURCE=taskomatic
SELECT person_id FROM people
WHERE person_id = '#Form.person_id#'
/CFQUERY
This query is only going to return one record, assuming person_id is an unique
key. I suspect what you may be wanting is a IN clause
CFQUERY NAME=get_people
That's only reliable inside a transaction. Don't leave that part out.
AND a named lock to choke the process down to a single user. Adding
in all of that overhead makes for a serious potential bottleneck in
performance, imho, so I never do it. If you can optimize for a single
db platform then
In either case, cftransaction isn't guaranteed (it's only a recommendation,
and does it work with Access?) and cflock won't work across multiple servers
in a load balanced environment...
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Monday, January 31, 2005
On 31 Jan 2005, at 7:12 pm, Charlie Griefer wrote:
are you sure your query is returning records? do a
cfoutput#get_people.recordcount#/cfoutput after your /cfquery to
make sure.
Ah! Now we're getting somewhere. No: when I check multiple boxes on
the form that gets me here, it sends one
:D it now loops. The IN clause fixed it. Thanks everybody.
- ck.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
cflock won't work across multiple servers
in a load balanced environment...
And I hope no one uses Access for that!
-Joe
--
For Tabs, Trees, and more, use the jComponents:
http://clearsoftware.net/client/jComponents.cfm
~|
Matt,
I use LIKE all the time in MS SQL with CFQueryParam...just to make
sure my head is screwed on straight, I just ran the following against
an nvarchar column:
cfquery datasource=alex name=foo
where SomeColumn like cfqueryparam cfsqltype=cf_sql_varchar
value=%#SomeValue#%
/cfquery
On Mon, 31 Jan 2005 19:25:36 +, Chris Kavanagh [EMAIL PROTECTED] wrote:
On 31 Jan 2005, at 7:12 pm, Charlie Griefer wrote:
are you sure your query is returning records? do a
cfoutput#get_people.recordcount#/cfoutput after your /cfquery to
make sure.
Ah! Now we're getting
As I understand it, their support is pretty good, too.
I certainly try! IMO, good support is just as important as having a kick ass
product.
You can email me directly for help, or the CFWebstore email list on Yahoogroups
is also a great place to get assistance from other developers.
Like I said Chrisyou need the IN clause...will work with single or
multiple IDs passed in ;-)
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web:
1 - 100 of 216 matches
Mail list logo