Re: Percentages & Form Variables
oops, typo in the round() function... it should be: #round( (correctanswers/ttlquestions)*100 ) [i had a comma in there which should not be there...] On 04/03/2011 12:11 , Azadi Saryev wrote: > Something like this: > > a) at the top of your action page add: > > > > b) in the table showing answers in your action page add correctanswers = correctanswers+1> to all your blocks like so: > > > > > ...[your current code as is here]... > > > c) at the bottom of your action page show the score: > Your Score: #round( (correctanswers/ttlquestions)*100, > )#% > > Azadi > > On 04/03/2011 11:48 , John Eubanks wrote: >> Anyone know how to calculate a percentage from form variables. I >> have a simple quiz (five questions) with multiple choice answers. I >> have the correct answers set using cfset on the processing page. >> However, I need to run a percentage so the display shows something >> like: Score: 80%. >> >> ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342743 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Percentages & Form Variables
Something like this: a) at the top of your action page add: b) in the table showing answers in your action page add to all your blocks like so: ...[your current code as is here]... c) at the bottom of your action page show the score: Your Score: #round( (correctanswers/ttlquestions)*100, )#% Azadi On 04/03/2011 11:48 , John Eubanks wrote: > Anyone know how to calculate a percentage from form variables. I have a > simple quiz (five questions) with multiple choice answers. I have the > correct answers set using cfset on the processing page. However, I need to > run a percentage so the display shows something like: Score: 80%. > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342742 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Percentages & Form Variables
Anyone know how to calculate a percentage from form variables. I have a simple quiz (five questions) with multiple choice answers. I have the correct answers set using cfset on the processing page. However, I need to run a percentage so the display shows something like: Score: 80%. Here is the form page: 1. Spiders have pairs of legs. A) 3 B) 4 C) 8 D) None of the above 2. All venomous species of snakes are deadly? A) True B) False 3. Florida is populated by how many species of deadly venomous scorpions? A) 4 B) 1 C) 0, Florida has no deadly venoumous scorpions known at this time. D) 2 4. This is MOST important when determining proper anti-venom? A) Snake Type (Identification) B) Length of Snake C) Color of Snake D) Location of Snake 5. Florida is home to 40,000 species of spiders? A) True B) False Here is the action page: 1. Spiders have #Form.Q1# pairs of legs. 2. All venomous species of snakes are deadly? #Form.Q2# 3. Florida is populated by how many species of deadly venomous scorpions? #Form.Q3# 4. This is MOST important when determining proper anti-venom? #Form.Q4# 5. Florida is home to 40,000 species of spiders? #Form.Q5# Any help would be very much appreciated. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342741 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: I'm confused/stumped - cant figure this out
Personally, I would be passing the value of the type not the value. Let the server then decide what the cost is, if you start passing currency around like this, then you are opening up to a security issue. So you could have a radio button for the user to select, which then has the values of your types. When submitted the type is checked and done a lookup or whatever you need to do, to then grab the value and do what you need to do from there. Regards, Andrew Scott http://www.andyscott.id.au/ > -Original Message- > From: Brian Cain [mailto:bcc9...@gmail.com] > Sent: Friday, 4 March 2011 1:36 AM > To: cf-talk > Subject: Re: I'm confused/stumped - cant figure this out > > > Why are you using hidden text fields at all? You can put the amount in the > options value attribute. > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342740 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SSL Connection to Postgresql
> > Thank you for the direction! My only question with this is that the > host box is creating this keystore, so how will it be moved to the > remote client > > box? > > The server and client will have separate keystores. You simply need > to > use keytool to import the server's certificates into the client's > keystore. In this case, the client is your CF server. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > http://training.figleaf.com/ > > Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on > GSA Schedule, and provides the highest caliber vendor-authorized > instruction at our training centers, online, or onsite Very much appreciated! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342739 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Online Test
Given that you plan to build several, it would be easiest to make one generic codebase that can query the Database for all questions belonging to a certain test. Then your one codebase can server as all "tests" =] On Thu, Mar 3, 2011 at 2:00 PM, Jacob wrote: > > I would think the DB approach would be easier to maintain and scalable... > > -Original Message- > From: John Eubanks [mailto:jae...@hotmail.com] > Sent: Thursday, March 03, 2011 12:51 PM > To: cf-talk > Subject: Online Test > > > I am building an online test (actually, several of them) and need some > help. > Would it be easier to build a db with the questions, answers, etc. or just > set them manually using cfset? If using the second method, how would you > display a percentage showing the grade for the test? > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342738 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Online Test
I would think the DB approach would be easier to maintain and scalable... -Original Message- From: John Eubanks [mailto:jae...@hotmail.com] Sent: Thursday, March 03, 2011 12:51 PM To: cf-talk Subject: Online Test I am building an online test (actually, several of them) and need some help. Would it be easier to build a db with the questions, answers, etc. or just set them manually using cfset? If using the second method, how would you display a percentage showing the grade for the test? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342737 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Online Test
Database is best because it gives you much more flexibility and allows you to reuse the code. The percentage is the number of right answers divided by the number of questions time one hundred. correct/total*100 On Thu, Mar 3, 2011 at 3:50 PM, John Eubanks wrote: > > I am building an online test (actually, several of them) and need some > help. Would it be easier to build a db with the questions, answers, etc. or > just set them manually using cfset? If using the second method, how would > you display a percentage showing the grade for the test? > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342736 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Online Test
I am building an online test (actually, several of them) and need some help. Would it be easier to build a db with the questions, answers, etc. or just set them manually using cfset? If using the second method, how would you display a percentage showing the grade for the test? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342735 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: I think I'm confused...
Thanks Mark that's a great tip. One thing I did find was that if you're using something other Notepad you need to put in the full path to the text editor, like this: "C:\Program Files (x86)\Notepad++\notepad++.exe" "C:\Windows\System32\drivers\etc\hosts" regards, larry >Here's another tip on this (cause I have to open my hosts file 20 times a >week). > >Drag the hosts file to the desktop with the left mouse and choose "create >short cut". > >Then right-click on the short cut and choose "properties" > >Change the "target" from > >C:\WINDOWS\system32\drivers\etc\hosts > >To... > >Notepad.exe "C:\WINDOWS\system32\drivers\etc\hosts" > >Then you can open and edit it willy nilly... > >-mark > > >Mark A. Kruger, MCSE, CFG >(402) 408-3733 ext 105 >Skype: markakruger >www.cfwebtools.com >www.coldfusionmuse.com >www.necfug.com > > > >Run Notepad.exe as Administrator >Open C:\windows\system32\drivers\etc\hosts (no file extension) >Add "127.0.0.1 www.mydomain.com" to the last line >Open web server and configure to route by hostname "www.mydomain.com" > > >Windows (by default) looks to your hosts file for name resolution before >checking a DNS server. I do something like this for all of my dev sites. > >Sent from my iPhone > >On Feb 23, 2011, at 8:52 PM, "Rick Faircloth" >wrote: ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342734 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Database Lookup - Possible with CF?
I forgot to mention that Ray Camden has a good blog post about filling in form
field values with jQuery and Ajax:
http://www.coldfusionjedi.com/index.cfm/2010/5/24/Example-of-jQuery-loading-form-fields
hth,
larry
> With jquery, no you can call a .cfm page. You just have to make sure
> the data is in the proper format. Here's an example where what's
> returned is just plain html:
>
>
> $('.subMenuItem').live('click', function() {
> var thelink = $(this);
> var theURL = thelink.attr('href');
> $("#contentDiv").load(theURL);
> return false;
> });
>
>
>
> Basically what happens here is that you're telling jQuery that
> whenever a user clicks on something with a subMenuItem class, you want
> to extract the value of the href attribute. Then do an ajax call to
> the href value (in this case vendors.cfm but it could also have been
> to a cfc). The final step inserts the returned information into the
> html of the contentDiv.
>
> In my vendors.cfm template there is a simple query and some html
> layout (basically a list of links), but it could have also been json
> data, xml or javascript. This setup is very similar to what is done
> with a binding on CFDiv.
>
> With what you want, I'd have the page return json, then in the
> javascript function build what you want from the returned json.
>
> Ben Nadel and Ray Camden have both written a lot on how to use jQuery
> with Coldfusion. You may want to check out their blogs for articles on
> the topic.
>
> hth,
> larry
>
>
> >Hi Craig et al
> >
> >Thanks for this
> >
> >So download JQuery and link to the file on your server
> >
> >Does it have to be a CFC? Its just that I have never used them
> before -
> >where would your SQL go in the CFC and would it be the same as a cfm
> >page
> >
> >i.e.
> > select * from emptable where employeenumber =
> >#form.employeenumber#
> >
> >
> >Then after you have queried the database - how would you populate
> the
> >form fields on the fly with the data you extracted from the database
> >based on what employee number had been entered
> >
> >For example I take it that
> > >value="#queryperson.empname#" .
> >
> >
> >Would not work?
> >
> >
> >Basically the easiest way to do ajax, is the following...
> >
> >1. download jquery libraries, or in your source code refer to
> different
> >hosting of the jquery libraries. jquery fyi, is javascript libraries,
>
> >that work cross-browser and make it easier to do things like ajax,
> and
> >millions of other things.
> >
> >2. Read this and any other article,
> >http://net.tutsplus.
> com/tutorials/javascript-ajax/5-ways-to-make-ajax-ca
> >lls-with-jquery/ to get a handle on how to use jquery.
> >
> >3. create a cfc, that can send/receive data you want.
> >
> >Yes this is a lot to learn, if you've never played with ajax or
> jquery
> >before. So I will show you some example code.
> >
> >You can either download a copy of the jquery libraries, or refer to
> a
> >cdn hosted copy on google or jquery.com, or a few other sites
> hosting
> >jquery libraries for public use.
> >
> >Then you need to create a cfc, which is basically like a coldfusion
> >normal template, except it has functions, instead of normal page
> logic.
> >
> >A cfc will be like this structure
> >
> >cfcomponent
> >
> >cffunction name="somename" access="remote" output="true"
> >cfargument name=company_id type=integer required=true
> >
> >do some stuff
> >
> >/cffunction
> >
> >/cfcomponent
> >
> >That's a very basic cfc, must be saved as a cfc extension.
> >
> >The 1st key part is making the cfc file in a web-accessible url
> folder.
> >
> >Then you have to create ajax that will send the parameters it needs
> to
> >do whatever functioning you need to do.
> >
> >I hope this get's you a good starting point
> >
> >
> >>Hi
> >>
> >>We are on CF7, not sure if this restricts the amount of
> functionality
> >>available to me?
> >>
> >>So how would it work - when a user types in their employee number
> in
> >the
> >on
> >>
> >>your server passing entered employee number as data/argument, which
> >will
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342733
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SSL Connection to Postgresql
> Thank you for the direction! My only question with this is that the host box > is creating this keystore, so how will it be moved to the remote client > box? The server and client will have separate keystores. You simply need to use keytool to import the server's certificates into the client's keystore. In this case, the client is your CF server. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342732 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Database Lookup - Possible with CF?
With jquery, no you can call a .cfm page. You just have to make sure the data
is in the proper format. Here's an example where what's returned is just plain
html:
$('.subMenuItem').live('click', function() {
var thelink = $(this);
var theURL = thelink.attr('href');
$("#contentDiv").load(theURL);
return false;
});
Basically what happens here is that you're telling jQuery that whenever a user
clicks on something with a subMenuItem class, you want to extract the value of
the href attribute. Then do an ajax call to the href value (in this case
vendors.cfm but it could also have been to a cfc). The final step inserts the
returned information into the html of the contentDiv.
In my vendors.cfm template there is a simple query and some html layout
(basically a list of links), but it could have also been json data, xml or
javascript. This setup is very similar to what is done with a binding on CFDiv.
With what you want, I'd have the page return json, then in the javascript
function build what you want from the returned json.
Ben Nadel and Ray Camden have both written a lot on how to use jQuery with
Coldfusion. You may want to check out their blogs for articles on the topic.
hth,
larry
>Hi Craig et al
>
>Thanks for this
>
>So download JQuery and link to the file on your server
>
>Does it have to be a CFC? Its just that I have never used them before -
>where would your SQL go in the CFC and would it be the same as a cfm
>page
>
>i.e.
> select * from emptable where employeenumber =
>#form.employeenumber#
>
>
>Then after you have queried the database - how would you populate the
>form fields on the fly with the data you extracted from the database
>based on what employee number had been entered
>
>For example I take it that
>value="#queryperson.empname#" .
>
>
>Would not work?
>
>
>Basically the easiest way to do ajax, is the following...
>
>1. download jquery libraries, or in your source code refer to different
>hosting of the jquery libraries. jquery fyi, is javascript libraries,
>that work cross-browser and make it easier to do things like ajax, and
>millions of other things.
>
>2. Read this and any other article,
>http://net.tutsplus.com/tutorials/javascript-ajax/5-ways-to-make-ajax-ca
>lls-with-jquery/ to get a handle on how to use jquery.
>
>3. create a cfc, that can send/receive data you want.
>
>Yes this is a lot to learn, if you've never played with ajax or jquery
>before. So I will show you some example code.
>
>You can either download a copy of the jquery libraries, or refer to a
>cdn hosted copy on google or jquery.com, or a few other sites hosting
>jquery libraries for public use.
>
>Then you need to create a cfc, which is basically like a coldfusion
>normal template, except it has functions, instead of normal page logic.
>
>A cfc will be like this structure
>
>cfcomponent
>
>cffunction name="somename" access="remote" output="true"
>cfargument name=company_id type=integer required=true
>
>do some stuff
>
>/cffunction
>
>/cfcomponent
>
>That's a very basic cfc, must be saved as a cfc extension.
>
>The 1st key part is making the cfc file in a web-accessible url folder.
>
>Then you have to create ajax that will send the parameters it needs to
>do whatever functioning you need to do.
>
>I hope this get's you a good starting point
>
>
>>Hi
>>
>>We are on CF7, not sure if this restricts the amount of functionality
>>available to me?
>>
>>So how would it work - when a user types in their employee number in
>the
>on
>>
>>your server passing entered employee number as data/argument, which
>will
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342731
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SSL Connection to Postgresql
> > I have a remote Redhat 5.0 box running PostgreSQL 8.0 and it's set > to accept SSL connections only. I have the 3 root/cert files > necessary for > > the handshaking to occur between host and client. The datasource to > the box works fine when unencrypted: jdbc:postgresql://x.x.x.x/main > (with > > ?ssl=true to be appended for encryption). > > > > My question is where do I put these files? I am running CF8 > Enterprise on Windows 2003. On my local machine I would have them in > the > > %appdata%/postgresql folder but this is a production-level box that > access the internet. > > You'll have to add the server cert to the client's Java keystore as > described here: > http://archives.postgresql.org/pgsql-jdbc/2003-08/msg00110.php Thank you for the direction! My only question with this is that the host box is creating this keystore, so how will it be moved or copied to the remote client box? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342730 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SSL Connection to Postgresql
> > I have a remote Redhat 5.0 box running PostgreSQL 8.0 and it's set > to accept SSL connections only. I have the 3 root/cert files > necessary for > > the handshaking to occur between host and client. The datasource to > the box works fine when unencrypted: jdbc:postgresql://x.x.x.x/main > (with > > ?ssl=true to be appended for encryption). > > > > My question is where do I put these files? I am running CF8 > Enterprise on Windows 2003. On my local machine I would have them in > the > > %appdata%/postgresql folder but this is a production-level box that > access the internet. > > You'll have to add the server cert to the client's Java keystore as > described here: > http://archives.postgresql.org/pgsql-jdbc/2003-08/msg00110.php Thank you for the direction! My only question with this is that the host box is creating this keystore, so how will it be moved to the remote client box? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342729 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SSL Connection to Postgresql
> I have a remote Redhat 5.0 box running PostgreSQL 8.0 and it's set to accept > SSL connections only. I have the 3 root/cert files necessary for > the handshaking to occur between host and client. The datasource to the box > works fine when unencrypted: jdbc:postgresql://x.x.x.x/main (with > ?ssl=true to be appended for encryption). > > My question is where do I put these files? I am running CF8 Enterprise on > Windows 2003. On my local machine I would have them in the > %appdata%/postgresql folder but this is a production-level box that access > the internet. You'll have to add the server cert to the client's Java keystore as described here: http://archives.postgresql.org/pgsql-jdbc/2003-08/msg00110.php Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsi ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342728 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SSL Connection to Postgresql
I have a remote Redhat 5.0 box running PostgreSQL 8.0 and it's set to accept SSL connections only. I have the 3 root/cert files necessary for the handshaking to occur between host and client. The datasource to the box works fine when unencrypted: jdbc:postgresql://x.x.x.x/main (with ?ssl=true to be appended for encryption). My question is where do I put these files? I am running CF8 Enterprise on Windows 2003. On my local machine I would have them in the %appdata%/postgresql folder but this is a production-level box that access the internet. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342727 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: RE: Database Lookup - Possible with CF?
Curious... Where are you that they are moving away from CF onto .NET and Java(ADF)? -- William E. Seiter On Mar 3, 2011, Ian Vaughan wrote: Hi Dave I'm willing to give CF a go, even though here the move is away from CF onto .NET and Java (ADF) Do you have any step by step tutorials that I could follow that I can use to implement the feature below in CF, if they can see what it can do it would certainly help its case. All I am looking to do is when a user fills in their employee number in a form text field, ajax calls CF to run a SQL query to bring back and populate the other fields in the form with that employees info. Is it really that difficult to achieve the above? Are there any ajax/jquery libraries I could use to integrate in with CF because javascript is not be strong point -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: 03 March 2011 15:02 To: cf-talk Subject: Re: Database Lookup - Possible with CF? > So would I be better developing this application in a language that is > more scaleable/future proof than CF You won't be using ASP.NET then, right? Because (a) it's not more scalable, and (b) any platform effectively limited to Windows is not more future-proof. I mean, I could see your point if you were talking about Java, even if I'd quibble on the scalability bit. Having worked with some high-scalability clients, I am very confident that CF is as scalable as .NET. I've mentioned them on the list before, so I'm not going to bother enumerating them now, but I'll be happy to provide further details on request. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342726 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Database Lookup - Possible with CF?
Ian, I just posted a blog entry about how easy jQuery & CF can handle using AJAX to populate a form: http://blog.pengoworks.com/index.cfm/2011/3/3/Easy-AJAX-using-ColdFusion-jQuery-and-CFCs -Dan On 3/3/2011 10:57 AM, Ian Vaughan wrote: > > Hi Dave > > I'm willing to give CF a go, even though here the move is away from CF > onto .NET and Java (ADF) > > Do you have any step by step tutorials that I could follow that I can > use to implement the feature below in CF, if they can see what it can do > it would certainly help its case. > > All I am looking to do is when a user fills in their employee number in > a form text field, ajax calls CF to run a SQL query to bring back and > populate the other fields in the form with that employees info. > > Is it really that difficult to achieve the above? Are there any > ajax/jquery libraries I could use to integrate in with CF because > javascript is not be strong point > > -Original Message- > From: Dave Watts [mailto:dwa...@figleaf.com] > Sent: 03 March 2011 15:02 > To: cf-talk > Subject: Re: Database Lookup - Possible with CF? > > >> So would I be better developing this application in a language that is >> more scaleable/future proof than CF > > You won't be using ASP.NET then, right? Because (a) it's not more > scalable, and (b) any platform effectively limited to Windows is not > more future-proof. I mean, I could see your point if you were talking > about Java, even if I'd quibble on the scalability bit. > > Having worked with some high-scalability clients, I am very confident > that CF is as scalable as .NET. I've mentioned them on the list > before, so I'm not going to bother enumerating them now, but I'll be > happy to provide further details on request. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > http://training.figleaf.com/ > > Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on > GSA Schedule, and provides the highest caliber vendor-authorized > instruction at our training centers, online, or onsite. > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342725 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Alert Pay API using ColdFusion
On Thu, Mar 3, 2011 at 12:07 PM, Dave Hatz wrote: > Alert Pay I don't use Alert Pay but I looked through the developer docs, it's just a URL post API, nothing fancy here. Just use CFHTTP and log the results back and continue with the order or decline it depending on the response code. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342724 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
web service wsdl rds
I use CFHTTP and HTTPPARAMS to access outside web services. I built a web service to consume and it functions properly. I can use SOAP software to read and post xml data. My problem is when I set up a file to emulate posting the xml data to the localhost/etc/my.cfc?wsdl using CFHTTP and HTTPPARAMS, I get the Enter your RDS or Admin Password screen. I must be missing something very basic. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342723 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Alert Pay API using ColdFusion
We have a client that wants us to integrate Alert Pay into his shopping cart. I tried searching for a Coldfusion method for their API, but didn't find much. Anyone used CF to communicate with Alert Pay's API? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342722 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Database Lookup - Possible with CF?
Hi, Ian... I use CF and jQuery all the time to perform all types of user-interface interaction, as well as ajax database access, using CF 8/9 and MySQL 5. I haven't used CF and jQuery to pre-fill a form, but it won't require much change in what I do now to make that happen. I've been planning to set up some tutorials on this sort of thing, but until I get those ready, I'd be willing to work directly with you to show you a simple example of the type of functionality you need and then help you get your work set up and working. Interested? Rick -Original Message- From: Ian Vaughan [mailto:i.vaug...@neath-porttalbot.gov.uk] Sent: Thursday, March 03, 2011 10:58 AM To: cf-talk Subject: RE: Database Lookup - Possible with CF? Hi Dave I'm willing to give CF a go, even though here the move is away from CF onto .NET and Java (ADF) Do you have any step by step tutorials that I could follow that I can use to implement the feature below in CF, if they can see what it can do it would certainly help its case. All I am looking to do is when a user fills in their employee number in a form text field, ajax calls CF to run a SQL query to bring back and populate the other fields in the form with that employees info. Is it really that difficult to achieve the above? Are there any ajax/jquery libraries I could use to integrate in with CF because javascript is not be strong point -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: 03 March 2011 15:02 To: cf-talk Subject: Re: Database Lookup - Possible with CF? > So would I be better developing this application in a language that is > more scaleable/future proof than CF You won't be using ASP.NET then, right? Because (a) it's not more scalable, and (b) any platform effectively limited to Windows is not more future-proof. I mean, I could see your point if you were talking about Java, even if I'd quibble on the scalability bit. Having worked with some high-scalability clients, I am very confident that CF is as scalable as .NET. I've mentioned them on the list before, so I'm not going to bother enumerating them now, but I'll be happy to provide further details on request. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342721 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Database Lookup - Possible with CF?
Hi Dave I'm willing to give CF a go, even though here the move is away from CF onto .NET and Java (ADF) Do you have any step by step tutorials that I could follow that I can use to implement the feature below in CF, if they can see what it can do it would certainly help its case. All I am looking to do is when a user fills in their employee number in a form text field, ajax calls CF to run a SQL query to bring back and populate the other fields in the form with that employees info. Is it really that difficult to achieve the above? Are there any ajax/jquery libraries I could use to integrate in with CF because javascript is not be strong point -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: 03 March 2011 15:02 To: cf-talk Subject: Re: Database Lookup - Possible with CF? > So would I be better developing this application in a language that is > more scaleable/future proof than CF You won't be using ASP.NET then, right? Because (a) it's not more scalable, and (b) any platform effectively limited to Windows is not more future-proof. I mean, I could see your point if you were talking about Java, even if I'd quibble on the scalability bit. Having worked with some high-scalability clients, I am very confident that CF is as scalable as .NET. I've mentioned them on the list before, so I'm not going to bother enumerating them now, but I'll be happy to provide further details on request. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342720 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Database Lookup - Possible with CF?
> So would I be better developing this application in a language that is > more scaleable/future proof than CF You won't be using ASP.NET then, right? Because (a) it's not more scalable, and (b) any platform effectively limited to Windows is not more future-proof. I mean, I could see your point if you were talking about Java, even if I'd quibble on the scalability bit. Having worked with some high-scalability clients, I am very confident that CF is as scalable as .NET. I've mentioned them on the list before, so I'm not going to bother enumerating them now, but I'll be happy to provide further details on request. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342719 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Database Lookup - Possible with CF?
> Thanks - Will take a look at it and evaluate how it compares with doing > it with ASP.net webforms or ASP.net MVC2 as its going to be a learning > curve whatever language I do it in, I suppose I'm leaning toward ASP as > this has a greater lifespan compared to CF. I wouldn't be so sure of that. I remember hearing the same thing about ASP 2 and 3, which are now a distant memory, and MS's previous template solution, which I don't even remember myself now. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342718 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Database Lookup - Possible with CF?
Thanks so it's just as easy/difficult to achieve this with a modern language such as ASP.net (web forms or MVC2) over Coldfusion which some are saying is reaching it's end of life, as there seems to be a steep learning curve for both. So would I be better developing this application in a language that is more scaleable/future proof than CF Do you know of any weblinks for this " You would use the success handler of your ajax call to populate the form. This will take some further research on your part." -Original Message- From: Steve 'Cutter' Blades [mailto:cold.fus...@cutterscrossing.com] Sent: 02 March 2011 16:01 To: cf-talk Subject: Re: Database Lookup - Possible with CF? Here is a brief tutorial on writing a CFC (Google is your friend) http://www.learn-coldfusion-tutorial.com/ColdFusion-Components.cfm You would put your query in a method in the CFC. You would use the success handler of your ajax call to populate the form. This will take some further research on your part. Steve 'Cutter' Blades Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://blog.cutterscrossing.com Co-Author "Learning Ext JS 3.2" Packt Publishing 2010 https://www.packtpub.com/learning-ext-js-3-2-for-building-dynamic-deskto p-style-user-interfaces/book "The best way to predict the future is to help create it" On 3/2/2011 9:30 AM, Ian Vaughan wrote: > Hi Craig et al > > Thanks for this > > So download JQuery and link to the file on your server > > Does it have to be a CFC? Its just that I have never used them before - > where would your SQL go in the CFC and would it be the same as a cfm > page > > i.e. > select * from emptable where employeenumber = > #form.employeenumber# > > > Then after you have queried the database - how would you populate the > form fields on the fly with the data you extracted from the database > based on what employee number had been entered > > For example I take it that > value="#queryperson.empname#" . > > > Would not work? > > > -Original Message- > From: Craig Rosenblum [mailto:crosenb...@gmail.com] > Sent: 02 March 2011 14:50 > To: cf-talk > Subject: Re: Database Lookup - Possible with CF? > > > Basically the easiest way to do ajax, is the following... > > 1. download jquery libraries, or in your source code refer to different > hosting of the jquery libraries. jquery fyi, is javascript libraries, > that work cross-browser and make it easier to do things like ajax, and > millions of other things. > > 2. Read this and any other article, > http://net.tutsplus.com/tutorials/javascript-ajax/5-ways-to-make-ajax-ca > lls-with-jquery/ to get a handle on how to use jquery. > > 3. create a cfc, that can send/receive data you want. > > Yes this is a lot to learn, if you've never played with ajax or jquery > before. So I will show you some example code. > > You can either download a copy of the jquery libraries, or refer to a > cdn hosted copy on google or jquery.com, or a few other sites hosting > jquery libraries for public use. > > Then you need to create a cfc, which is basically like a coldfusion > normal template, except it has functions, instead of normal page logic. > > A cfc will be like this structure > > cfcomponent > > cffunction name="somename" access="remote" output="true" > cfargument name=company_id type=integer required=true > > do some stuff > > /cffunction > > /cfcomponent ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342717 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: I'm confused/stumped - cant figure this out
Why are you using hidden text fields at all? You can put the amount in the options value attribute. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342716 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Database Lookup - Possible with CF?
Choosing ASP.NET could be for many valid reasons, because it comes with windows and is not a separate install, because it is FREE, because you already know ASP etc. But because it has a longer lifespan isnt really a good reason. As long as you have a copy of CF or Railo to run your code on, then your app has just as long a life span on cf as it does on ASP. If you use shared hosting then you could equally end up in the same position in the future, unable to find a host that supports older versions of ASP.NETor old versions of ColdFusion, in which case you would still need to update your code regardless. Using JQUERY is fairly simple in any language, the learning curve will generally be similar, however implementing it will be faster using the framework (ASP, PHP or CF) that you already know. Russ On Thu, Mar 3, 2011 at 11:32 AM, James Holmes wrote: > > (Apologies for going off topic) > > Forget MVC2 - MVC3 is far more flexible and has made a lot of > improvements. In the long run, getting up to date with MVC3 now is > going to be worth it. > > -- > WSS4CF - WS-Security framework for CF > http://wss4cf.riaforge.org/ > > > > On 3 March 2011 19:11, Ian Vaughan > wrote: > > > > Thanks - Will take a look at it and evaluate how it compares with doing > > it with ASP.net webforms or ASP.net MVC2 as its going to be a learning > > curve whatever language I do it in, I suppose I'm leaning toward ASP as > > this has a greater lifespan compared to CF. > > > > The reason of my asking in CF was if it was relatively easy to do I > > would have gone that route but if there is a similar learning curve to > > do it in VB then this would be a more scaleable and supported path > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342715 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Database Lookup - Possible with CF?
(Apologies for going off topic) Forget MVC2 - MVC3 is far more flexible and has made a lot of improvements. In the long run, getting up to date with MVC3 now is going to be worth it. -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 3 March 2011 19:11, Ian Vaughan wrote: > > Thanks - Will take a look at it and evaluate how it compares with doing > it with ASP.net webforms or ASP.net MVC2 as its going to be a learning > curve whatever language I do it in, I suppose I'm leaning toward ASP as > this has a greater lifespan compared to CF. > > The reason of my asking in CF was if it was relatively easy to do I > would have gone that route but if there is a similar learning curve to > do it in VB then this would be a more scaleable and supported path ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342714 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: I'm confused/stumped - cant figure this out
if you expect your commented out cfif statements to 'run' after a user selects an arrangement type - you are rather confused :) by the time your page is displayed in the browser, those cfif statements have already been evaluated and replaced with resulting html. Azadi On 03/03/2011 17:20 , Toby King wrote: > Over the last couple of days have been fiddling with a website that I worked > on a few years ago. Have converted the site from essentially a static site > to a dynamic site - running under Mura CMS - using Mura gives the site owners > the ability to make most changes themselves. > > I'm trying to include a simple shopping cart system, but have 1 small problem > - wondering if you could have a quick look at the code and maybe suggest what > I could do to get around the error. > > Here is the code > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342713 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Database Lookup - Possible with CF?
Thanks - Will take a look at it and evaluate how it compares with doing it with ASP.net webforms or ASP.net MVC2 as its going to be a learning curve whatever language I do it in, I suppose I'm leaning toward ASP as this has a greater lifespan compared to CF. The reason of my asking in CF was if it was relatively easy to do I would have gone that route but if there is a similar learning curve to do it in VB then this would be a more scaleable and supported path -Original Message- From: Steve 'Cutter' Blades [mailto:cold.fus...@cutterscrossing.com] Sent: 02 March 2011 16:01 To: cf-talk Subject: Re: Database Lookup - Possible with CF? Here is a brief tutorial on writing a CFC (Google is your friend) http://www.learn-coldfusion-tutorial.com/ColdFusion-Components.cfm You would put your query in a method in the CFC. You would use the success handler of your ajax call to populate the form. This will take some further research on your part. Steve 'Cutter' Blades Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://blog.cutterscrossing.com Co-Author "Learning Ext JS 3.2" Packt Publishing 2010 https://www.packtpub.com/learning-ext-js-3-2-for-building-dynamic-deskto p-style-user-interfaces/book "The best way to predict the future is to help create it" On 3/2/2011 9:30 AM, Ian Vaughan wrote: > Hi Craig et al > > Thanks for this > > So download JQuery and link to the file on your server > > Does it have to be a CFC? Its just that I have never used them before - > where would your SQL go in the CFC and would it be the same as a cfm > page > > i.e. > select * from emptable where employeenumber = > #form.employeenumber# > > > Then after you have queried the database - how would you populate the > form fields on the fly with the data you extracted from the database > based on what employee number had been entered > > For example I take it that > value="#queryperson.empname#" . > > > Would not work? > > > -Original Message- > From: Craig Rosenblum [mailto:crosenb...@gmail.com] > Sent: 02 March 2011 14:50 > To: cf-talk > Subject: Re: Database Lookup - Possible with CF? > > > Basically the easiest way to do ajax, is the following... > > 1. download jquery libraries, or in your source code refer to different > hosting of the jquery libraries. jquery fyi, is javascript libraries, > that work cross-browser and make it easier to do things like ajax, and > millions of other things. > > 2. Read this and any other article, > http://net.tutsplus.com/tutorials/javascript-ajax/5-ways-to-make-ajax-ca > lls-with-jquery/ to get a handle on how to use jquery. > > 3. create a cfc, that can send/receive data you want. > > Yes this is a lot to learn, if you've never played with ajax or jquery > before. So I will show you some example code. > > You can either download a copy of the jquery libraries, or refer to a > cdn hosted copy on google or jquery.com, or a few other sites hosting > jquery libraries for public use. > > Then you need to create a cfc, which is basically like a coldfusion > normal template, except it has functions, instead of normal page logic. > > A cfc will be like this structure > > cfcomponent > > cffunction name="somename" access="remote" output="true" > cfargument name=company_id type=integer required=true > > do some stuff > > /cffunction > > /cfcomponent > > That's a very basic cfc, must be saved as a cfc extension. > > The 1st key part is making the cfc file in a web-accessible url folder. > > Then you have to create ajax that will send the parameters it needs to > do whatever functioning you need to do. > > I hope this get's you a good starting point > > >> Hi >> >> We are on CF7, not sure if this restricts the amount of functionality >> available to me? >> >> So how would it work - when a user types in their employee number in > the >> text field how would ajax call a SQL query to lookup the data in the db >> table to populate the rest of the fields in the form. >> >> Do you have any code examples, as I am struggling to grasp how to >> implement this at the moment? >> >> Many Thanks >> >> It is definitely possible and rather easy using CF (or just plain >> javascript) - all you need to do is make an ajax request to a cfc/cfm > on >> your server passing entered employee number as data/argument, which > will >> return necessary data based on emp number. You then populate necessary >> fields with returned data. >> CF's built-in ajax functionality will come in handy here (i.e. cfinput >> fields with bind attribute pointing to your cfc method), but not >> required - same is easily achieved with a regular js ajax request; >> jQuery will even make it fun. >> If you are not very familiar with javascript, and you are running CF8+, >> then use the built-in cf functionality. All you need is well described >> in CF Developer's Guide (download pdf from adobe.com) and numerous >> blogs. >> >> Azadi >> >> On 02/03/2011 17:37 , Ian Vaughan wrote: >> t
I'm confused/stumped - cant figure this out
Over the last couple of days have been fiddling with a website that I worked on a few years ago. Have converted the site from essentially a static site to a dynamic site - running under Mura CMS - using Mura gives the site owners the ability to make most changes themselves. I'm trying to include a simple shopping cart system, but have 1 small problem - wondering if you could have a quick look at the code and maybe suggest what I could do to get around the error. Here is the code http://www.swanseaflowers.com.au/store/view-cart/"; method="post" name="ProductDetails"> Zoe Modern Arrangement of Lilies Select the arangement type: Please SelectStandard $75.00Deluxe $100.00 Quantity: Basically the code as it is with the commented code taken out works - but the limitation is that it then only works with the value $100. I basically want the user to select whether they select the standard or deluxe product. If I replace the line in green and use the lines that are commented out I get the following error message: The amount argument passed to the Add function is not of type numeric. This is despite the fact that the code is the same as that shown in green - only that it is included in a statement I have dumped the form when it is working but when the error occurs I do not get anything but the error message Thanks in advance ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342711 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
