Re: OT: newbie FB5? or newbie FB6
Well, what about invoking functions from within the circuit.xml file. Again, I am thinking about upgrading the framework that I use (a modified fusebox framework). FB5 looks good but I wanted to move away from the "act_add_member.cfm" and "qry_list_member.cfm" methodology which seperates database calls to the same entity into two files; to a methodology that puts all "member" database request in one file with dmany functions. In other words, a "member" cfc file. I am concerned that fusebox does not support nor leverage the value of .cfc objects. -- Original Message -- From: "J.J. Merrick" <[EMAIL PROTECTED]> Reply-To: cf-talk@houseoffusion.com Date: Sat, 16 Jun 2007 15:32:05 -0500 > >Since Fusebox 4.1 and the incorporation of the total rewrite it has been a >priority to make all new releases of FB be backwards compatible. Essentially >anything that runs in 5 is going to work in 5.5 and 6.0. > >I would say start to dive in now since there isn't going to be such a large >rewrite in the future where you are going to have to learn a bunch of new >things. The changes like we saw in 3 > 4.1 are not going to happen in a >future release for a very very long time. > >J.J. M > > >On 6/16/07, Dwayne Cole <[EMAIL PROTECTED]> wrote: >> >> I stopped using fusebox once FB3 was implement. It just got a little to >> complex for me. However I stuck with the basic concepts of fuses and >> circuites. My circuit files are still basically one big cfswitch / cfcase >> tag. >> >> I am considering moveing to FB5. It seems attractive becuase the Fusebox >> Framework appears to be blackbox and it seems that I don't need to ticker >> with any non-value added details. >> >> I am also attracted to the concept of converting my cfswitch structure to >> a nice circuit.xml file. Furthermore the dot notation for the fuseaction >> request is very appealing; now my "index.cfm?action= >> browseFirm&perform=showService List" can be replaced with "index.cfm?fuseacti >> on=browseFirm. showServiceList" Cool. >> >> Basically I like alot about th FB5 format but now there's talk about FB6 >> or FBMX. Should I wait? >> >> >> > > ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281390 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: setting xml encoding
> What would a DTD look like for something with text nodes > instead of elements? > Can you say X element should have X nodes? Not exactly. DTDs and schemas describe elements, attributes, and the relationships between them. Nodes result from the parsing of an XML document. Within a DTD, you can declare that an element contains parseable character data, or child elements, or both, but you can't declare how child elements are arranged with regard to character data. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281389 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Telnet/SSH From CF?
On 16 Jun 2007, at 12:11, Robert Rawlins wrote: > I'm looking to access a remote Telnet/SSH server and run a few > differet commands. I know quite some time back I was reading > through a scorpio wish list and one of the items listed (and > getting a few votes) was cftelnet as a tag. Can anyone confirm is > Adobe have put this in to scorpio? There's no mention of that tag in cf8_beta_cfmlreference_052907.pdf. > However, cf8 aside, I need to have somthing to tide me over, does > anyone know if there is anything available? If nothing native to CF > then i'm sure that I'll be able to utilize some form of JAVA > classes to do the job. The easiest solution would be to call a shell script and native SSH program with cfexecute. You would need to make sure that ~/.ssh is correct for the user that the process runs as. If you need more programmatic control at runtime, you might look at cfsftp.cfc available from http://www.socialpoints.com. That project uses JSch (http://www.jcraft.com/jsch/) to perform file transfer with SSH. It wouldn't be trivial to use that CFC as an example to build from in making a wrapper for arbitrary shell commands through SSH, instead of SFTP. But it would be possible. -- Joseph Lamoree ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281388 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using cfinclude and udfs on application.cfm
yeah the CFC is obviously different in the way that it works but the .cfm is just a standard CFM page. J.J. On 6/16/07, Michael E. Carluen <[EMAIL PROTECTED]> wrote: > > Lotsa thanks JJ. > > That's what I originally thought it was, but I was not entirely sure if > there was any other inherent and unique properties of the application.cfm/cfc > that makes it different from the standard cf template. > > Again, thanks... if there are any other folks who think otherwise, please > continue the thread. Otherwise, JJ answered my question. > > > > -Original Message- > > From: J.J. Merrick [mailto:[EMAIL PROTECTED] > > Sent: Saturday, June 16, 2007 1:28 PM > > To: CF-Talk > > Subject: Re: Using cfinclude and udfs on application.cfm > > > > The application.cfm runs prior to all pages thus is nothing really > > "special" > > about it. it is just called that because it is a nice place to put > > application level variables. So to answer your question YES it is ok to > > put > > a cfinclude inside of it and I do that often. > > > > J.J. M > > > > On 6/16/07, Michael E. Carluen <[EMAIL PROTECTED]> wrote: > > > > > > Hi all. I am updating a legacy app that is still using an > > application.cfm > > > (not a .cfc). The update simply adds a cfinclude tag for a udf > > > library. Is > > > there anything "illegal" (for a lack of a better term) about adding > > > cfincludes on an application.cfm? > > > > > > It works, but would like to confirm whether or not the practice is not > > > recommended or would post a risk down the line. > > > > > > Thanks all. > > > > > > Michael > > > > > > > > > > > > > > > > > > ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281387 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Using cfinclude and udfs on application.cfm
Lotsa thanks JJ. Thatâs what I originally thought it was, but I was not entirely sure if there was any other inherent and unique properties of the application.cfm/cfc that makes it different from the standard cf template. Again, thanks... if there are any other folks who think otherwise, please continue the thread. Otherwise, JJ answered my question. > -Original Message- > From: J.J. Merrick [mailto:[EMAIL PROTECTED] > Sent: Saturday, June 16, 2007 1:28 PM > To: CF-Talk > Subject: Re: Using cfinclude and udfs on application.cfm > > The application.cfm runs prior to all pages thus is nothing really > "special" > about it. it is just called that because it is a nice place to put > application level variables. So to answer your question YES it is ok to > put > a cfinclude inside of it and I do that often. > > J.J. M > > On 6/16/07, Michael E. Carluen <[EMAIL PROTECTED]> wrote: > > > > Hi all. I am updating a legacy app that is still using an > application.cfm > > (not a .cfc). The update simply adds a cfinclude tag for a udf > > library. Is > > there anything "illegal" (for a lack of a better term) about adding > > cfincludes on an application.cfm? > > > > It works, but would like to confirm whether or not the practice is not > > recommended or would post a risk down the line. > > > > Thanks all. > > > > Michael > > > > > > > > > > ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281386 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Error converting data type varchar to int.
Hello Neil, I'm running SQL Server 2005, and this is a create table script for you. CREATE TABLE Credential ( Credential_ID INTEGER NOT NULL IDENTITY(1,1) , User_ID INTEGER NOT NULL , Username VARCHAR(200) , Password VARCHAR(200) ) The stored proceedure is a simple insert script, which is somthing like this: CREATE PROC Credential_Create @User_ID INTEGER, @Password VARCHAR(200), @Username VARCHAR(200) AS INSERT INTO Credential (User_ID, Username, Password) VALUES (@User_ID, @Username, @Password) Thanks for any further insight mate, Rob > What version of SQL Server is it again? What are the underlying datatypes > specifically? And how many records? > > > > "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, > Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, > Registered in England, Number 678540. It contains information which is > confidential and may also be privileged. It is for the exclusive use of > the > intended recipient(s). If you are not the intended recipient(s) please > note > that any form of distribution, copying or use of this communication or the > information in it is strictly prohibited and may be unlawful. If you have > received this communication in error please return it to the sender or > call > our switchboard on +44 (0) 20 89107910. The opinions expressed within > this > communication are not necessarily those expressed by Reed Exhibitions." > Visit our website at http://www.reedexpo.com > > -Original Message- > From: [EMAIL PROTECTED] > To: CF-Talk > Sent: Sat Jun 16 20:06:54 2007 > Subject: Re: Error converting data type varchar to int. > > Hi Neil, > > Thanks for the tip on the name of sp's I didnt realize that was the case, > I'll rename them all from now on in, just to keep to the best practice. > > Now, as far as the type setting is concerned, how can I convert/cast the > input types on the server side? I dont think that somthing I've done > before, are you able to give me a code example or somthing? > > However, I'm doubtfull that is causing the issue, as if I remove > encryption off those fields so i'm just passing in the plain string of > 'testusername' and 'testpassword' and it still throws the error. > > I've cut down the stored proc so I have the values hard coded in to it, > and this still throws an issue. > > > datasource="#VARIABLES.Instance.Datasource.getDatasource()#" > username="#VARIABLES.Instance.Datasource.getUsername()#" > password="#VARIABLES.Instance.Datasource.getPassword()#"> >/> >cfsqltype="cf_sql_varchar" /> >cfsqltype="cf_sql_varchar" /> > > > If you spot anything that seems out of place that would be great. Like i > say, if i put those exact same values into a EXEC statement in SSMS then > it inserts the records absolutly fine. > > Thanks guys, this is all confusing, I really appreciate the help. > > Rob > >> This error can sometimes be raised when you are passing in a value to a >> column of a certain type but the column contains most if not all values >> of >> another - I.e. VARCHAR column but all the values in it are technically >> ints. >> Have your tried to convert/cast the input values server side as well? >> >> Also, it is advisable to not create a user SP with a prefix of sp_, >> these >> should be reserved for system procs as per info in BOL. >> >> >> >> >> >> >> "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, >> Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, >> Registered in England, Number 678540. It contains information which is >> confidential and may also be privileged. It is for the exclusive use of >> the >> intended recipient(s). If you are not the intended recipient(s) please >> note >> that any form of distribution, copying or use of this communication or >> the >> information in it is strictly prohibited and may be unlawful. If you >> have >> received this communication in error please return it to the sender or >> call >> our switchboard on +44 (0) 20 89107910. The opinions expressed within >> this >> communication are not necessarily those expressed by Reed Exhibitions." >> Visit our website at http://www.reedexpo.com >> >> -Original Message- >> From: Robert Rawlins - Think Blue >> To: CF-Talk >> Sent: Fri Jun 15 10:56:00 2007 >> Subject: RE: Error converting data type varchar to int. >> >> Right you are Jochem! >> >> Here is the stored proc code: >> >> CREATE PROCEDURE Sp_Credential_Create >> @User_IDINTEGER, >> @Username VARCHAR(128), >> @Password VARCHAR(128) >> AS >> SET NOCOUNT ON >> INSERT INTO Credential (User_ID, Username, Password) >> VALUES (@User_ID, @Username, @Password) >> >> And here is the function that fires the stored proc. >> >> >> > returntype="void" >> hint="I create a record in persistance"> >> >> > hint="Username" /> >> > hint="Password" /> >> >> >> >> >> >> > data
Re: OT: newbie FB5? or newbie FB6
Since Fusebox 4.1 and the incorporation of the total rewrite it has been a priority to make all new releases of FB be backwards compatible. Essentially anything that runs in 5 is going to work in 5.5 and 6.0. I would say start to dive in now since there isn't going to be such a large rewrite in the future where you are going to have to learn a bunch of new things. The changes like we saw in 3 > 4.1 are not going to happen in a future release for a very very long time. J.J. M On 6/16/07, Dwayne Cole <[EMAIL PROTECTED]> wrote: > > I stopped using fusebox once FB3 was implement. It just got a little to > complex for me. However I stuck with the basic concepts of fuses and > circuites. My circuit files are still basically one big cfswitch / cfcase > tag. > > I am considering moveing to FB5. It seems attractive becuase the Fusebox > Framework appears to be blackbox and it seems that I don't need to ticker > with any non-value added details. > > I am also attracted to the concept of converting my cfswitch structure to > a nice circuit.xml file. Furthermore the dot notation for the fuseaction > request is very appealing; now my "index.cfm?action= > browseFirm&perform=showService List" can be replaced with "index.cfm?fuseacti > on=browseFirm. showServiceList" Cool. > > Basically I like alot about th FB5 format but now there's talk about FB6 > or FBMX. Should I wait? > > > ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281384 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using cfinclude and udfs on application.cfm
The application.cfm runs prior to all pages thus is nothing really "special" about it. it is just called that because it is a nice place to put application level variables. So to answer your question YES it is ok to put a cfinclude inside of it and I do that often. J.J. M On 6/16/07, Michael E. Carluen <[EMAIL PROTECTED]> wrote: > > Hi all. I am updating a legacy app that is still using an application.cfm > (not a .cfc). The update simply adds a cfinclude tag for a udf > library. Is > there anything "illegal" (for a lack of a better term) about adding > cfincludes on an application.cfm? > > It works, but would like to confirm whether or not the practice is not > recommended or would post a risk down the line. > > Thanks all. > > Michael > > > > ~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281383 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Using cfinclude and udfs on application.cfm
Btw, just for clarity, the udf library is being used, of course, for just a couple functions to be used within the application.cfm. > -Original Message- > From: Michael E. Carluen [mailto:[EMAIL PROTECTED] > Sent: Saturday, June 16, 2007 11:45 AM > To: CF-Talk > Subject: Using cfinclude and udfs on application.cfm > > Hi all. I am updating a legacy app that is still using an application.cfm > (not a .cfc). The update simply adds a cfinclude tag for a udf library. > Is > there anything "illegal" (for a lack of a better term) about adding > cfincludes on an application.cfm? > > It works, but would like to confirm whether or not the practice is not > recommended or would post a risk down the line. > > Thanks all. > > Michael > > > > ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281382 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Error converting data type varchar to int.
What version of SQL Server is it again? What are the underlying datatypes specifically? And how many records? "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -Original Message- From: [EMAIL PROTECTED] To: CF-Talk Sent: Sat Jun 16 20:06:54 2007 Subject: Re: Error converting data type varchar to int. Hi Neil, Thanks for the tip on the name of sp's I didnt realize that was the case, I'll rename them all from now on in, just to keep to the best practice. Now, as far as the type setting is concerned, how can I convert/cast the input types on the server side? I dont think that somthing I've done before, are you able to give me a code example or somthing? However, I'm doubtfull that is causing the issue, as if I remove encryption off those fields so i'm just passing in the plain string of 'testusername' and 'testpassword' and it still throws the error. I've cut down the stored proc so I have the values hard coded in to it, and this still throws an issue. If you spot anything that seems out of place that would be great. Like i say, if i put those exact same values into a EXEC statement in SSMS then it inserts the records absolutly fine. Thanks guys, this is all confusing, I really appreciate the help. Rob > This error can sometimes be raised when you are passing in a value to a > column of a certain type but the column contains most if not all values of > another - I.e. VARCHAR column but all the values in it are technically > ints. > Have your tried to convert/cast the input values server side as well? > > Also, it is advisable to not create a user SP with a prefix of sp_, these > should be reserved for system procs as per info in BOL. > > > > > > > "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, > Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, > Registered in England, Number 678540. It contains information which is > confidential and may also be privileged. It is for the exclusive use of > the > intended recipient(s). If you are not the intended recipient(s) please > note > that any form of distribution, copying or use of this communication or the > information in it is strictly prohibited and may be unlawful. If you have > received this communication in error please return it to the sender or > call > our switchboard on +44 (0) 20 89107910. The opinions expressed within > this > communication are not necessarily those expressed by Reed Exhibitions." > Visit our website at http://www.reedexpo.com > > -Original Message- > From: Robert Rawlins - Think Blue > To: CF-Talk > Sent: Fri Jun 15 10:56:00 2007 > Subject: RE: Error converting data type varchar to int. > > Right you are Jochem! > > Here is the stored proc code: > > CREATE PROCEDURE Sp_Credential_Create > @User_IDINTEGER, > @Username VARCHAR(128), > @Password VARCHAR(128) > AS > SET NOCOUNT ON > INSERT INTO Credential (User_ID, Username, Password) > VALUES(@User_ID, @Username, @Password) > > And here is the function that fires the stored proc. > > > hint="I create a record in persistance"> > >hint="Username" /> >hint="Password" /> > > > > > >datasource="#VARIABLES.Instance.Datasource.getDatasource()#" > username="#VARIABLES.Instance.Datasource.getUsername()#" > password="#VARIABLES.Instance.Datasource.getPassword()#"> >cfsqltype="cf_sql_integer" maxlength="128" /> > value="#VARIABLES.Instance.Cryptographer.getEncrypted(ARGUMENTS.Username)#" > variable="Username" cfsqltype="cf_sql_varchar" maxlength="128" /> > > value="#VARIABLES.Instance.Cryptographer.getEncrypted(ARGUMENTS.Password)#" > variable="Password" cfsqltype="cf_sql_varchar" maxlength="128" /> > > > > > > And finally the code that triggers the function. > > > > Hope that all makes sense to you, it would be great to figure out what's > causing this. > > Thanks, > > Rob > > -Original Message- > From: Jochem van Dieten [mailto:[EMAIL PROTECTED] > Sent: 14 June 2007 18:21 > To: CF-Talk > Subject: Re: Error converting data type varchar to int. > > Robert Rawlins - Think Blue wrote: >> >> [Macromedi
Re: Updated Broadband Stats
So, to echo a thread I have going on community... With frameworks, and modular code, etc., etc., you could easily generate targeted output formats for your data, be it wrapped in Flash or just Plain Text. So long as your forms degrade nice, you can even use the same HTML but without the javascript, etc., for low-bandwidth/non js-ers. But, is that even wanted? Do people want to experience "The Web" as it's "supposed to be" so bad they would (for a lack of better phraseology) "rather wait" ? Basically what I'm wondering is why the focus on making one medium be all things to all people vs. having various mediums (medium is not the right word) available, for the various populations you are serving? Is content negotiation so hit and miss that it doesn't really work as cool as it should? Why bother with "mark up" style data if we don't utilize the fact that it's marked up to serve it out however it's needed? How come so much CF uses .cfm, when there's a ton that could be written to plain html, sparing CF cycles? Cache takes care of it? Just some random (if you can call them) thoughts... =] ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281380 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using sessions with Flash Remoting
Thanks again Dave, CF's scheduler looks like it will do the job, and seems more suited for what I'm doing than sessions. John On Jun 16, 2007, at 12:44 PM, Dave Watts wrote: >> Aha! That might be the ticket! Is this something built into >> CF, or are you talking more along the lines of something like >> a cron job? > > CF has a scheduler, but you can use your OS scheduler (cron, at, > whatever) > as well. Historically, there have been problems with CF's > scheduler, so I > got into the habit of using the OS scheduler instead, but I suspect > those > problems no longer exist. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281379 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Telnet/SSH From CF?
Hello Guys, I'm looking to access a remote Telnet/SSH server and run a few differet commands. I know quite some time back I was reading through a scorpio wish list and one of the items listed (and getting a few votes) was cftelnet as a tag. Can anyone confirm is Adobe have put this in to scorpio? I did have a link to the doc that listed all the new functions, but forgot to look at it myself :-D However, cf8 aside, I need to have somthing to tide me over, does anyone know if there is anything available? If nothing native to CF then i'm sure that I'll be able to utilize some form of JAVA classes to do the job. I'm just looking for someone with a little experiance in this, anyone on the lists played with this before? Thanks guys, Rob ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281378 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Error converting data type varchar to int.
Hi Neil, Thanks for the tip on the name of sp's I didnt realize that was the case, I'll rename them all from now on in, just to keep to the best practice. Now, as far as the type setting is concerned, how can I convert/cast the input types on the server side? I dont think that somthing I've done before, are you able to give me a code example or somthing? However, I'm doubtfull that is causing the issue, as if I remove encryption off those fields so i'm just passing in the plain string of 'testusername' and 'testpassword' and it still throws the error. I've cut down the stored proc so I have the values hard coded in to it, and this still throws an issue. If you spot anything that seems out of place that would be great. Like i say, if i put those exact same values into a EXEC statement in SSMS then it inserts the records absolutly fine. Thanks guys, this is all confusing, I really appreciate the help. Rob > This error can sometimes be raised when you are passing in a value to a > column of a certain type but the column contains most if not all values of > another - I.e. VARCHAR column but all the values in it are technically > ints. > Have your tried to convert/cast the input values server side as well? > > Also, it is advisable to not create a user SP with a prefix of sp_, these > should be reserved for system procs as per info in BOL. > > > > > > > "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, > Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, > Registered in England, Number 678540. It contains information which is > confidential and may also be privileged. It is for the exclusive use of > the > intended recipient(s). If you are not the intended recipient(s) please > note > that any form of distribution, copying or use of this communication or the > information in it is strictly prohibited and may be unlawful. If you have > received this communication in error please return it to the sender or > call > our switchboard on +44 (0) 20 89107910. The opinions expressed within > this > communication are not necessarily those expressed by Reed Exhibitions." > Visit our website at http://www.reedexpo.com > > -Original Message- > From: Robert Rawlins - Think Blue > To: CF-Talk > Sent: Fri Jun 15 10:56:00 2007 > Subject: RE: Error converting data type varchar to int. > > Right you are Jochem! > > Here is the stored proc code: > > CREATE PROCEDURE Sp_Credential_Create > @User_IDINTEGER, > @Username VARCHAR(128), > @Password VARCHAR(128) > AS > SET NOCOUNT ON > INSERT INTO Credential (User_ID, Username, Password) > VALUES(@User_ID, @Username, @Password) > > And here is the function that fires the stored proc. > > > hint="I create a record in persistance"> > >hint="Username" /> >hint="Password" /> > > > > > >datasource="#VARIABLES.Instance.Datasource.getDatasource()#" > username="#VARIABLES.Instance.Datasource.getUsername()#" > password="#VARIABLES.Instance.Datasource.getPassword()#"> >cfsqltype="cf_sql_integer" maxlength="128" /> >value="#VARIABLES.Instance.Cryptographer.getEncrypted(ARGUMENTS.Username)#" > variable="Username" cfsqltype="cf_sql_varchar" maxlength="128" /> > >value="#VARIABLES.Instance.Cryptographer.getEncrypted(ARGUMENTS.Password)#" > variable="Password" cfsqltype="cf_sql_varchar" maxlength="128" /> > > > > > > And finally the code that triggers the function. > > > > Hope that all makes sense to you, it would be great to figure out what's > causing this. > > Thanks, > > Rob > > -Original Message- > From: Jochem van Dieten [mailto:[EMAIL PROTECTED] > Sent: 14 June 2007 18:21 > To: CF-Talk > Subject: Re: Error converting data type varchar to int. > > Robert Rawlins - Think Blue wrote: >> >> [Macromedia][SQLServer JDBC Driver][SQLServer]Error converting data type >> varchar to int. >> >> This is a snippet of the query details thrown back in the error, it >> simple >> takes 3 parameters, the first is an integer and the second 2 are >> strings/varchar. >> >> (param 1) = [type='IN', class='java.lang.Integer', value='1', >> sqltype='cf_sql_integer'] , (param 2) = [type='IN', >> class='java.lang.String', value='07C67BA421500B791090E92F4C3D7032', >> sqltype='cf_sql_varchar'] , (param 3) = [type='IN', >> class='java.lang.String', value='D5534BDE55CAB29E3932D6CE4F211C34', >> sqltype='cf_sql_varchar'] >> >> The param java types appear to match the cf_sql_type. These types also > match >> those defined inside the stored proc and the table columns, I can't see >> what's causing this issue. > > If you don't include the stored procedure and CFML code neither can we :) > > Jochem > > > > > > ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
Re: setting xml encoding
Would this remit fall in the category of XSD? "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -Original Message- From: Dinner To: CF-Talk Sent: Sat Jun 16 18:12:33 2007 Subject: Re: setting xml encoding What would a DTD look like for something with text nodes instead of elements? Can you say X element should have X nodes? (Sorry to spin/hijack the thread a bit.) On 6/16/07, Dave Watts wrote: > > > In all my examples, I have been assuming that if data (text) > > was stored inside of a start and end tag, then there would > > not also be nested tags at that level. Obviously that would > > not always be true. > > XHTML is a great example of that, of course. It isn't immediately obvious, > though, if you're learning about XML without looking at a wide variety of > examples of specific XML languages. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281376 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Using cfinclude and udfs on application.cfm
Hi all. I am updating a legacy app that is still using an application.cfm (not a .cfc). The update simply adds a cfinclude tag for a udf library. Is there anything "illegal" (for a lack of a better term) about adding cfincludes on an application.cfm? It works, but would like to confirm whether or not the practice is not recommended or would post a risk down the line. Thanks all. Michael ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281375 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Updated Broadband Stats
For Adobe though (not to single them out it's just we have metrics), as a company everyone is a customer in all reality whether designer or developer you may well be on a fast or slow connection and with a page weight of a little under 400K it's a massive hit for slow connections - they just assume that people who visit the site are on decent connections . I am taking for granted that Adobe did the work on Geolocation to alleviate speed issues for all connection speeds.. I think "overseas" needs to be defined further though (some African nations for example practically share a modem for access from experience) , I am overseas and broadband is nigh on "the norm" for a household across the UK as it's so cheap! :-). It is kind of taking for granted, just like assuming everyone now has a mobile phone or email address.. It's no biggie I suppose as speeds increase and technology moves forward but html etc seems to be standing still so no real biggie. "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -Original Message- From: Rey Bango To: CF-Talk Sent: Sat Jun 16 18:31:17 2007 Subject: Re: Updated Broadband Stats Hi Neil, > I think though, regardless of access speeds, the target size of pages has > rarely changed over the years - 40-60K per page (not including images but > ideall it will) with a 2-3 second page load. Not necessarily. I've been doing some homework on this because I know we have clients that use dial-up, especially those that are overseas, and I want to keep the pages as small as possible. With so much client side code being added, the page bloat is tremendous and load times are increasing. I'm concerned that the attractiveness and ease of implementing desktop-like features is causing designers and developers to forget about who their target audience is. It used to be that we actually thought about that and worked hard to ensure good performance. Its appears, though, that this is becoming secondary to the "cool" factor because developers mistakenly believe that everyone is using broadband. I'm on broadband (3mbps) and you take the homepage of CNN.com, for example, and its 387k and a 13 second load time. Load that up via dialup and its conceivable to have a 20-30 second load time. CNN.com is, at least to me, an excellent example of a site that is specifically geared towards consumers but isn't doing the best job possible of optimizing their pages for those that don't have high-speed access. I recently raised a red flag on CF8's Ajax widgets and the huge page sizes that we being generated by doing the most rudimentary tasks which prompted Adobe to take a serious look into optimizing their implementations of YUI, Ext, and images. > Yes, if you know you audience are going to be using 56K modem speeds then > aim as low as that, but your sites will be pretty bare bones I am sure - > certainly no "RIA". I don't think you need to give up on RIA-type features. I just think people need to be smarter about how they do it. What I mean by this is that your choice of effects/JS/DOM libraries needs to be based on your application needs. If you know that you're going to build an application where you could limit 50% of your audience by using a large framework, then libs such as BackBase, Dojo, YUI, Ext or MochiKit may not be the best choice while jQuery, MooTools or Prototype, which are feature rich & compact, might be better suited. But if you know for fact that you're explicitly dealing with broadband users, then you have a lot more flexibility in your selection. It goes back to what I was saying that I'm concerned that developers are not thinking about their target audience when choosing how to build their apps. > Certainly large corp sites, including Adobes are aimed at higher broadband > speeds. I have a 15mb broadband line at home at it still loads dog slow! Yep, but Adobe did this because they know who the majority of their target audience is; designers and developers. I would venture to say that at least 80-90% of people that visit Adobe.com are on a broadband connection and I'm very confident Adobe is aware of that. Now, the fact that it loads slow using a broadband connection is a different issue and could be attr
Re: Updated Broadband Stats
Hi Neil, > I think though, regardless of access speeds, the target size of pages has > rarely changed over the years - 40-60K per page (not including images but > ideall it will) with a 2-3 second page load. Not necessarily. I've been doing some homework on this because I know we have clients that use dial-up, especially those that are overseas, and I want to keep the pages as small as possible. With so much client side code being added, the page bloat is tremendous and load times are increasing. I'm concerned that the attractiveness and ease of implementing desktop-like features is causing designers and developers to forget about who their target audience is. It used to be that we actually thought about that and worked hard to ensure good performance. Its appears, though, that this is becoming secondary to the "cool" factor because developers mistakenly believe that everyone is using broadband. I'm on broadband (3mbps) and you take the homepage of CNN.com, for example, and its 387k and a 13 second load time. Load that up via dialup and its conceivable to have a 20-30 second load time. CNN.com is, at least to me, an excellent example of a site that is specifically geared towards consumers but isn't doing the best job possible of optimizing their pages for those that don't have high-speed access. I recently raised a red flag on CF8's Ajax widgets and the huge page sizes that we being generated by doing the most rudimentary tasks which prompted Adobe to take a serious look into optimizing their implementations of YUI, Ext, and images. > Yes, if you know you audience are going to be using 56K modem speeds then > aim as low as that, but your sites will be pretty bare bones I am sure - > certainly no "RIA". I don't think you need to give up on RIA-type features. I just think people need to be smarter about how they do it. What I mean by this is that your choice of effects/JS/DOM libraries needs to be based on your application needs. If you know that you're going to build an application where you could limit 50% of your audience by using a large framework, then libs such as BackBase, Dojo, YUI, Ext or MochiKit may not be the best choice while jQuery, MooTools or Prototype, which are feature rich & compact, might be better suited. But if you know for fact that you're explicitly dealing with broadband users, then you have a lot more flexibility in your selection. It goes back to what I was saying that I'm concerned that developers are not thinking about their target audience when choosing how to build their apps. > Certainly large corp sites, including Adobes are aimed at higher broadband > speeds. I have a 15mb broadband line at home at it still loads dog slow! Yep, but Adobe did this because they know who the majority of their target audience is; designers and developers. I would venture to say that at least 80-90% of people that visit Adobe.com are on a broadband connection and I'm very confident Adobe is aware of that. Now, the fact that it loads slow using a broadband connection is a different issue and could be attributed to your geographic location. I hit their page and it loaded 358k in 4.45 seconds. Rey.. ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281373 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: setting xml encoding
What would a DTD look like for something with text nodes instead of elements? Can you say X element should have X nodes? (Sorry to spin/hijack the thread a bit.) On 6/16/07, Dave Watts wrote: > > > In all my examples, I have been assuming that if data (text) > > was stored inside of a start and end tag, then there would > > not also be nested tags at that level. Obviously that would > > not always be true. > > XHTML is a great example of that, of course. It isn't immediately obvious, > though, if you're learning about XML without looking at a wide variety of > examples of specific XML languages. ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281372 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Error converting data type varchar to int.
This error can sometimes be raised when you are passing in a value to a column of a certain type but the column contains most if not all values of another - I.e. VARCHAR column but all the values in it are technically ints. Have your tried to convert/cast the input values server side as well? Also, it is advisable to not create a user SP with a prefix of sp_, these should be reserved for system procs as per info in BOL. "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -Original Message- From: Robert Rawlins - Think Blue To: CF-Talk Sent: Fri Jun 15 10:56:00 2007 Subject: RE: Error converting data type varchar to int. Right you are Jochem! Here is the stored proc code: CREATE PROCEDURE Sp_Credential_Create @User_IDINTEGER, @Username VARCHAR(128), @Password VARCHAR(128) AS SET NOCOUNT ON INSERT INTO Credential (User_ID, Username, Password) VALUES (@User_ID, @Username, @Password) And here is the function that fires the stored proc. And finally the code that triggers the function. Hope that all makes sense to you, it would be great to figure out what's causing this. Thanks, Rob -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: 14 June 2007 18:21 To: CF-Talk Subject: Re: Error converting data type varchar to int. Robert Rawlins - Think Blue wrote: > > [Macromedia][SQLServer JDBC Driver][SQLServer]Error converting data type > varchar to int. > > This is a snippet of the query details thrown back in the error, it simple > takes 3 parameters, the first is an integer and the second 2 are > strings/varchar. > > (param 1) = [type='IN', class='java.lang.Integer', value='1', > sqltype='cf_sql_integer'] , (param 2) = [type='IN', > class='java.lang.String', value='07C67BA421500B791090E92F4C3D7032', > sqltype='cf_sql_varchar'] , (param 3) = [type='IN', > class='java.lang.String', value='D5534BDE55CAB29E3932D6CE4F211C34', > sqltype='cf_sql_varchar'] > > The param java types appear to match the cf_sql_type. These types also match > those defined inside the stored proc and the table columns, I can't see > what's causing this issue. If you don't include the stored procedure and CFML code neither can we :) Jochem ~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281371 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: setting xml encoding
> In all my examples, I have been assuming that if data (text) > was stored inside of a start and end tag, then there would > not also be nested tags at that level. Obviously that would > not always be true. XHTML is a great example of that, of course. It isn't immediately obvious, though, if you're learning about XML without looking at a wide variety of examples of specific XML languages. > My introduction to XML was through ColdFusion and in CF you > do not access the text of an element the same way you would a > child element. No, CF makes things very easy - too easy, sometimes! I would recommend learning about XML DOM parsing, as it better reflects how the rest of the world works with XML. Of course, when you don't need that level of complexity, you will appreciate CF's oversimplification. > Truthfully, I'm not sure how to iterate over child elements > excluding text nodes in JavaScript. > I could use getElementsByTagName() but only helps if I know > the names of the tags. What would be the proper way to loop > over just the child tags?? You can loop over all of them, and within your loop check the node type and conditionally exclude the text nodes. You could also return a nodeset using an XPath expression, which would let you get just the nodes you want. You could also resolve the problem before you get to the parser, by generating XML with no extraneous whitespace - that's the approach I'd prefer, since you actually want XML without whitespace. Don't worry too much about readability; if you view your XML with an XML-aware viewer, like a browser, it'll apply indentation for you. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281370 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using sessions with Flash Remoting
> Aha! That might be the ticket! Is this something built into > CF, or are you talking more along the lines of something like > a cron job? CF has a scheduler, but you can use your OS scheduler (cron, at, whatever) as well. Historically, there have been problems with CF's scheduler, so I got into the habit of using the OS scheduler instead, but I suspect those problems no longer exist. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281369 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Error converting data type varchar to int.
Hi James, Thanks for the suggestion mate, I've tried changing that but still get the same error. :-( Thanks, Rob -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: 16 June 2007 13:44 To: CF-Talk Subject: Re: Error converting data type varchar to int. In the cfstoredproc call, for your int type you still have a maxlength defined, which is only useful for strings: Perhaps it's messing up the assignment to the int - try removing it. On 6/16/07, Robert Rawlins - Think Blue <[EMAIL PROTECTED]> wrote: > Thanks Dean, > > This is confusing the hell out of me. I've checked all the data types in both > the stored proc and the database columns, they are as they should be, into > and two varchars, I even tried changing the column names to make sure they > weren't reserved words or something, but still the same issue. > > What is weird, that if I fire the proc with those values from SSMS like this: > > EXEC Sp_Credential_Create 1, '07C67BA421500B791090E92F4C3D7032', > 'D5534BDE55CAB29E3932D6CE4F211C34' > > Then it works just fine, so I'm guessing the database side of things is just > fine, this must be something in the cf that's causing the problem, it really > is most wierd. > > Thanks for any further ideas you guys have on this. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281368 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Error converting data type varchar to int.
In the cfstoredproc call, for your int type you still have a maxlength defined, which is only useful for strings: Perhaps it's messing up the assignment to the int - try removing it. On 6/16/07, Robert Rawlins - Think Blue <[EMAIL PROTECTED]> wrote: > Thanks Dean, > > This is confusing the hell out of me. I've checked all the data types in both > the stored proc and the database columns, they are as they should be, into > and two varchars, I even tried changing the column names to make sure they > weren't reserved words or something, but still the same issue. > > What is weird, that if I fire the proc with those values from SSMS like this: > > EXEC Sp_Credential_Create 1, '07C67BA421500B791090E92F4C3D7032', > 'D5534BDE55CAB29E3932D6CE4F211C34' > > Then it works just fine, so I'm guessing the database side of things is just > fine, this must be something in the cf that's causing the problem, it really > is most wierd. > > Thanks for any further ideas you guys have on this. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281367 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: newbie FB5? or newbie FB6
I stopped using fusebox once FB3 was implement. It just got a little to complex for me. However I stuck with the basic concepts of fuses and circuites. My circuit files are still basically one big cfswitch / cfcase tag. I am considering moveing to FB5. It seems attractive becuase the Fusebox Framework appears to be blackbox and it seems that I don't need to ticker with any non-value added details. I am also attracted to the concept of converting my cfswitch structure to a nice circuit.xml file. Furthermore the dot notation for the fuseaction request is very appealing; now my "index.cfm?action= browseFirm&perform=showService List" can be replaced with "index.cfm?fuseacti on=browseFirm. showServiceList" Cool. Basically I like alot about th FB5 format but now there's talk about FB6 or FBMX. Should I wait? ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281366 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Error converting data type varchar to int.
Thanks Dean, This is confusing the hell out of me. I've checked all the data types in both the stored proc and the database columns, they are as they should be, into and two varchars, I even tried changing the column names to make sure they werenât reserved words or something, but still the same issue. What is weird, that if I fire the proc with those values from SSMS like this: EXEC Sp_Credential_Create 1, '07C67BA421500B791090E92F4C3D7032', 'D5534BDE55CAB29E3932D6CE4F211C34' Then it works just fine, so I'm guessing the database side of things is just fine, this must be something in the cf that's causing the problem, it really is most wierd. Thanks for any further ideas you guys have on this. Rob -Original Message- From: Dean Lawrence [mailto:[EMAIL PROTECTED] Sent: 15 June 2007 22:41 To: CF-Talk Subject: Re: Error converting data type varchar to int. Rob, Hmmm, it certainly appears to be passing in an int and 2 strings. What is killing me is that I know I had run up against this error in the past, and for the life of me, I cannot remember exactly what the problem was. You may want to double check the field names and types that are defined in SQL Server to make sure that you are not trying to insert param2 and param3 into a field that has been defined as an int. Dean -- __ Dean Lawrence, CIO/Partner Internet Data Technology 888.GET.IDT1 ext. 701 * fax: 888.438.4381 http://www.idatatech.com/ Corporate Internet Development and Marketing Specialists ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281365 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
