Hi Leigh,
Good points you make here. Not sure why cfinsert|update don't accept a result
attribute and return a result struct. I'll probably have to re-file, since I
don't see ER #71025 (filed in 2007) in the tracker anymore.
Thanks,
-Aaron Neff
1) Retrieve an identity/autoincrement value
On Thu, Sep 23, 2010 at 12:10 PM, Jacob Munson yacoub...@gmail.com wrote:
While I won't tell ORM fans that they shouldn't use ORM, I have done my fair
share of railing against ORM.
As you have against OO and various other modern ways of thinking
about software - and as Rick points out you are
I have a cfform inside an Ajax window and I am trying get the cursor to appear
in the first input field when the window opens. I've tried the usual javascript
solution but nothing seems to work for me. Any ideas?
Extracted code from the module follows:
div id=LoginDiv
cfif LoginMsg
Yes, when you want to reference something like
document.LoginForm.AccessID.focus() you need to make sure that the ID of
that element is set to AccessID, you have name set but not ID.
Regards,
Andrew Scott
http://www.andyscott.id.au/
That's not true.
The way he's referencing it is by the element name, not id. Otherwise it
would be document.getElementById('AccessID').focus();
On Fri, Sep 24, 2010 at 8:54 AM, Andrew Scott andr...@andyscott.id.auwrote:
Yes, when you want to reference something like
Two things. First the way you are referencing your form is by name, not ID.
So you need to add this: name=LoginForm to your cfform tag.\
Also, i don't think that form has an onload function. Just put this at the
bottom of your code:
script
document.LoginForm.AccessID.focus();
/script
On
Not to be pain on this, but this is something I would like to accomplish
today before I leave (last day of contract)...anyone know why the
404_handler.cfm that is specified as the 404 handler in IIS is not executing
in IIS7 like it did in IIS6? Is there something ese that needs to be done
in 7
... Or add on document onload or document ready function.
:)
On Fri, Sep 24, 2010 at 9:06 AM, Michael Grant mgr...@modus.bz wrote:
Two things. First the way you are referencing your form is by name, not ID.
So you need to add this: name=LoginForm to your cfform tag.\
Also, i don't think
CFForm does have an onLoad attribute.
Regards,
Andrew Scott
http://www.andyscott.id.au/
-Original Message-
From: Michael Grant [mailto:mgr...@modus.bz]
Sent: Friday, 24 September 2010 11:06 PM
To: cf-talk
Subject: Re: Trying to set cfform focus in an Ajax window
Two things.
I said form, not cfform. Cf adds onload to the compiled form tag, which
then proceeds to not work since form doesn't have an onload method.
But don't take my word for it, try it yourself:
cfform name=myForm onload=alert('my onload worked');
cfinput type=text name=myText
/cfform
On Fri, Sep
Well then yes you did, but I have to ask why you said form, when he is using
cfform?
Regards,
Andrew Scott
http://www.andyscott.id.au/
-Original Message-
From: Michael Grant [mailto:mgr...@modus.bz]
Sent: Friday, 24 September 2010 11:34 PM
To: cf-talk
Subject: Re: Trying to set
Because that's what cfform is.
You don't actually think there's such a thing as a CFForm outside of CF do
you? Or any CF tag for that matter? CF tags are compiled into HTML tags and
sent to the browser.
On Fri, Sep 24, 2010 at 9:31 AM, Andrew Scott andr...@andyscott.id.auwrote:
Well then
Michael, if you think that someone who has been developing CF for 15 years
thinks that way then go preach to someone else.
Regards,
Andrew Scott
http://www.andyscott.id.au/
-Original Message-
From: Michael Grant [mailto:mgr...@modus.bz]
Sent: Friday, 24 September 2010 11:40 PM
To:
Is it possible to package an image with a link and request it from a
non-coldfusion website? I know that I can use cfcontent to stream a jpg file
using a img src request, but can I use cfcontent and pull the html a href
and img src to show the image with its associated link? Thanks in advance.
Andrew. I'm not preaching. You said something incorrect about how to target
a form field. Then you made a comment about a method of the form tag that
doesn't exist. Then you asked a question which gave the impression that you
didn't realize that cfform actually creates a form tag. I don't think
Is it possible to package an image with a link and request it from a
non-coldfusion website?
I know that I can use cfcontent to stream a jpg file using a img src
request, but can I use
cfcontent and pull the html a href and img src to show the image with its
associated
link? Thanks in
Sorry, I'm missing this in the Harlan code. I see where it's designed for
coding ads for a Coldfusion site, but I don't see the code example for
embedding code (javascript that calls a cfm file) into a non-Coldfusion site.
I'd appreciate it if you could point me to that code. Many thanks!
On Fri, Sep 24, 2010 at 9:43 AM, Richard Steele r...@photoeye.com wrote:
Is it possible to package an image with a link and request it from a
non-coldfusion website? I know that I can use cfcontent to stream a jpg file
using a img src request, but can I use cfcontent and pull the html a
The JS is output in the admin. Ie, when you run the ad manager it
gives you the JS to embed.
In horrible Flash Forms.
I apologize. ;)
On Fri, Sep 24, 2010 at 8:49 AM, Richard Steele r...@photoeye.com wrote:
Sorry, I'm missing this in the Harlan code. I see where it's designed for
coding
I don't know the deep technical details, but I do know that many people
argue that using query params actually gives you a performance benefit over
plain SQL (although a lot of people disagree).
This isn't really a matter for debate. In some cases, parameterized
SQL is faster. In other cases,
It is a complex topic for many, and Dave is of course correct as usual.
It would be wise to a bit of research on the topic before giving out
incorrect advise and also for yourself to make sure you understand the
process correctly to aid in your own query design.
There is a lot of info regarding
I am trying to use this WSDL/web service: (the following has been edited for
security) ;-)
cfinvoke webservice=myURL/my_api.cfc?wsdl method=GetUserProfile
returnvariable=temp1
cfinvokeargument name=wsID value=1
cfinvokeargument name=customerid value=1
cfinvokeargument
Just for fun, here's some examples of what SQL Server receives from
coldfusion when you run a pretty simple query using cfqueryparam:
declare @p1 int
set @p1=748592
exec sp_prepexec @p1 output,N'@P1 int,@P2 bit',N'select
gallery_link_id, gallery_link_name
from gallery_links
where
We're trying with CF9 on Windows Server 2008 to generate RTF files with font
information.
So far, the approaches we've seen depend on going through a browser to a
user's desktop.
What we need it to do is be able to generate the RTF file via a scheduled
task that will be
run every 5
Problem solved...or to be more accurate, it was never a problem. Apparently
one of the new features in IIS7 is when you access a page locally, you get
detailed error pages, but when you access them remotely, you gey whatever
your custom pages are :-D Problem solved...life is good :-D
Eric
There are a lot of ways to do it. It all depends on the server side
technology they are using, if any. I would assume PHP. With that said, it
depends on how PHP is configured. If you can use fopen() to retrieve a url
that is the easiest way.
$doc = fopen($url);
Or you can use DOMDocument and
You shouldn't have to manipulate the SOAP XML response
directly.
Hmm.. you are right. I had cfhttp on the brain yesterday and skidded right past
the fact they are using cfinvoke.
-Leigh
~|
Order the Adobe
Hi Aaron,
Sounds good. It would certainly come in handy. Especially the ability to
retrieve identity/autoincrement values.
-Leigh
~|
Order the Adobe Coldfusion Anthology now!
On Fri, Sep 24, 2010 at 10:55 AM, Leigh cfsearch...@yahoo.com wrote:
Sounds good. It would certainly come in handy. Especially the ability to
retrieve identity/autoincrement values.
Can you do that by running it inside cftransaction?
cftransaction
cfinsert
cfqueryselect @@identity ...
Thanks Rick, script type=text/javascript
src=http://domain/foo.cfm;/script seems to be the solution. However. all
I'm getting is a blank page. The page source shows just a link to foo.cfm. When
I click the link, I get the proper image src with its link.
How do I code the foo.cfm so that the
Hi Dave -
I haven't put it into any CFC code yet. I usually work in a simple file to
test the results, and make sure things work before adding additional overhead.
The only code on the page is this (and then attempts to print out the results):
cfinvoke webservice=myURL/my_api.cfc?wsdl
It's a Google Blogger page, so I don't think there's access to PHP.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
does your foo.cfm output javascript that includes
document.writeln('aimg/a');
Or does it just output aimg/a?
It needs to do the javascript and probably also needs cfcontent
type=application/javascript reset=yes at the top.
Rick
Dave means the cfc at myURL/my_api.cfc
There must be some code there, right?
--
WSS4CF - WS-Security framework for CF
http://wss4cf.riaforge.org/
On 24 September 2010 22:54, Doug Ford doug.e.f...@gmail.com wrote:
Hi Dave -
I haven't put it into any CFC code yet. I usually work in a
Never mind then. ;)
Rick is spot on then. Call a js file and use document.write to output the
html.
The only thing I would add is to use cfcontent to set the mime type to
text/javascript or what ever the correct mime type is
G!
On Fri, Sep 24, 2010 at 10:55 AM, Richard Steele
Any database transaction can go inside a transaction block. The purpose of
this is to basically treat everything inside as a single transaction so that
you can do a ROLLback if there is any error.
This is covered in the CF docs actually, so if your not sure you can RTFM.
Russ
-Original
Stored procs is not always the best solution either. There is plenty of good
reason to keep your queries inside your CFML templates.
If you have the luxury of a DBA then he will probably be doing everything
for you in stored procs, or if you are a lone developer then you can make
the choice.
html page:
Shoot Still a blank screen with just the link as can be seen in the source
code. What am I missing here?
htmlheader
/headerbody
script type=text/javascript
src=http://www.photoeye.com/advertising/pull_ad.cfm;/script
/body/html
pull_add.cfm:
cfcontent
html page:
Shoot Still a blank screen with just the link as can be seen in the
source code. What am I missing here?
htmlheader
/headerbody
script type=text/javascript
src=http://www.photoeye.com/advertising/pull_ad.cfm;/script
/body/html
pull_add.cfm:
cfcontent
There is an error on this page:
http://www.photoeye.com/advertising/pull_ad.cfm
On Fri, Sep 24, 2010 at 11:17 AM, Richard Steele r...@photoeye.com wrote:
html page:
Shoot Still a blank screen with just the link as can be seen in the
source code. What am I missing here?
htmlheader
On Fri, Sep 24, 2010 at 11:13 AM, Russ Michaels r...@michaels.me.uk wrote:
This is covered in the CF docs actually, so if your not sure you can RTFM.
We're having a discussion on the possibilities. Someone else can RTFM
if they're interested in actually trying what I'm suggesting. =)
OK, but Given the amount incorrect assumptions made so far it would seem
like a fair suggestion to make.
After all, you can only really discuss the possibilities if you actually
know what is and is not possible, otherwise it's the blind leading the blind
isn't it ?
Russ Michaels
Hi folks -
It looks like Leigh might be the winner in this contest...
When I did this:
cfset resultXML = xmlParse(trim(temp1))
I was able to do this:
cfdump var=#resultXML#
And actually see some XML code.
Thank you all for trying to help.
Dave as for the CFC of the SOAP service, I don't
Russ Michaels r...@michaels.me.uk wrote:
snip
It is also easier from a self containment and portability point of view to
keep SQL within the application. Stored Procs written for MSSQL clearly wont
run on MySQL.
I hear this sometime and wonder how many times you have to port something
All,
I have a website that has to use NTLM authentication. A little Info
first: IIS7, Windows 2008 Server, CF Version: 8,0,1,198765, Non-standard
port: 81. URL looks like http://admin.mywebsite.com:81/index.cfm No
issues at all accessing the CFAdmin. I have set the /CFIDE/scripts and
CFTREE and any other tags that use Javascript, flash etc all need to load
files form the CFIDE. If you have disabled anonymous access then they wont
be able to load the files.
You should only lock down the ADMINISTRATOR, not the CFIDE
Russ
-Original Message-
From: DURETTE, STEVEN J
In Flash Paper, which supported making PPTs into Flash movies, there was
some sort of exposed API to manipulate the presentation. It's been a long,
long time since I used it but I would guess that CFPRESENTATION has
something similar.
On Thu, Sep 23, 2010 at 11:44 PM, John Eubanks
I have /CFIDE/Scripts and /CFIDE/classes changed to Anonymous and that
cleared up the errors fiddler reported for them, but I still get the
error notification and the calls to
/webs/coldfusion/applets/CFTreeApplet.class and
/webs/coldfusion/applets/CFTreeApplet/class.class don't make any sense.
I have /CFIDE/Scripts and /CFIDE/classes changed to Anonymous and that
cleared up the errors fiddler reported for them, but I still get the
error notification and the calls to
/webs/coldfusion/applets/CFTreeApplet.class and
/webs/coldfusion/applets/CFTreeApplet/class.class don't make any
Anyone know how to get timeline information from a cfpresentation? I need to
be able to get where a user stopped at if he/she
logs out of the application or if the session ends so they don't have to
start the entire presentation over if or when they log back in.
Any assistance would be
Do you mean I have to turn on both NTLM and Anonymous for these items?
For testing purposes I've also granted EVERYONE read/execute to all of
these folders.
I set All of CFIDE to anony and locked down Administrator and adminapi.
Still no love. :(
-Original Message-
From: Dave Watts
Do you mean I have to turn on both NTLM and Anonymous for these items?
Yes. If the user is accessing other parts of the site with NTLM,
they'll automatically send their NTLM credentials for all requests.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/
Can you do that by running it inside cftransaction?
I remember seeing something similar in old threads about retrieving an
Autonumber value for an Access database. I have not really thought it through,
but I suppose in theory it might work. Though it does seem like stretching the
intent of
I had this same problem in my shared hosting. The Sysadmin didnt
really understand the coldfusion set up that well, and wouldnt allow
sites access to the CFIDE folder (actually a mapping on this server).
So i copied the relevant parts of the CFIDE folder into the web site
just under the root.
There is a built in method of getting that last records primarykey for most
databases, but not for MSACCESS.
You need to get the MAX() number to do that, and u should do it in a locked
transaction block so that you don't get the ID of another record that has
been added since.
Or, get the max()
Thanks Dave! That seems to have done it.
-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com]
Sent: Friday, September 24, 2010 12:38 PM
To: cf-talk
Subject: Re: IIS 7 401.2 Error for cftree (long post with error info)
Do you mean I have to turn on both NTLM and Anonymous
Getting back to the OP. I can totally see the how using cfinsert and
cfupdate are attractive options for RAD
I use Steve Bryant's DataMgr quite a bit during development and prototyping.
http://datamgr.riaforge.org/
I actually use a service layer but the end result is that I can use one line
of
There is a built in method of getting that last records
primarykey for most
databases, but not for MSACCESS.
I cannot speak for its reliability, but I believe MS Access does have
@@identity. However as shown in one of the previous posts, retrieving the value
is a bit more convoluted than in
Sorry about that. Thanks guys for bearing with me on this one.
Doesn't the cfcontent have to output the variable?
cfoutput
CFSET X=document.writeln('a href=#qGetCurrentAdLink.link_url#img
src=http://www.photoeye.com/magazine/ads/#qGetAd.image_filename#;/a');
cfset x = jsStringFormat(x)
Sorry about that. Thanks guys for bearing with me on this one.
Doesn't the cfcontent have to output the variable?
cfoutput
CFSET X=document.writeln('a href=#qGetCurrentAdLink.link_url#img
src=http://www.photoeye.com/magazine/ads/#qGetAd.image_filename#;/a');
cfset x = jsStringFormat(x)
On Fri, Sep 24, 2010 at 11:51 AM, Russ Michaels r...@michaels.me.uk wrote:
After all, you can only really discuss the possibilities if you actually
know what is and is not possible, otherwise it's the blind leading the blind
isn't it ?
/usefulConversation
I think you are referring to SCOPE_IDENTITY()
http://msdn.microsoft.com/en-us/library/ks9f57t0%28VS.71%29.aspx
However I seem to recall it did not work last time I tried it, but that was
ages ago. I think it requires latest version of access and jet drivers.
Regards
--
Russ Michaels
No, whaty ou want is something like this
cfcontent type=application/javascript reset=yes
cfset output = 'a href=#qGetCurrentAdLink.link_url#img
src=http://www.photoeye.com/magazine/ads/#qGetAd.image_filename#;/a'
cfoutputdocument.writeln('#jsStringFormat(output)#');/cfoutput
No, whaty ou want is something like this
cfcontent type=application/javascript reset=yes
cfset output = 'a href=#qGetCurrentAdLink.link_url#img
src=http://www.photoeye.com/magazine/ads/#qGetAd.image_filename#;/a'
cfoutputdocument.writeln('#jsStringFormat(output)#');/cfoutput
Except that
Hi Dave,
Still showing a blank when pulling the image.
http://www.photoeye.com/advertising/test_ad.cfm
View source and it shows the following:
htmlheader
/headerbody
script type=text/javascript
src=http://www.photoeye.com/advertising/pull_ad.cfm;/script
/body/html
The src appears as a
Ok, here's what I have for pull_ad.cfm
cfset output = 'a href=#qGetCurrentAdLink.link_url#img
src=http://www.photoeye.com/magazine/ads/#qGetAd.image_filename#;/a'
cfcontent type=application/javascript reset=yes
;cfoutputdocument.writeln('#jsStringFormat(output)#');/cfoutput
Still no luck
Still no luck, now I have \ in the generated output below this is still not
written to the caller browser.
;document.writeln('a
href=\http://www.santafeworkshops.com/index.php?source=PEad=mag\;img
src=\http://www.photoeye.com/magazine/ads/2009_05_workshops.jpg\;/a');
pull_ad.cfm:
cfcontent
Bueller? Bueller?
I have everything set up in the administrator, but nothing ever comes through.
When looking at the socket-gateway.log I spy the following:
error attempting to listen on socket: java.net.socketException: socket closed
I find this odd because when I review the ports in
Hi Folks -
Here's the situation:
I use a cfinvoke to call a SOAP web service, and it's stored in a variable.
I do the following to store the results into a variable:
cfset resultXML = xmlParse(trim(temp1))
When I cfdump it, it gives me a nice structure diagram - cfdump
var=#resultXML#
But I
Wow, calm down there partner! I clearly stated in my post that I could be
wrong about this, and I invited people to correct me if I am wrong.
As far as Dave is of course correct as usual. Dave has been known to be
wrong before. Feel free to dismantle your Dave Watts shrine. ;)
I KNOW for a
Same post, different title.
Up until recently I hit this webservice with a simple CFHTTP and the
webservice would return XML.
For some reason now when I hit it with CFHTTP I get a Connection Failure
message in the file content.
So i thought I'd switch to use CFINVOKE instead.
However I don't
wow, toys back in the pram dude. Don't take things so personally, you just
got corrected is all. :-)
On Fri, Sep 24, 2010 at 8:06 PM, Jacob Munson yacoub...@gmail.com wrote:
Wow, calm down there partner! I clearly stated in my post that I could be
wrong about this, and I invited people to
I have a database with presidents, governors, etc. and need to be able to
pull out information such as:
Get the number of all female governors over the years and spit out something
on the order of:
1789 : 0
1790 : 0
.
2005 : 10
.
2010 : 6
The database has dateStarted, dateEnded
Are you able to craft a query that will return the results you need
without ColdFusion having to do any extra parsing of it? That is the
first thing I would try. In your brief example it seems like that
would be solved using a GROUP BY statement in the query.
-Mike Chabot
On Fri, Sep 24, 2010
I use URL Rewriting on IIS7 but not with a 404 handler. It seems to me
that if you are rewriting in the webserver layer, why would you
rewrite to an invalid path? I just specify a regex for the rewrite
that says take everything of the form /foo/bar/monkey and rewrite it
to
in your query only select only female governess
then use the cfoutput group attribute to group by year, this will then only
output records for the same year.
you need to next 2 cfoutput.
cfoutput query=myquery
cfoutput group=year
your output here
/cfoutput
/cfoutput
On Sat, Sep
you are going to need to create a regular expression that dynamically
generates the url's you need based on the oriignal url. If there is not
enough data in the original url to do this and you have to use the database
then your going to be out of luck I think.
Your only other options would be to
Meh. I'm keeping my Dave Watts shrine right where it is. He's a smart guy
that seems to have an answer to everything.
(Well except my question about cfinvoke and webservices.)
/me walks away grumbling.
On Fri, Sep 24, 2010 at 3:06 PM, Jacob Munson yacoub...@gmail.com wrote:
Wow, calm down
And plenty or sarcastic ones at that :-)
It's because Dave doesn't actually do any work, he clearly spends all day on
discussion lists LOL
On Sat, Sep 25, 2010 at 12:52 AM, Michael Grant mgr...@modus.bz wrote:
Meh. I'm keeping my Dave Watts shrine right where it is. He's a smart guy
that
On Fri, Sep 24, 2010 at 1:44 PM, Dave Watts dwa...@figleaf.com wrote:
Except that you should put the CFSET before the CFCONTENT. That's why
you use the RESET attribute in the first place - to get rid of any
whitespace that's been cached in the buffer.
More important for XML documents of
It really would pay to work out why the webservice you are calling is
broken. That way you'd be able to avoid all the problems working out
how to address the SOAP response.
--
WSS4CF - WS-Security framework for CF
http://wss4cf.riaforge.org/
On 25 September 2010 02:13, Doug Ford
This isn't really correct. The query isn't compiled in any case.
Ok, so I found out I WAS correct. Either that or yet another article I
found on prepared statements is wrong. Here's a quote from the article:
The PreparedStatement object contains not just an SQL statement, but an SQL
Thanks Mike,
I'm not a SQL expert but I don't see how. I can do something with particular
fields such as the year the person was elected (governorDateStart) or when
the person left office governorDateEnd
SELECT
governorParty,
COUNT(governorState),
On Fri, Sep 24, 2010 at 3:52 PM, Richard Steele r...@photoeye.com wrote:
http://www.photoeye.com/advertising/test_ad.cfm
When I go to this page, I see the script src is:
http://www.photoeye.com/advertising/pull_ad.cfm
Which generates a 404 error.
Rick
So I'm guessing a lot of your application relies on the XML, which
makes using the objects returned from the invoke not an appealing
option?
There must be some way at getting at the XML, but I don't know how.
Maybe a tool like this: http://www.soapui.org would help troubleshoot?
Not sure why a
85 matches
Mail list logo
