I need to have the table in my SQL query created dynamically. Every
syntax scheme that I've tried has failed.
SELECT *
FROM #variable#
WHERE ID=#ID# etc. etc.
Any clues on how to phrase this so CFQUERY likes it would be greatly
appreciated.
I do this sort of thing all of the time - as
What's the data type of the times column, and do you have the times column
in more than one table?
I've done this kind of order by on hundreds of multi-tabl queries without
ever having to use a column number. I have, however, had quite a few similar
problems when I've accidentally set the column
Hi,
Have a look at PL/SQLP Developer
http://www.allroundautomations.nl/plsqldev.html, nice and inexpensive tool.
Dominique
-Original Message-
From: Troy Hiltbrand [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 04, 2001 8:55 PM
To: CF-Talk
Subject: OT: Oracle Client Tools
I
Rather than exporting to a csv, you could get them to build a table, you
could then have a link to that table in your access database vai internal
ODBC, build a query to insert or whatever with the records and then execute
that from CF.
-Original Message-
From: James Maltby
Please excuse this off-topic post, but I really have to thank Kelly
Matthews, whose solution to my form/query problem worked beautifully, as
well as Randy, Jeff. Phoen, Christopher, and Al, whose suggestions I also
printed, pored over, and learned from.
This list is awesome, and as a CF newbie
It's not in CF, it's done through your webserver. You add the extensions
you wish to be parsed as cold fusion types. For example, in Apache:
AddHandler type-coldfusion .mml
DirectoryIndex index.mml
Adds the extension .mml to be parsed by CF. (.cfm is added as part of the
cf module)
I'd rather
Hi guys,
Got an interesting one here. I am encrypting some details before entering
them in a databse, then decrypting them as the authorised views them.
However, I am getting this error on decryption:
Error Diagnostic Information
An error occurred while evaluating the expression:
Or, ugly but cheap, no offense James, if it has to be csv you could have the
csv as an ODBC datasource and loop round in CF to do it.
-Original Message-
From: James Maltby [mailto:[EMAIL PROTECTED]]
Sent: 30 March 2001 11:45
To: CF-Talk
Subject: Import data to ACCESS
Here's a dudy for
No offence taken Kevan! We've looked down that route, however the main
problem we are getting with .csv odbc (you need a .ini file too btw) is that
it no likes "date" - can't seem to get the one to pass into access - no
matter what variations we try - lsdateformat - thru to - odbcdatetime,
Having no idea what the original topic was...
You're always welcome to post solutions or a 'best of list' that
encompasses the best info from your replies. Even stuff that is considered
simple by some is still unknown to others.
At 06:55 AM 04/05/2001 -0400, you wrote:
Please excuse
A very nice, tag, but I had a few issues with it.
I moved the first cfset of TheColumnList to be after the Attributes.Header
check, and set the former to the latter. This means the order of the
outputted columns is the same as the order specified in the headers
argument, and also means that the
As the list strips attachments:
!---
NAME: CF_Query2Excel
AUTHOR: Ali Taleb
DATE: 3 March 2000
REV: 4/4/2001 Thomas Chiverton, [EMAIL PROTECTED]
Improved error handerling for blank fields in rows
Takes note of Headers setting and uses that to order columns
DESCRIPTION:
Cold
I've gotten this message too.
On a side note, if you use any decrypted values in a query - decrypt the
value outside of the query (set a variable equal to the decrypted value
first)...
Got an interesting one here. I am encrypting some details before entering
them in a databse, then decrypting
Hi Thomas... you got a small typo in thereif you cut and paste your code
from the email into studio, it is at line #166
cfset TheString "#TheColValue#"
should be
cfset TheString = "#TheColValue#"
Looks pretty cool!
Erika
"Money is not required to buy one necessity of the soul."-Henry
are there any difficulties in maintaining thorough session management on a
hosted cf server??
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives:
Some questions regarding this tag:
1) I did like you asked in the comments of the tag I simply created a
page which had a link to a .cfm page that just contains my query and the
call to the tag below it. When I click on the link though, all I get is my
actual .cfm code (query and tag call)
cfset TheString "#TheColValue#"
Odd ! Localy, and in my sent mail, there *is* an '=' there...
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives:
cfqueryparam doesnt seem to be doing as expected:
cfquery name="contacts" datasource="Contacts"
SELECT ID, FirstName, LastName, JobTitle,BusinessPhone FROM exoduscontacts
WHERE
LastName like '%cfqueryparam value="form.what"%' ORDER BY LastName ASC
/cfquery
Debugging shows
Form Fields:/B
Personally I've never used the CFQueryparam tag, but Surely the query should
read,
cfquery name="contacts" datasource="Contacts"
SELECT ID, FirstName, LastName, JobTitle,BusinessPhone FROM exoduscontacts
WHERE
LastName like '%#form.what#%' ORDER BY LastName ASC
/cfquery
Jason Lees
Okay this might be off the wall, but it escapes me as to the reasoning of
this.
I have a query that runs and generates between 200-2000 records to be
displayed
to the user. When the record count is low say below 300 or 4000, it will
spit out
the desired results without a problem.
However when
If your getting CFML in the excel spreedsheet, what CFML are you getting ?
As to forcing a browser to download content, see a previous thread on here
:-)
-Original Message-
From: Erika L Walker [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 1:54 PM
To: CF-Talk
Subject: RE:
Future warning: All HTML attributes will be required to be quoted to comply
with XHTML. My personal recommendation is to use double quotes now. To
escape them in a CFSET you could use cfset pathstring="a href" chr(34)
"blah.cfm" chr(34) "/a"
DC
- Original Message -
From: "Kelly
Friends:
I thought that I had this solved, but not quite. Can anyone help?
The problem: I need to search on a "yes/no" column - several of them -
allowing the user to choose that this field "Doesn't Matter" or else "Yes".
There's a search page and a results page. The database has a column
Personally I've never used the CFQueryparam tag, but Surely the query
should
read,
:goes to a web site you've written and types into a form box:
wibble';drop table *;select * where lastname='wibble
Oops...
LastName like '%#form.what#%' ORDER BY LastName ASC
Yes, unsurprisingly that works,
You could also look at TOAD from Quest software.
-Original Message-
From: DDE [SMTP:[EMAIL PROTECTED]]
Sent: 05 April 2001 09:23
To: CF-Talk
Subject:RE: Oracle Client Tools
Hi,
Have a look at PL/SQLP Developer
http://www.allroundautomations.nl/plsqldev.html, nice and
Thank you!
-Original Message-
From: Teng-Yan Loke [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 04, 2001 11:11 PM
To: CF-Talk
Subject: RE: Concurrent users and client certificates
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Try this:
The SQL syntax generated by the ColdFusion server is dependent on the target
database.
For an ODBC, DB2, or Informix data source, the generated syntax of the SQL
statement is as follows:
SELECT *
FROM courses
WHERE col1=?
For an Oracle 7 or Oracle 8 data source, the syntax of the
Thomas,
1) Here's the CFML ... it's just what is in the .cfm page that runs the
query and calls the tag.
cfquery name="getdata" datasource="datasource_name" dbtype="ODBC"
select * from USERS
/cfquery
cf_query2excel query="getdata"
Only it displays this in an excel page.
2) Thanks, I'll look
You need to assign a value to the Doesn't Matter such as this
select name="hashottub"
option VALUE="0" selectedDoesn't Matter/option
option value="1"Yes/option
/select
Then your query would read:
cfquery name="rs2"
Your ORDER BY needs to be ORDER BY TABLE.TIMES because you returned all of
the columns with * .
Thank You,
Peter
Peter J. MacDonald II
Creative Computing, Inc.
100 Middle Street
Lincoln, RI 02865
Phone: 401.727.0183 x123
Fax: 401.727.4998
Portable: 401.965.3661
E-MAIL: [EMAIL PROTECTED]
Web
Fair comment,
Jason Lees
National Express
Systems Department.
E-Mail : [EMAIL PROTECTED]
-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 2:23 PM
To: CF-Talk
Subject: RE: Oddness with cfqueryparam
Personally I've never used the
Thanks for everyone's replies.
I ran the query and a cfoutput to see what it spat out, without including
the template, and it worked fine as it should. So the problem seems to be
in the template (it queries viewed_numbers which must be causing problems),
Cheers anyway
Will
--
[EMAIL
Is the query cached? I've had this problem with cachedwithin in the past.
Will
--
[EMAIL PROTECTED] -=- www.lukrative.com
Local-Advertising -=- www.localbounty.com
- Original Message -
From: ""Adkins, Randy"" [EMAIL PROTECTED]
Newsgroups: dotcom.lists.cftalk
Sent: Thursday, April 05,
Try this...give doesn't matter a unique value in the select list such as 5.
In your SQL then do...
select stuff
fromtable
where conditions that will always be present
cfif hashottub is not 5and hashottub = #hashottub#/cfif
*** REPLY SEPARATOR ***
On 4/5/2001 at
which browser are you viewing the results in? maybe the browser is timing
out? how long does the query take with what you're calling "low" and "high"
recordcounts?
-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 6:16 AM
To: CF-Talk
regarding your tag line (sorry, couldn't resist)
http://www.snopes2.com/cokelore/tadpole.htm
-Original Message-
From: John Wilker [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 03, 2001 11:26 PM
To: CF-Talk
Subject: RE: Documentation (Was: Stupid Question? -
Commenting Code That
is there anyway to output the last primary key number in a table after an
insert statement?
i need to capture that number on the same action page so i can pass it to
another table.
in other words, on my insertApp.cfm i have the query to update my apps
table.
but on this same page at the
Randy (and/or anyone else willing to help!) -
Thanks very much. But I've trying this exactly the way you've shown (code is
quoted at the very bottom of this message), and I get an error message,
which I've pasted directly below. Any idea why??
The column name in the database is 'cabinHottub'..
Here is a dynamic query:
CFSET FIRSTREC=0
CFSET SQL="SELECT "
CFLOOP QUERY="GetHeaders"
CFIF FindNoCase(FIELDNAME1, Form.Display, 1) NEQ 0 OR OPTIONAL IS 0
CFIF FIRSTREC IS 1
CFSET SQL=SQL ", "
/CFIF
CFSET SQL=SQL FIELDNAME1
/CFIF
CFSET FIRSTREC=1
/CFLOOP
CFSET SQL=SQL " FROM PI.PI WHERE
Thank you, thank you, thank you.
Carol L. Bluestein
Senior Programmer
NYS Office of Real Property
518-486-6335
[EMAIL PROTECTED]
Reply Separator
Subject:RE: CFSCRIPT "switch" Brain Burp
Author: [EMAIL PROTECTED]
Date: 4/4/01 9:05 PM
Looking
If it's SQL SERVER use: SELECT @@IDENTITY immediately after inserting
--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
--
United
Becky see http://www.allaire.com/Handlers/index.cfm?ID=1463Method=Full
-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: 05 April 2001 15:02
To: CF-Talk
Subject: update
is there anyway to output the last primary key number in a table after an
insert statement?
i
The blank page will display within say 10 - 15 secs.
If that.
It is baselined to run on IE 5.x
-Original Message-
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 9:51 AM
To: CF-Talk
Subject: RE: Maybe a silly question.
which browser are you viewing the
I thought out that as well, however this is a dynamic query
that the results of the query changes frequently. It is
not cached.
I have consider timeouts on the server however, I can turn
right around and execute another query with less results
and they will display. This happens
For an ODBC, DB2, or Informix data source, the generated syntax of the SQL
statement is as follows:
SELECT *
FROM courses
WHERE col1=?
Yeah, I just read that too... so that means cfqueryparam is actualy
completly useless.
:writes own tag and grumbles.
Short answer - almost always. Unfortunately, thats only almost good enough.
If you do sql like
select pkey_col
from table
where x
And fill in with the data that you just inserted, it will work
99.99% of the time. But not 100%. Depending on your data, it might
work 100% of the
Here's an example. The NOCOUNT is inportant in SQL Server, I'm not sure in
other DBMS's:
cfquery name="insertEmail" DATASOURCE=#request.server.myDSN#
SET NOCOUNT ON
insert into emailContent
try
cfquery.PreserveSingleQuotes(SQL)cfquery
Mark Rowntree
Senior Application Developer, Freeserve, The Observatory
36-41 Clerkenwell close, Clerkenwell, London, EC1R 0AU
Tel: 0207 5534834, Mob: 07973 860398
~~
Structure your ColdFusion
Have you tried using the PreserveSingleQuotes()
Steven Semrau
SRA International, Inc.
Senior Member, Professional Staff
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Com: (703) 805-1095
DSN: (703) 655-1095
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday,
Your Order by Line should not contain:
AND hashottub = 1
Did you assign a value to the checkbox for "Doesn't Matter"?
-Original Message-
From: P@tty Ayers [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 9:58 AM
To: CF-Talk
Subject: Re: Newbie problem: Search on Yes/No Column
What db you using???
-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: 05 April 2001 15:02
To: CF-Talk
Subject: update
is there anyway to output the last primary key number in a table after an
insert statement?
i need to capture that number on the same action page
I have some code on my page using CFHEADER and CFCONTENT that allows the
download of a CFOUTPUT to a text file. Is there anything I can use on
that page, aside from a CFLOCATION or CFABORT to stop the output of the
server to the text file?
Also, is there an easy way to create an RTF or Word doc
Select MAX(ID)
From Mytable
-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 10:02 AM
To: CF-Talk
Subject: update
is there anyway to output the last primary key number in a table after an
insert statement?
i need to capture that number on
Use the PreserveSingleQuotes() function when passing your sql string to the
database.
DC
- Original Message -
From: [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, April 05, 2001 10:00
Subject: Single quotes misbehaving
Here is a dynamic query:
CFSET FIRSTREC=0
thanks. but it is going to an access database.
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 10:06 AM
To: CF-Talk
Subject: RE: update
If it's SQL SERVER use: SELECT @@IDENTITY immediately after inserting
I had a situation a while back where I selected a large no of records into a
select box in a form on a page and it didn't display any at all. Almost as
if it ran out of memory or something. Worked ok in IE 5 but not on anly
lower browser or on a Mac.probably a completely differenty thing
P@tty,
Move the ORDER BY clause to the end of everything else and give it a try.
Alec
-Original Message-
From: P@tty Ayers [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 9:58 AM
To: CF-Talk
Subject: Re: Newbie problem: Search on Yes/No Column
Randy (and/or anyone
P@tty,
I think the problem is with your Order By clause:
ORDER BY cabinName AND hashottub = 1
Specifically with "AND hashottub = 1". You can Order By hashottubs but I
don't think order by hashottub = 1 is going to give the result you are
looking for.
Try removing the "=1" and if you need
Yes ... and the method depends on the database you are using. What databse
are you using.
Also, this topic has been covered multiple times on this thread and the info
can be found in the searchable archive:
http://www.mail-archive.com/cf-talk@houseoffusion.com/maillist.html
Take a look
If you are using dreamweaver, it will put the fix into your code if you go
to the commands/add-remove netscape resize fix...
pretty simple and has saved my bacon on more than one occasion when
encountering the same/similar problem.
Jon
-Original Message-
From: [EMAIL PROTECTED]
cfqueryparam doesnt seem to be doing as expected:
cfquery name="contacts" datasource="Contacts"
SELECT ID, FirstName, LastName, JobTitle,BusinessPhone FROM
exoduscontacts
WHERE
LastName like '%cfqueryparam value="form.what"%' ORDER BY
LastName ASC
/cfquery
That's clearly not going
that worked.
thank you so so much for your help
bec.
-Original Message-
From: Bill Davies [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 10:10 AM
To: CF-Talk
Subject: RE: update
Becky see http://www.allaire.com/Handlers/index.cfm?ID=1463Method=Full
-Original
You can't have filters after the Order By Clause
ORDER BY cabinName AND hashottub = 1
You need to move the "AND hashottub = 1" to at the very least just before
"Order By"
That might not be your only problem or the specific cause of this error, but
it definitely will cause you an error
an access.
but bill davies was kind enough to give me this link
http://www.allaire.com/Handlers/index.cfm?ID=1463Method=Full, at which i
found an answer.
thank you,
bec. :)
-Original Message-
From: Daniel Lancelot [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 10:21 AM
To:
Hi Jason. I had read the documentation, just didn't realize that the breaks
were so intricate a part of the process.
So, to respond to Jason, as per the other responses, in CFSCRIPT, the case
statements in the SWITCH construct need breaks after each case so the program
doesn't continue to read
There was an interesting answer to this type of question in Mid-March... I
hadn't tried it myself, and would be curious if anyone else has...
CFQUERY ... cfquery parameters ...
SET NOCOUNT ON
INSERT INTO SomeTable( SomeField ) VALUES( 'SomeValue' )
SELECT nNewID = @@IDENTITY
SET NOCOUNT OFF
Do you see anything below that? I get the following when I use
cfqueryparam
| SELECT P.PID2
| FROM PAGE_LANGUAGE_XREF P
| WHERE P.PID1 = ?
|
| Query Parameter Value(s) -
| Parameter #1 = 24
and the query resolves fine.
I'm using SQL Server 7.
Thanks,
Evan
-Original Message-
Hi Christopher,
Thank you so much for spending your time to give me great help!
It worked with your suggestions after I upgraded the Coldfusion server from
4.5 to 4.5.1 (Professional version).
Thanks again and have a nice day!
Ming
- Original Message -
From: McGuckin, Chris [EMAIL
Will:
I am not sure if this could be the reason, but the ENCRYPT function requires
a string. Could the reason be that you are trying to encrypt a number? See
what the Studio help says about ENCRYPT:
=
Encrypt
Encrypts a string.
Syntax
Encrypt(string, key)
string
String to
ok.
i have a dhtml menu in my left frame set.
is there a way that i can have the sub menus overlap the main frame or right
frame?
right now in the left frame nav, if i open a few sub menus they are
partially hidden due to the next frameset.
i would like the sub menu on top of all the frames?
Insert the data then query the data immediately after the insert statement
(use a max count on it) then output the primary key number from the second
query
James
-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: 05 April 2001 15:28
To: CF-Talk
Subject: RE:
Okay - success! As several of you kindly pointed out:
You can't have filters after the Order By Clause
ORDER BY cabinName AND hashottub = 1
I did that, and then stumbled upon what I think was giving me the error
messages. This:
CFIF IsDefined("hashottub") and hashottub NEQ "0"
AND
is there anyway to output the last primary key number in a table after an
insert statement?
i need to capture that number on the same action page so i can pass it to
another table.
in other words, on my insertApp.cfm i have the query to update my apps
table.
but on this same page at the
Hi.
I was wondering if it is possible to change the shortcut for
control+shift+m. Currently, it will insert regular html comments, but I
would like it insert cfml comments. I went into the Options-Customize
menu, and looked at the keyboard shortcuts, but it doesn't look like you can
edit what
I have a situation where I need to display a price with either 2, 3 or 4
digits after the decimal place. The database is storing the information
properly, but I need to format the display to "trim" the output.
For example, I have three prices for four items:
Item 1 has a price of 45.9
Item 2
I have run into this situation in the past. I never came up with a concrete
cause but found if I limited the output formatting it worked i.e. no
tables).
I think it had to do with buffers in the browser.
Jeff
-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]]
Sent:
Patty move your ORDER BY past the CFIF and it should work.
Thank You,
Peter
Peter J. MacDonald II
Creative Computing, Inc.
100 Middle Street
Lincoln, RI 02865
Phone: 401.727.0183 x123
Fax: 401.727.4998
Portable: 401.965.3661
E-MAIL: [EMAIL PROTECTED]
Web Page: www.creatcomp.com
-Original
ORDER BY cabinName AND hashottub = 1
What SQL will do with this (theoretically) is turn this into a logical
statement
So, it would be "cabinName and HasHotTub" (logical AND) = 1
If CabinName isn't numeric, then it'll fail
It should be;
ORDER BY CabinName, HasHotTub
Philip Arnold
Director
I'm not sure what you mean by stopping the output. Do you mean that you
might start working through a query (or something) and then find that you
don't want to send the data to the user after all? If so, you could first
put all the data to download into a variable, then only do the CFCONTENT if
Again this is for SQL server. Remeber that if you want to trap the id of
the record that was inserted or updated from within a trigger (using SQL)
you can query a table called INSERTED. It will be of identical structure to
the table affected and hold all the records affeted by the SQL
Not in an Access DB
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 05 April 2001 16:01
To: CF-Talk
Subject: Re: update
I try to pass all needed info to a stored procedure and handle all database
work there ... but Becky's method appears to me as ... well
Sorry if this seems a little too late - but it has taken over an hour from
when I wrote it to when it arrived - Sent 16:12 - received 17:18!!!
-Original Message-
From: James Maltby [mailto:[EMAIL PROTECTED]]
Sent: 05 April 2001 16:12
To: CF-Talk
Subject: RE: update
Insert the data
Hi guys, hope somebody can help as this is starting to drive us insane.
We have a query that we need to extract a survey question. The survey is
given a section id, be it news, sport, etc. The survey is given a start and
finish date, no surveys within the same section can run co-currently just
CSS elements cant overlap frame borders.
-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 4:08 PM
To: CF-Talk
Subject: OT: DHTML Menu :: Spanning frameset?
ok.
i have a dhtml menu in my left frame set.
is there a way that i can have the sub
LastName like '?' ORDER BY LastName ASC
Query Parameter Value(s) -
Parameter #1 = %ch%
But it still doesnt return any results (yes, their are matching records in
the db !).
-Original Message-
From: Evan Lavidor [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 3:59 PM
To:
can't you output like this:
$#numberformat(number,mask)#
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 11:36 AM
To: CF-Talk
Subject: Numberformat question.
I have a situation where I need to display a price with either 2, 3 or 4
[prepared statements] CFQUERYPARAM allows you to build). You won't use
quotes with
Ohhh - nice of the docs to mention that... :-}
~~
Structure your ColdFusion code with Fusebox. Get the official book at
The 'coldfusion comment' selection is there it's after the listing of
assigned shortcuts. When you find it, high-light it, then click in the box
at the bottom left (next to the Apply button) and then press the key
selection you would like to use (control+shift+m) and it will populate that
Actually, there IS a setting under Customize for "ColdFusion Comments" which
would allow you to reassign the shortcut to the CFML comment. Even if there
weren't an option, it would be possible to create a snippet and assign the
shortcut to that instead.
Jason Powers
You can. And you're even looking in the right place already. If you
contintue down the list you'll see a whole bunch of commands that don't have
shortcuts. Including CFML comment. Simply reassing your desired shortcut
keys to this.
I know it works. I've done it myself.
|-Original
help -- Using ColdFusion Studio -- Chapter 6 Writing Code and
WebContent -- Using Keyboard Shortcuts
excerted
To assign a key
combination:
1. Open the Keyboard Shortcuts tab and select a command from
the list.
2.
OPTIONS: Customize: Keyboard Shortcuts
-Original Message-
From: Chris Martin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 11:27 AM
To: CF-Talk
Subject: Changing CF Studio Shortcuts
Hi.
I was wondering if it is possible to change the shortcut for
control+shift+m.
You could use a snippet shortcut. Create a snippet for the CF comment, and
then map that snippet to your key combination.
Bob
-Original Message-
From: Chris Martin [mailto:[EMAIL PROTECTED]]
Sent: April 5, 2001 11:27 AM
To: CF-Talk
Subject: Changing CF Studio Shortcuts
Hi.
I was
I don't knnow whbich DHTML menu you are using, but Hiermenus has an option
for this,
making it possible to show (sub) menu's in another frame...
richard ten Barge
1MB
At 11:08 5-4-2001 -0400, you wrote:
ok.
i have a dhtml menu in my left frame set.
is there a way that i can have the sub menus
You can create a code snippet which inserts CFML comments, and then assign
Ctrl + Shift + M to that snippet. I think Studio asks if you're sure you
want to assign that key combination to the snippet, since, as you said, it
is already assigned to HTML comments.
I've created other snippets to
I was wondering if it is possible to change the shortcut for
control+shift+m. Currently, it will insert regular html comments, but I
would like it insert cfml comments. I went into the Options-Customize
menu, and looked at the keyboard shortcuts, but it doesn't look like you
can
edit what
I've never seen this, but some thoughts I have:
1) what do the CF Server logs say?
2) how are you manipulating the record set? Are you building a
variable to store all the recordset info and associated HTML
cumulatively then outputting the value of that variable? Is there a
limit to
Hey Paul. I had some other problems as well with DHTML menus, and
unfortunately, there are no workarounds.
DHTML menus appear under IFRAMEs and SELECT boxes. Because you're loading
two different pages, there is no workaround other than creating a layer in
the other fram that you want the layer
Thanks Tony,
Are there any websites/books you could recommend I could go to for more
information on accomplishing this via an NT/IIS box?
Thanks,
Dayv
-Original Message-
From: Tony Schreiber [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 4:11 AM
To: CF-Talk
Subject: RE:
Hi,
Can cfhttp access to https site and get the files with username and pasword
provided?
if so, can anyone provide a code example!!
Thank you very much
yc
If you change the query in any way, it will rerun, so you can
do a
couple things...
One of the most interesting would be to make
1 - 100 of 191 matches
Mail list logo