INSERT INTO YourTable (
YourColumns,
...,
...
) SELECT
YourColumns,
...,
...
FROM YourTable
-- For SQL Server
SELECT @@IDENTITY YourNewID
-- Or
SELECT SCOPE_IDENTITY() YourNewID
Ade
-Original Message-
From: Saturday (Stuart Kidd)
Oh and don't forget the WHERE clause! :OD
Ade
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: 27 November 2005 18:31
To: CF-Talk
Subject: RE: SQL
INSERT INTO YourTable (
YourColumns,
...,
...
) SELECT
YourColumns
It was a long time ago but I remember someone mentioning something about
this.
I THINK the solution was to delete the default instance one and create them
as needed.
But I'd wait for someone else to confirm this just in case.
Ade
-Original Message-
From: Snake [mailto:[EMAIL PROTECTED]
and
create one that points to another instance.
If so, then that is basically what I have just said doesn't work.
Falsh remoting only works if the JrunScripts vDIR is using the default
instance. Using nay other instance doesn't work.
-Original Message-
From: Adrian Lynch [mailto:[EMAIL
Following on from that. Do a check in the custom tag to see if the query
data already exists, if it does, use it, if it doesn't, get it. Or, if
you're passing the query data into the tag then you will have done one query
anyway.
Ade
-Original Message-
From: Alan Rother [mailto:[EMAIL
I think the reason he wants to get CF to process a file with a .php
extension is that the Flash movie points to a file and he can't change the
Flash.
My advice would be to decompile the swf and change the file it's pointing to
:O)
Ade
-Original Message-
From: Russ [mailto:[EMAIL
Well if you have issues...
Please refer any IT issues to Chris Terrebonne or Tommy Nguyen.
give them a call! :OD
-Original Message-
From: Dana [mailto:[EMAIL PROTECTED]
Sent: 19 November 2005 22:19
To: CF-Talk
Subject: Re: CF-Talk: Digest every 8 hours (Out of the Office)
just
Can anyone tell me what would cause an error with this code?
cfscript
timeService = CreateObject(webservice,
http://www.nanonull.com/TimeService/TimeService.asmx?WSDL;);
cityTime = timeService.getCityTime(London);
/cfscript
cfdump var=#timeService#
cfdump var=#cityTime#
The
For the archives, the firewall was stripping headers from the SOAP request,
stopping this fixed it.
Ade
-Original Message-
From: adrian lynch [mailto:[EMAIL PROTECTED]
Sent: 16 November 2005 12:22
To: CF-Talk
Subject: Web Service Error
Can anyone tell me what would cause an error
I don't know about efficient, but try
SELECT TOP 1 eventID
That's if it's SQL Server, the over DBs will have something similar
Ade
-Original Message-
From: Russ [mailto:[EMAIL PROTECTED]
Sent: 16 November 2005 21:56
To: CF-Talk
Subject: Query Question
I have 2 tables, for the
Yup, it was something that cropped up back when CF6 came out. Putting code
from 6 to 5 highlighted this.
Ade
-Original Message-
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]
Sent: 13 November 2005 19:12
To: CF-Talk
Subject: Error found by CF45 but Not CFMX7?
Had an interesting
If The is the only word causing you problems, look for it at the beginning
of the search(it would have to be the beginning as you don't want to take it
from the middle of a string) term and remove it before it gets passed to
SQL.
Ade
-Original Message-
From: Les Mizzell [mailto:[EMAIL
I'm just looking at this myself, take a look at
INFORMATION_SCHEMA.PARAMETERS in BOL, or run it in QA.
SELECT * FROM INFORMATION_SCHEMA.PARAMETERS
I've run into a problem trying to get the datatypes of SP params
Running this...
SELECT
syscolumns.colid,
Ignore my question in that reply, but don't ignore the first bit, the IS
view might be what you need.
Ade
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: 12 November 2005 10:21
To: CF-Talk
Subject: RE: SP UDF parameter meta data
I'm just looking at this myself
Can anyone point me to a download page for SQL Server 2000 BOL. All the
pages I come across are for 2005. If anyone has a copy they can make
available, that would be grand :O)
Ade
~|
Logware (www.logware.us): a new and
Ok, I found it:
http://www.microsoft.com/downloads/details.aspx?familyid=a6f79cb1-a420-445f-
8a4b-bd77a7da194bdisplaylang=en
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: 10 November 2005 22:06
To: CF-Talk
Subject: Books Online Download
Can anyone point me
You can't do sub queries in Q of Q.
Ade
-Original Message-
From: Lee [mailto:[EMAIL PROTECTED]
Sent: 09 November 2005 22:15
To: CF-Talk
Subject: Query of Queries Subquery
I'm having trouble doing a subquery using a query of
queries. Is this even possible or am I doing something
Hartsfield
http://acoderslife.com
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 09, 2005 5:23 PM
To: CF-Talk
Subject: RE: Query of Queries Subquery
You can't do sub queries in Q of Q.
Ade
-Original Message-
From: Lee [mailto:[EMAIL PROTECTED
Run the SP in Query Analyser to see the resultsets you're getting back.
It'll be tow or three. Chances are, the third SELECT isn't being run and QA
should show this.
Does the SP return the first two resultsets?
If you leave your SP as it is you could do a check for getNavSubElements
with
I've just installed MSDE on a local dev machine, I don't have the disk with
EM and QA on and was about to hunt down some alternatives on the web. Doesn
anyone have any recommendations? Web based would be ok too.
Thanks.
Adrian
- MSDE - EM/QA Tools
If you download the eval for SQL Server 2000 from Microsoft it includes the
client tools.
-Justin
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: Saturday, October 22, 2005 7:49 PM
To: CF-Talk
Subject: OT - MSDE - EM/QA Tools
I've just
I've just installed CF7 dev on a new machine. At the bottom of the page,
beneath the debug there's a 500 Null line. The page runs as normal. I've
checked to source to see if the real error was mentioned but it's only 500
Null at the bottom of the page.
Here's a screen:
!
Adrian
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: 23 October 2005 01:25
To: CF-Talk
Subject: 500 Null at bottom of debug!
I've just installed CF7 dev on a new machine. At the bottom of the page,
beneath the debug there's a 500 Null line. The page runs as normal
The file name should be in the query returned from cfindex. It might be
fully qualified so treat it as a list and extract it.
Could be wrong though! :OI
Ade
-Original Message-
From: Lilly Spa [mailto:[EMAIL PROTECTED]
Sent: 23 October 2005 01:42
To: CF-Talk
Subject: Referencing
I had the same error on some shared hosting accounts at CrystalTech. They
fixed them almost straight away so I'd guess it's trivial matter to fix.
Not a solution I know, but at least you know others are having it and it's
fixable.
Ade
-Original Message-
From: Snake [mailto:[EMAIL
cfset CLIENT[competitionEntry url.ID] = 1
Ade
-Original Message-
From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED]
Sent: 04 October 2005 20:32
To: CF-Talk
Subject: Getting a variable
Hi guys,
I've got a simple question just can't find my answer.
I want to dynamically define a
Well how many rows do you expect back?
It has to be down to your WHERE clause. Have a look in the tables and see
whether more rows fit the criteria you're using.
Ade
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005 16:47
To: CF-Talk
Subject: Why
Are you saying that:
cfqueryparam cfsqltype=cf_sql_integer value=#Ticket_ID# /
is either passing in a blank value or the right value depending on the SQL
statement above it?
Ade
-Original Message-
From: Captain John Michael Permetheis IV [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005
. if the joins are in the query the value is empty. if i remove the
joins the value is valid.
On 10/3/05, Adrian Lynch [EMAIL PROTECTED] wrote:
Are you saying that:
cfqueryparam cfsqltype=cf_sql_integer value=#Ticket_ID# /
is either passing in a blank value or the right value depending on the SQL
Strange! Have you outputted ticket_id before and after to check it's what
you expect it to be?
Ade
-Original Message-
From: Captain John Michael Permetheis IV [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005 17:27
To: CF-Talk
Subject: Re: missing argument in a function
correct.. the
the record
that matches the URL.Client_ID...but this code should return more
than one record, right?
Rick
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: Monday, October 03, 2005 11:58 AM
To: CF-Talk
Subject: RE: Why doesn't this query return more than 1 record?
Well
I'd be suprised if it didn't throw a wobbly if you use numbers for your form
names. Best not to.
To answer the dynamic form names bit. Use array notation.
cfloop from=1 to=10 index=i
#FORM[myForm_ i]#
/cfloop
Ade
-Original Message-
From: Saturday (Stuart Kidd) [mailto:[EMAIL
and after it returns a valid value.
this is driving me nuts
On 10/3/05, Adrian Lynch [EMAIL PROTECTED] wrote:
Strange! Have you outputted ticket_id before and after to check it's what
you expect it to be?
Ade
-Original Message-
From: Captain John Michael Permetheis IV [mailto:[EMAIL
this query return more than 1 record?
Oh, I'm so mad! ;o)
I'm returning the results to the website and I've also run
the query on Navicat...
Rick
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: Monday, October 03, 2005 12:45 PM
To: CF-Talk
Subject: RE: Why
If Client_ID is your PK, and you're restricting it in the AND clause, that's
enough to limit it to one.
Ade
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005 18:44
To: CF-Talk
Subject: RE: Why doesn't this query return more than 1 record?
Ok...
Wack some #'s in there.
list=#incorrentList#
Ade
-Original Message-
From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005 22:15
To: CF-Talk
Subject: cfloop list
Hi guys,
I've appended a list and on this occasion my list outputs 1,3,5 (for
instance).
If I understand correctly, you're looking to loop over two lists at the same
time.
If the lists are productIDs and quantities then try the following:
cfloop from=1 to#ListLen(productIDs)# index=i
cfoutput
p
Product ID: #ListGetAt(productIDs, i)#br
A quick suggestion, write a test page with the minimum of code in. It'll
make it easier for you to debug and easier for us to help.
Ade
-Original Message-
From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED]
Sent: 29 September 2005 10:50
To: CF-Talk
Subject: INNER JOIN
Hi,
I've been
You can't use COUNT in the ORDER BY clause. (Please someone back me up here
else I'm off to spend some time with Book Online!).
Ade
-Original Message-
From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED]
Sent: 29 September 2005 13:20
To: CF-Talk
Subject: Now more query problems... boo
StructClear(SESSION)
Ade
-Original Message-
From: Mark Fuqua [mailto:[EMAIL PROTECTED]
Sent: 29 September 2005 13:23
To: CF-Talk
Subject: clear session variables for testing
Good Morning,
Is there an easy way to clear all session variables? It would help me test
for behaviors after
BY.
Taco Fleur - Pacific Fox
an industry leader with commercial IT experience since 1994 .
http://www.pacificfox.com - Web Design and Development
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: Thursday, 29 September 2005 10:30 PM
To: CF-Talk
Subject: RE: Now
Yup. Look at left and right outer joins.
http://www.w3schools.com/sql/sql_join.asp
What DB are you using?
Ade
-Original Message-
From: Mark Fuqua [mailto:[EMAIL PROTECTED]
Sent: 29 September 2005 13:45
To: CF-Talk
Subject: query question
Morning,
When I use joins with a select
A nice way to debug dynamically built queries is like this:
cfset qualDelPhotoList = ListQualify(delPhotoList,',,,all) /
cfoutputpre
!--- cfquery name=qdelPhoto datasource=#request.optomDS# ---
Delete from optomSitePhotos
WHERE photoLocation IN ('#qualDelPhotoList#')
!---
Try WHERE 1 = 1
Ade
-Original Message-
From: Les Mizzell [mailto:[EMAIL PROTECTED]
Sent: 29 September 2005 15:42
To: CF-Talk
Subject: Query with multiple criteria
Here's a problem that I run into a lot and have never come up with a
good answer for...
When building a search form that
Left(myTitle, 15)
Ade
-Original Message-
From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED]
Sent: 28 September 2005 13:31
To: CF-Talk
Subject: restricting cfoutput character length
Hi,
I'm trying to do something which i can imagine is very simple but
can't find the function.
INNER tbl_020articleDetails b
should be:
INNER JOIN tbl_020articleDetails b
-Original Message-
From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED]
Sent: 28 September 2005 22:30
To: CF-Talk
Subject: Re: Order by number of articles (count?)
Hi Andy,
I tried this option out but it
What goes wrong with your joined query?
Look into grouping in cfoutput for the answer to your second question.
Ade
-Original Message-
From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED]
Sent: 27 September 2005 16:02
To: CF-Talk
Subject: Queries oh queries
Hi,
I'm trying to
Yup, it came through. That email is just a reminder to trim your posts. Gets
most people the first time :O)
Ade
-Original Message-
From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED]
Sent: 27 September 2005 17:09
To: CF-Talk
Subject: Re: Queries of queries
I'm not sure if it got
Nope, try:
FORM[ceilingPaint i]
-Original Message-
From: Mark Fuqua [mailto:[EMAIL PROTECTED]
Sent: 26 September 2005 16:20
To: CF-Talk
Subject: green and seemingly brain dead, please help
Hey there,
In the body of a cfloop, this works: cfif isdefined
(form.ceilingpaint#i#). Do I
This should work:
SELECT f.FeatureName
FROM tbl_020articleFeatures f
INNER JOIN YourJoiningTable j ON ( f.FeatureID = j.FeatureID )
INNER JOIN tbl_020authorDetails a ON ( j.AuthorID = a.AuthorID )
WHERE a.AuthorID = #CLIENT.authorID#
Ade
-Original Message-
From: Saturday (Stuart Kidd)
]
Sent: 25 September 2005 16:34
To: CF-Talk
Subject: Re: Damn Queries!
Wow, yours is a lot more simple than my complicated convoluted way!
I'll definitely give your one the thumbs up!
Thanks Ade,
Saturday
On 25 Sep 2005, at 16:29, Adrian Lynch wrote:
This should work:
SELECT f.FeatureName
FROM
Yup, and I'd recommend it.
http://www.amazon.com/exec/obidos/tg/detail/-/0672325667/104-284-8175131
?v=glance
Ade
-Original Message-
From: Parker, Kevin [mailto:[EMAIL PROTECTED]
Sent: 09 September 2005 07:37
To: CF-Talk
Subject: Teach yourself
I got hold of Ben Forta's ten minute
Where are you setting request.dsn? If it's in App.cfm then make sure that
page is being called when you call the cfc.
Do you run any logic that only works as expected when a browser requests
pages? This might be hampering you attempts.
Ade
-Original Message-
From: Brandt, Chris M.
This doesn't explain the random success of the process, but could the action
attribute of the form be causing some issues?
Can we see some code?
Ade
-Original Message-
From: Caroline Wise [mailto:[EMAIL PROTECTED]
Sent: 26 August 2005 20:59
To: CF-Talk
Subject: Form Post From ASP.NET to
It's possible in SQL Server, you can create a clustered index on a view and
then non-clustered indexes(the clustered index is a must for the
non-clustered to be added). Not sure about Oracle though.
I thought it might be of some help to know it's possible on at least one DB
server.
Ade
Good question! I was just reading about it today while studying for MS's
70-229 exam, so here goes nothing...
Taking an example from the book:
CREATE VIEW MyView WITH SCHEMABINDING AS
SELECT MyColumn, MyOtherColumn
FROM dbo.MyTable
WHERE MyColumn = 'Some Value'
Some
in the
enterprise edition of SQL server?
On 8/24/05, Adrian Lynch [EMAIL PROTECTED] wrote:
Good question! I was just reading about it today while studying for MS's
70-229 exam, so here goes nothing...
Taking an example from the book:
CREATE VIEW MyView WITH SCHEMABINDING AS
SELECT
Throw a ToString() in there somewhere, see if that helps.
Ade
-Original Message-
From: DRE [mailto:[EMAIL PROTECTED]
Sent: 13 August 2005 17:28
To: CF-Talk
Subject: raw XML text of a node??
Hi, This amazes me. It seems there is no function to get the raw xml
component of a node?
See
Can we see the code you're using?
Ade
-Original Message-
From: Michel Deloux [mailto:[EMAIL PROTECTED]
Sent: 13 August 2005 16:10
To: CF-Talk
Subject: file size missing with CFFILE use
Hi all
after upload files to our server 20% that files don't have file size
properties saved to DB.
of a node??
Its not my xml. I'm parsing a feed that I dont have control over.
DRE
On 8/13/05, Ewok [EMAIL PROTECTED] wrote:
Wrap it with ![CDATA[]]
Eg.
me
what![CDATA[divphello/p/div]/what
/me
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: Saturday, August 13
Am I missing something? Is there an easier way to accomplish that?
Yes, get a pen and draw the border on your monitor :OD
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 11 August 2005 21:05
To: CF-Talk
Subject: RE: SOT: tr and style=border...
It actually
If you get anywhere with this could you post your findings to the list?
It's always good to know things like this.
Ade :O)
-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: 04 August 2005 18:51
To: CF-Talk
Subject: OT: cell phone video
anyone know how to deal with 3gp
I'm sure something else is going on in your code. Can we see it?
Ade
-Original Message-
From: Lee [mailto:[EMAIL PROTECTED]
Sent: 04 August 2005 21:53
To: CF-Talk
Subject: Number to String
This is making me crasy. I'm doing a bunch of conditional
stuff using CFSET to add multiply a
Google Smoogle, forget Google Maps, what you need is Mapscape! :OD
http://www.mapscape.net/map.cfm
Ade
-Original Message-
From: Connie DeCinko [mailto:[EMAIL PROTECTED]
Sent: 01 August 2005 23:40
To: CF-Talk
Subject: RE: Data driven local maps
Google Maps. Check out the API.
As a quick thing to check and without seeing your code, try using Chr(13)
Chr(10), or the other way around, as the delimiter.
Ade
-Original Message-
From: Ben Densmore [mailto:[EMAIL PROTECTED]
Sent: 01 August 2005 12:55
To: CF-Talk
Subject: Inserting new record into DB based on new
Anyone out there passed or is studying to pass their MCAD exams?
I'm looking to do 70-315, 70-320 and 70-229 and am looking at buying the
corresponding Exam Cram 2 books. Can anyone comment, good or bad?
http://www.amazon.com/exec/obidos/ASIN/0789728974/ref=pd_sxp_elt_l1/103-8280
718-7378259
Yup. Use this notation:
document.myform[colortype].value;
From the looks of your code, the generated HTML will look something like
this:
select
optionasas/option
input type=hidden ... /
optionasasa/option
input type=hidden ... /
optionasasas/option
But posting a message and then being told you can't post via email is
annoying don't you think?
Ade
-Original Message-
From: Aminova, Elena [mailto:[EMAIL PROTECTED]
Sent: 09 June 2005 16:25
To: CF-Talk
Subject: RE: how to post
There is an indication, they send an email out to you, if
Try:
FORM[selectrestrictionsite1_#primernum#]
or:
FORM[selectrestrictionsite1_ primernum]
Ade
-Original Message-
From: Richard Colman [mailto:[EMAIL PROTECTED]
Sent: 08 June 2005 22:46
To: CF-Talk
Subject: Naming variables within a loop
I am having trouble with this sort of thing:
Holy crap!
I suppose it could have been worse, it could have all been on one line! :Oo
Ade
-Original Message-
From: Micha Schopman [mailto:[EMAIL PROTECTED]
Sent: 02 June 2005 12:36
To: CF-Talk
Subject: RE: CF vs LAMP
This is true code running in production I had to review once
24 times at the greatest depth!! :Oo
-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: 02 June 2005 16:26
To: CF-Talk
Subject: Re: CF vs LAMP
.and it was impeccably indented :)
On 6/2/05, Ian Skinner [EMAIL PROTECTED] wrote:
Well, it had comments! ;-)
Not as such. But you can create a second App.cfm in a sub directory and it
will use that one instead.
Ade
-Original Message-
From: Christian Watt [mailto:[EMAIL PROTECTED]
Sent: 01 June 2005 18:12
To: CF-Talk
Subject: Application.cfm
Is there any way to tell a page in a directory or
Not on 6.1 or 7 is doesn't.
Ade
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 01, 2005 1:15 PM
To: CF-Talk
Subject: Re: Application.cfm
e, doesnt an EMPTY application.cfm file barf?
tony
--
No virus found in this outgoing message.
Checked by
A couple of things I'd change. You have 20 references to the same form and
your formatting isn't the best.
1. Make a shortened reference to the form, f. This will reduce the amount of
text/typing and a form name change can be done in one place.
2. Don't indent the large block beneath the one
You could use Chr(65) though to Chr(90), this will give you A through to Z.
Chr() and Asc() together might give you something better.
Ade
-Original Message-
From: SStewart [mailto:[EMAIL PROTECTED]
Sent: 18 May 2005 19:34
To: CF-Talk
Subject: Anyone know of a more elegant way to do
What the heck does your email client/server do to hyperlinks!?! :Oo
-Original Message-
From: Ewok [mailto:[EMAIL PROTECTED]
Sent: 18 May 2005 22:59
To: CF-Talk
Subject: WOT: but funny just the same.
Im not trying to start a discussion on this. I just thought you guys might
get a kick
Try String instead of string...
Ade
-Original Message-
From: dave [mailto:[EMAIL PROTECTED]
Sent: 17 May 2005 09:23
To: CF-Talk
Subject: RE: Crystaltech session invalid error
hum, I just ran a jsp page on mine and it wont run
http://www.jamwerx.com/1.jsp.
If you really think you are
Your code is doing this:
cfset newtext = replace(origtext, quot;, acute;, ALL)
so it looks for the string quot;. Not as you seem to want, the double
quote.
Try:
cfset newtext = replace(origtext, '', quot;, ALL)
Ade
-Original Message-
From: jgeorges [mailto:[EMAIL PROTECTED]
Sent: 12
I wouldn't, it just confuses what should be a simple action. Of course if
the customer wants it that way then change it :O)
Ade
-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: 12 May 2005 17:36
To: CF-Talk
Subject: usability question involving a sort.
I have data
Is there?
If you have for example:
input name=name_1 type=text /
input name=name_2 type=text /
input name=name_3 type=text /
Then on the action page:
cfloop from=1 to=3 index=i
query
INSERT
#FORM[name_ i]#
/query
cfloop
Is that what you
Also, target=_blank won't validate as strict.
Ade
-Original Message-
From: dave [mailto:[EMAIL PROTECTED]
Sent: 11 May 2005 08:51
To: CF-Talk
Subject: link validation ?
how can I make a link like this validate xhtml?
a
Whatever variable you're passing to SUBSTRING() is probably empty.
Ade
-Original Message-
From: Protoculture [mailto:[EMAIL PROTECTED]
Sent: 11 May 2005 12:16
To: CF-Talk
Subject: calling stored procedure error..
I dont understand this error...
Macromedia][SQLServer JDBC
Wrap #content# in cfoutputs. What happens?
Ade
-Original Message-
From: Peter Shaw [mailto:[EMAIL PROTECTED]
Sent: 11 May 2005 12:19
To: CF-Talk
Subject: Writing Binary Images to Screen
Hi,
I have a COM object that returns a binary image file. How can I write this
to the screen?
My
Take a look at SUBSTRING.
Ade
-Original Message-
From: Protoculture [mailto:[EMAIL PROTECTED]
Sent: 10 May 2005 15:32
To: CF-Talk
Subject: MSSQL Function
I have a variable like this.. ',6,6,8,2,10,11,'
what mssql function(s) can I use to remove the commas before the first 6 and
after
but apparently it doesnt like the js that cfm makes either
Who does?!
-Original Message-
From: dave [mailto:[EMAIL PROTECTED]
Sent: 28 April 2005 23:24
To: CF-Talk
Subject: RE: AV on CF servers
I see problems all the time with users not seeing pages correctly and in
every case its
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/functi20.htm#wp346877
0
and the XML and XSLT in ColdFusion MX PDF here
http://www.macromedia.com/devnet/mx/coldfusion/xml_xslt.html
should tell you all you need.
Ade
-Original Message-
From: Matt Robertson [mailto:[EMAIL
I didn't quite understand your email, but there is an attribute
null=yes|no for cfqueryparam. Is that of any use to you?
Ade
-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]
Sent: 26 April 2005 22:02
To: CF-Talk
Subject: cfqueryparam and null values
Are there any
You don't have to, it's available as queryname.CurrentRow.
Ade
-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: 26 April 2005 23:11
To: CF-Talk
Subject: RE: Finding page in a query.
quote
In that case, do you really want to move the user to a page out of sequence?
Hello all, I'm self employeed in the UK. Like most people here, a trip to
America is always on my mind.
What do you think the prospects would be for someone coming over to the US
to work as a CFer on a contract basis? I'm by no means under worked at the
moment, but I like the idea of combining a
I'm sure others will chime in with some answers and I'm sure there are a
bunch of solutions for you to choose from but...
if you don't mind the delay, what about a confirmation email? Are
scripts that automat sign-ups wise to these?
Ade
-Original Message-
From: Josen Ruiseco
All of the above(below) plus IP maybe?
Ade
-Original Message-
From: Connie DeCinko [mailto:[EMAIL PROTECTED]
Sent: 25 April 2005 21:27
To: CF-Talk
Subject: Auto-login for trusted users
I've got the opposite issue... How can I provide an automatic login for
trusted users? I know of
cfset myArrayOfStructs = ArrayNew(1)
cfset myArrayOfStructs[1] = StructNew()
cfset myArrayOfStructs[1].FName = Adrian
cfset myArrayOfStructs[1].LName = Lynch
cfset myArrayOfStructs[1].EMail = [EMAIL PROTECTED]
cfset myArrayOfStructs[2] = StructNew()
cfset myArrayOfStructs[2].FName = Thane
cfset
How about logging the user out before they login?
It won't stop them sharing and using the system at different times, but if
one is logged in and then suddenly gets logged out they make think twice
about letting this other user use their login details.
Ade
-Original Message-
From:
Hi Alex, I trying it on a CF7 shared hosting account I have at CrystalTech
and it worked. A sandbox issue perhaps?
Ade
-Original Message-
From: Alex Sherwood [mailto:[EMAIL PROTECTED]
Sent: 21 April 2005 17:47
To: CF-Talk
Subject: Help: GetPageContext().Forward() error!
Help.
When I
If your form fields are named answer1, answer2, etc. then reference them
like this in the query:
#FORM[answer i]#
Ade
-Original Message-
From: Stuart Kidd [mailto:[EMAIL PROTECTED]
Sent: 21 April 2005 20:45
To: CF-Talk
Subject: More hash on the mailing list
Hi guys,
I've got a
You don't use that for anything other than debugging do you? You'll get all
form fields which you might not want. If it is for debugging what's wrong
with cfdump var=#FORM#?
Ade
P.S. anyone know what's up with all those funny advertising links appearing
in the archives at HoF? :OD
-Original
loop list=col_1 index=i
loop list=col_2 index=j
compare i to j here
/loop
/loop
Or check cflib.org for one.
Ade
-Original Message-
From: Chris McCarthy [mailto:[EMAIL PROTECTED]
Sent: 19 April 2005 19:33
To: CF-Talk
Subject: How to create query results
You enjoy using it?! Hmmm, just thinking if there's ever been a bit of
code I've enjoyed using...
cfpop, no...
alert(), no...
cfchart, hell no...
o, a couple weeks back I had some fun with cfmail! :OD
Sorry :OP
-Original Message-
From: Kazmierczak, Kevin
Have you looked at the docs for DatePart() in Access? What does it say about
the arguments required?
Ade
-Original Message-
From: CFDEV [mailto:[EMAIL PROTECTED]
Sent: 03 April 2005 03:49
To: CF-Talk
Subject: RE: Access query problem in CF
Thanks but it still says too few parameters :(
Got any code to show?
-Original Message-
From: John Beynon [mailto:[EMAIL PROTECTED]
Sent: 01 April 2005 11:50
To: CF-Talk
Subject: maths in flash form?
I've been kicking myself for a while on this one, I've got two input
fields on a form and want the values added together and displayed
801 - 900 of 1493 matches
Mail list logo
