coldfusion and MySql
Hi folks Any recommendation for a good starter book for coldfusion and Mysql Thanks Rob ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330849 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: coldfusion and MySql
I don't know that there's a book that really covers the two topics together, if that's what you're asking. The interaction between CF and whatever database you choose to use is really pretty much the same. The only difference would be in your cfqueries, knowing that the SQL you're writing is appropriate for the database engine you're using. e.g. SELECT TOP 10 * FROM tablename will work in SQL Server, but not mySQL. If you want a CF book, check out the ColdFusion Web Application Construction Kit series. If you want a book on mySQL...well, unfortunately I can't really offer up a recommendation (altho there's rumored to be a mySQL book written by some guy named Ben Forta). Is there anything specific that you're looking to see addressed in a book? Just curious if you're looking for a book on ColdFusion, mySQL, or again... one that covers both. On Wed, Feb 17, 2010 at 3:18 PM, Rob Voyle robvo...@voyle.com wrote: Hi folks Any recommendation for a good starter book for coldfusion and Mysql Thanks Rob ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330851 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Unnallowable Chars for Coldfusion, HTML, MySQL and Javascript
Hi we build our software with coldfusion, Javascript, HTML, and MySQL. just wondering if anyone has a list of allowable and unallowable characters and symbols (,,$, etc...) for all of these languages. and maybe if characters are not allowable how we can get round these issues if we need the users to be able to input them thanks very much ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292205 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion and MySQL Stored Functions
Richard White wrote: Just like a built-in function: SELECT function(argument) thanks for your reply. do i have to encapsulate it in cfquery tag, or do i have to direct it to the database? cfquery ... SELECT function(argument) /cfquery Jochem ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288537 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion and MySQL Stored Functions
cfquery ...
SELECT function(argument)
/cfquery
Thanks for the reply, i am getting an error running this code saying that it
cannot be indexed correctly.
my stored function takes in 2 varchars - an email address and password and
returns a boolean, so when i call the function i write the following:
cfquery name=myquery datasource=db
select functionName('[EMAIL PROTECTED]', 'myPassword')
/cfquery
and it gives the error: cannot be indexed correctly.
is it something to do with the quotation marks i am using?
also how do i check if it returned a true or false from this (my stored
function returns a boolean value true or false variable called queryResult)
Thanks very much for your help
richard
~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288540
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion and MySQL Stored Functions
this is the error it is giving me:
[Table (rows 1 columns myfunction('[EMAIL PROTECTED]','myPassword')):
[myfunction('[EMAIL PROTECTED]','myPassword')): [EMAIL PROTECTED] ] is not
indexable by myfunction('[EMAIL PROTECTED]'
Thanks again for your help
~|
Enterprise web applications, build robust, secure
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288541
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion and MySQL Stored Functions
Richard White wrote:
cfquery name=myquery datasource=db
select functionName('[EMAIL PROTECTED]', 'myPassword')
/cfquery
and it gives the error: cannot be indexed correctly.
That is because CF tries to create a column from the result with the
name functionName('[EMAIL PROTECTED]', 'myPassword') and that is not
a valid column name in CF.
cfquery name=myquery datasource=db
select functionName('[EMAIL PROTECTED]', 'myPassword') AS queryResult
/cfquery
also how do i check if it returned a true or false from this (my stored
function returns a boolean value true or false variable called queryResult)
Just dump the query and you will see what is in it.
Jochem
~|
Enterprise web applications, build robust, secure
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288544
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion and MySQL Stored Functions
Hi Jochem, Thats brilliant its working fine now :) thanks for your help Richard ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288549 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Coldfusion and MySQL Stored Functions
Hi, just wondering if anyone knows how to call stored functions in MySQL from coldfusion. We have been calling MySQL stored procedures fine using the cfstoredproc tag but have no idea how to call MySQL stored functions. We have tried doing it through the cfstoredproc tag but of course it tells us that the procedure doesnt exist in the database - as it is of course stored as a function thanks for any help richard ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288527 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion and MySQL Stored Functions
Richard White wrote: just wondering if anyone knows how to call stored functions in MySQL from coldfusion. Just like a built-in function: SELECT function(argument) Jochem ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288528 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion and MySQL Stored Functions
Just like a built-in function: SELECT function(argument) thanks for your reply. do i have to encapsulate it in cfquery tag, or do i have to direct it to the database? can you give me an example with cf code please and how do i access the variable it returns? thanks very much ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288529 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ColdFusion and MySQL Web Hosts
Good reliable UK based host - http://titaninternet.com/ Been using them for a customers site for a few years now without any problems, good support too. On 02/09/07, Larry Schaberg [EMAIL PROTECTED] wrote: I also have used crystaltech for myself and for my clients and love them. I have used them for years. Hi, Just wondering if anyone knows of any good ColdFusion and MySQL web hosting companies? We are based in the UK but wouldn't mind hosts in the UK or USA. Thanks very much ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287649 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ColdFusion and MySQL Web Hosts
I also have used crystaltech for myself and for my clients and love them. I have used them for years. Hi, Just wondering if anyone knows of any good ColdFusion and MySQL web hosting companies? We are based in the UK but wouldn't mind hosts in the UK or USA. Thanks very much ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287641 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
ColdFusion and MySQL Web Hosts
Hi, Just wondering if anyone knows of any good ColdFusion and MySQL web hosting companies? We are based in the UK but wouldn't mind hosts in the UK or USA. Thanks very much ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287603 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ColdFusion and MySQL Web Hosts
I have had nothing but a good experience with crystaltech for the past 4 years. On 9/1/07, Richard White [EMAIL PROTECTED] wrote: Hi, Just wondering if anyone knows of any good ColdFusion and MySQL web hosting companies? We are based in the UK but wouldn't mind hosts in the UK or USA. Thanks very much ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287605 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
