RE: Translating MSSQL Scripts into MySQL Scripts
Thanks for the lead and tips, Mary Jo! Rick > -Original Message- > From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED] > Sent: Monday, February 04, 2008 10:56 PM > To: CF-Talk > Subject: Re: Translating MSSQL Scripts into MySQL Scripts > > >I'm looking for something that will translate/run the scripts > >for MySQL so I can set up the tables. Once I've done that I can > >import the data from the text files. > > You probably will want to check out the tools at dbconvert.com. You basically > can buy a tool > for whatever conversion you need. I routinely use their Access-to-MySQL tools > to do migrations > for customers. Not sure they will be able to do direct conversion from SQL > scripts to MySQL > scripts...but they can definitely take a MSSQL database and convert it to a > MySQL script, and > I find their tools are generally more accurate than the migration tools > provided by mysql.com > (which always seem to miss some crucial part of the schema.) Whether the > registration cost is > worth it or not for a one-time conversion, hard to say. I've found a need for > it over and over > though. Almost every other tools I've used has failed me in some way, either > missing items, > not getting case right (certainly important with MySQL many times), not > creating databases in > the proper order to do the necessary foreign keys, etc. I always seem to come > back to these. > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298174 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Excel 2007
I tried with the schema also , but still showing that warning msg :(
> -com:office:office"" xmlns:x=""urn:schemas-microsoft-com:office:excel""
> xmlns=""http://www.w3.org/TR/REC-html40"";>">
> @page {margin:.25in .25in .25in
> .25in; mso-page-orientation:landscape; mso-header-margin:.25in;
> mso-footer-margin:.25in; mso-horizontal-page-align:center;}">
> 9]> wrote:
>
> On Feb 4, 2008 10:56 PM, FROEHLING, ROBERT (ATTSI) <[EMAIL PROTECTED]> wrote:
>
> > Try adding the following when creating your HTML output:
> >
> > > xmlns:x="urn:schemas-microsoft-com:office:excel"
> > xmlns="http://www.w3.org/TR/REC-html40";>
> >
> >
> >
> >
> >
> >
> >
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298173
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Excel 2007
I tried with the schema also , but still showing that warning msg :(
http://www.w3.org/TR/REC-html40"";>">
@page {margin:.25in .25in .25in
..25in; mso-page-orientation:landscape; mso-header-margin:.25in;
mso-footer-margin:.25in; mso-horizontal-page-align:center;}">
wrote:
> Try adding the following when creating your HTML output:
>
> xmlns:x="urn:schemas-microsoft-com:office:excel"
> xmlns="http://www.w3.org/TR/REC-html40";>
>
>
>
>
>
>
> -Original Message-
> From: Timmy Tom [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 04, 2008 7:58 AM
> To: CF-Talk
> Subject: Re: Excel 2007
>
>
>
>
>
>
>
>
>
>
>
>
>#Emp_ID#
>#FirstName#
>#LastName#
>
>
>
>
>
> when we open the excel file in a machine having office 2003 or earlier
> no
> problem , but when we open that file from a machine having office 2007
> it
> shows this warning msg.
>
> On Feb 4, 2008 7:21 PM, Tom Chiverton <[EMAIL PROTECTED]>
> wrote:
>
> > On Monday 04 Feb 2008, Timmy K Tom wrote:
> > > I created Excel file using coldfusion,
> >
> > How ?
> >
> > --
> > Tom Chiverton
> > Helping to confidentially accelerate visionary materials
> > on: http://thefalken.livejournal.com
> >
> >
> >
> > This email is sent for and on behalf of Halliwells LLP.
> >
> > Halliwells LLP is a limited liability partnership registered in
> England
> > and Wales under registered number OC307980 whose registered office
> address
> > is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3
> 3EB.
> > A list of members is available for inspection at the registered
> office. Any
> > reference to a partner in relation to Halliwells LLP means a member of
> > Halliwells LLP. Regulated by The Solicitors Regulation Authority.
> >
> > CONFIDENTIALITY
> >
> > This email is intended only for the use of the addressee named above
> and
> > may be confidential or legally privileged. If you are not the
> addressee you
> > must not read it and must not use any information contained in nor
> copy it
> > nor inform any person other than Halliwells LLP or the addressee of
> its
> > existence or contents. If you have received this email in error
> please
> > delete it and notify Halliwells LLP IT Department on 0870 365 2500.
> >
> > For more information about Halliwells LLP visit www.halliwells.com.
> >
> >
>
>
>
>
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298172
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Translating MSSQL Scripts into MySQL Scripts
>I'm looking for something that will translate/run the scripts >for MySQL so I can set up the tables. Once I've done that I can >import the data from the text files. You probably will want to check out the tools at dbconvert.com. You basically can buy a tool for whatever conversion you need. I routinely use their Access-to-MySQL tools to do migrations for customers. Not sure they will be able to do direct conversion from SQL scripts to MySQL scripts...but they can definitely take a MSSQL database and convert it to a MySQL script, and I find their tools are generally more accurate than the migration tools provided by mysql.com (which always seem to miss some crucial part of the schema.) Whether the registration cost is worth it or not for a one-time conversion, hard to say. I've found a need for it over and over though. Almost every other tools I've used has failed me in some way, either missing items, not getting case right (certainly important with MySQL many times), not creating databases in the proper order to do the necessary foreign keys, etc. I always seem to come back to these. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298171 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: File upload
Read the original post. I don't need it. Ryan Stille wrote: > I don't know why Bruce needs it, but I would love to be able to do it > because it adds usability. > > When there are multiple file upload boxes, its easy to get confused as > to what files you have selected already. The file input box is usually > only about 20 characters wide (and not adjustable in most browsers). So > I end up seeing "C:\Documents and Sett" in all 10 boxes. I have used > some uploaders where after you select the file, the file name appears > next to the file select control. Very helpful. > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298170 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: File upload
That makes sense. This multi file uploader does that: http://www.adobe.com/devnet/coldfusion/articles/multifile_upload.html On Feb 5, 2008 12:02 PM, Ryan Stille <[EMAIL PROTECTED]> wrote: > I don't know why Bruce needs it, but I would love to be able to do it > because it adds usability. > > When there are multiple file upload boxes, its easy to get confused as > to what files you have selected already. The file input box is usually > only about 20 characters wide (and not adjustable in most browsers). So > I end up seeing "C:\Documents and Sett" in all 10 boxes. I have used > some uploaders where after you select the file, the file name appears > next to the file select control. Very helpful. > > -Ryan > > James Holmes wrote: > > Out of curiosity, can you say why you need the filename before the > > file is uploaded to the server? > > > > On Feb 5, 2008 5:47 AM, Rick Sanders <[EMAIL PROTECTED]> wrote: > > > >> Hello Bruce, > >> > >> Thanks for your reply. However, I'd like to grab the file name before the > >> file is actually uploaded to the server. > >> > > > > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298169 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: File upload
I don't know why Bruce needs it, but I would love to be able to do it because it adds usability. When there are multiple file upload boxes, its easy to get confused as to what files you have selected already. The file input box is usually only about 20 characters wide (and not adjustable in most browsers). So I end up seeing "C:\Documents and Sett" in all 10 boxes. I have used some uploaders where after you select the file, the file name appears next to the file select control. Very helpful. -Ryan James Holmes wrote: > Out of curiosity, can you say why you need the filename before the > file is uploaded to the server? > > On Feb 5, 2008 5:47 AM, Rick Sanders <[EMAIL PROTECTED]> wrote: > >> Hello Bruce, >> >> Thanks for your reply. However, I'd like to grab the file name before the >> file is actually uploaded to the server. >> > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298168 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: File upload
Out of curiosity, can you say why you need the filename before the file is uploaded to the server? On Feb 5, 2008 5:47 AM, Rick Sanders <[EMAIL PROTECTED]> wrote: > Hello Bruce, > > Thanks for your reply. However, I'd like to grab the file name before the > file is actually uploaded to the server. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298167 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Upload progress bar
> FWIW, the flash (flex) component I linked to offers a genuine progress > bar, as it's all handled by the flash. It uses CFFILE on the back end > so coding for it is simple. Oh I somehow missed the fact that this one was directly from Adobe. Thanks for the heads up on that one. -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 503.236.3691 http://onTap.riaforge.org/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298166 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What happened to objectbreeze.com
I let the domain expire since I have not been doing any further updates (got really busy on a full time contract). Thanks, Nic Joeri B wrote: > It appears offline... Why?!?! I loved it so much :) > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298165 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT: Translating MSSQL Scripts into MySQL Scripts
Hi, Chris...and thanks for the suggestion. However, the toolkit is apparently for migrating data from one database to another and I don't have direct access to the data vendor's database. I only have the MSSQL scripts for creating a database of the tables they use and tab delimited text files of the data. I'm looking for something that will translate/run the scripts for MySQL so I can set up the tables. Once I've done that I can import the data from the text files. Rick > -Original Message- > From: Chris Montgomery [mailto:[EMAIL PROTECTED] > Sent: Monday, February 04, 2008 6:28 PM > To: CF-Talk > Subject: Re: OT: Translating MSSQL Scripts into MySQL Scripts > > Rick Faircloth said the following on 2/4/2008 12:53 PM: > > Can anyone recommend a program that will translate > > MSSQL scripts into MySQL scripts? I found some on > > Google. couldn't find a way to do it on mysql.com. > > > > Before I try a program to do this, I thought I'd > > get some recommendations from those of you with > > experience at this. > > > > I can create the database/tables manually, but > > I sure would like to save some time! > > Rick, > > Have you tried using the MySQL Migration Toolkit from MySQL's site? > (http://www.mysql.com/products/tools/migration-toolkit/) > I have used it to convert a couple of MS Access databases to MySQL but > haven't tried it yet on MS SQL Server. The tutorial is at > http://www.mysql.com/products/tools/migration-toolkit/tutorials/migrate-sql-server.html > > -- > Best regards, > > Chris Montgomery ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298164 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT: Translating MSSQL Scripts into MySQL Scripts
That sounds like what I need! Thanks, Gerald! Rick > -Original Message- > From: Gerald Guido [mailto:[EMAIL PROTECTED] > Sent: Monday, February 04, 2008 5:48 PM > To: CF-Talk > Subject: Re: OT: Translating MSSQL Scripts into MySQL Scripts > > MSSQL Express might do it: > http://www.microsoft.com/sql/editions/express/default.mspx > > In not MSDE will. > SQL Server 2000 Desktop Engine > http://www.microsoft.com/sql/prodinfo/previousversions/msde/downloads-default.mspx > > Both are free > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298163 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Upload progress bar
FWIW, the flash (flex) component I linked to offers a genuine progress bar, as it's all handled by the flash. It uses CFFILE on the back end so coding for it is simple. http://www.adobe.com/devnet/coldfusion/articles/multifile_upload.html On Feb 5, 2008 9:27 AM, s. isaac dealey <[EMAIL PROTECTED]> wrote: > > i went ahead and asked this question on the knowledge base of the > > company who developed this component: > > > > this was their answer: > > > > The progress bar reflects real state of upload (the vault opens an > > additional connection to receive info from server about upload > > progress) > > Hmm... well... not sure what they mean by that necessarily... but at > least for me, their tool went straight from 0% at the beginning to 100% > many seconds later, with nothing in between. It did reflect once the > file had finished uploading, but nothing in-between. So this answer > sounds like either they designed it to do something I didn't see when I > used it (Firefox 2 -- not sure but I think I tried it with IE7 also), or > that they're just saying it reflects 100% when it finishes. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298162 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Upload progress bar
> i went ahead and asked this question on the knowledge base of the > company who developed this component: > > this was their answer: > > The progress bar reflects real state of upload (the vault opens an > additional connection to receive info from server about upload > progress) Hmm... well... not sure what they mean by that necessarily... but at least for me, their tool went straight from 0% at the beginning to 100% many seconds later, with nothing in between. It did reflect once the file had finished uploading, but nothing in-between. So this answer sounds like either they designed it to do something I didn't see when I used it (Firefox 2 -- not sure but I think I tried it with IE7 also), or that they're just saying it reflects 100% when it finishes. -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 503.236.3691 http://onTap.riaforge.org/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298161 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Programmatically determine an application's size in memory?
I've wrestled with the same question before. Excepting the CF8 memory monitor which James mentioned I don't think there is an easy answer. The next closest thing would be to restart your server and look at its memory usage with SeeFusion, Fusion Reactor or the code below. #round(usedMemory)# MB used. Then start your application and see how much memory is used then. ~Brad -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Monday, February 04, 2008 4:57 PM To: CF-Talk Subject: Programmatically determine an application's size in memory? Does anyone know of a way to determine how much memory a single application is taking up? Say I know the app name, is there a method or tag that can tell me how much memory THAT application is using? Either pure CF, or Java would be fine. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298160 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
pls ignore- testing new HOF email
Please ignore. Just testing my new email to the CFlist. Mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298159 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Programmatically determine an application's size in memory?
Turn on the CF8 memory monitor? On Feb 5, 2008 7:57 AM, Andy Matthews <[EMAIL PROTECTED]> wrote: > Does anyone know of a way to determine how much memory a single application > is taking up? Say I know the app name, is there a method or tag that can tell > me how much memory THAT application is using? Either pure CF, or Java would > be fine. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298158 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: Translating MSSQL Scripts into MySQL Scripts
Rick Faircloth said the following on 2/4/2008 12:53 PM: > Can anyone recommend a program that will translate > MSSQL scripts into MySQL scripts? I found some on > Google. couldn't find a way to do it on mysql.com. > > Before I try a program to do this, I thought I'd > get some recommendations from those of you with > experience at this. > > I can create the database/tables manually, but > I sure would like to save some time! Rick, Have you tried using the MySQL Migration Toolkit from MySQL's site? (http://www.mysql.com/products/tools/migration-toolkit/) I have used it to convert a couple of MS Access databases to MySQL but haven't tried it yet on MS SQL Server. The tutorial is at http://www.mysql.com/products/tools/migration-toolkit/tutorials/migrate-sql-server.html -- Best regards, Chris Montgomery ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298157 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: File upload - my new posts aren't coming through
Not at all. I'm just wondering why the posts are not coming in/creating new threads. CCing me on new posts and/or doing the same while posting through the test list will help me trace the problem down. On Feb 4, 2008 6:04 PM, Andy Matthews <[EMAIL PROTECTED]> wrote: > Michael... > > I'm using Outlook 2003, the same client I've been using for the last year. > I've created many original threads using this same client. > > Are you actually suggesting that we should all use the web interface to > make > new posts? > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298156 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: File upload - my new posts aren't coming through
I've had problems with occasional messages not coming through for a few weeks now, perhaps months. I always use plain text when posting to this list. -Ryan Bruce Sorge wrote: > I use Thunderbird and I make sure to select Text Only when sending to > any of your lists 99% of what I originally posts goes through fine. > > Bruce > > Michael Dinowitz wrote: > >> The issue is probably due to you posting from a client that has a rich text >> post set as default. Rich text posts are usually base64 encoded which is >> rejected by the lists. Some rich text posts are html only with no text only >> alternate which is also rejected. Replying always works because the reply is >> in the same format as the original post which will always be sent to you as >> plain text. >> What client are you using to post? >> >> BTW, posting from the archives always works. :) >> >> >> > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298155 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: File upload - my new posts aren't coming through
Next time you post a new thread, please CC me. If you would like to test now, you can go to test list at http://www.houseoffusion.com/groups/test/ subscribe there and post there. I prefer tests to go to that list rather than to this one. Thanks On Feb 4, 2008 5:34 PM, Bruce Sorge <[EMAIL PROTECTED]> wrote: > I use Thunderbird and I make sure to select Text Only when sending to > any of your lists 99% of what I originally posts goes through fine. > > Bruce > > Michael Dinowitz wrote: > > The issue is probably due to you posting from a client that has a rich > text > > post set as default. Rich text posts are usually base64 encoded which is > > rejected by the lists. Some rich text posts are html only with no text > only > > alternate which is also rejected. Replying always works because the > reply is > > in the same format as the original post which will always be sent to you > as > > plain text. > > What client are you using to post? > > > > BTW, posting from the archives always works. :) > > > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298154 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: File upload - my new posts aren't coming through
Michael... I'm using Outlook 2003, the same client I've been using for the last year. I've created many original threads using this same client. Are you actually suggesting that we should all use the web interface to make new posts? -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Monday, February 04, 2008 4:32 PM To: CF-Talk Subject: Re: File upload - my new posts aren't coming through The issue is probably due to you posting from a client that has a rich text post set as default. Rich text posts are usually base64 encoded which is rejected by the lists. Some rich text posts are html only with no text only alternate which is also rejected. Replying always works because the reply is in the same format as the original post which will always be sent to you as plain text. What client are you using to post? BTW, posting from the archives always works. :) On Feb 4, 2008 3:57 PM, Andy Matthews <[EMAIL PROTECTED]> wrote: > Is anyone else having an issue with making new threads? I've tried to > post two new threads today (once was sent twice) and it's not going through. > But > then my reply to the File Upload thread came through just fine. > > > andy > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298150 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Anyone using BlazeDS?
I'm going to be writing my first AIR app, a sort of notification program to inform employees of system messages. The ideal would be to push messages anytime they're available, as the alternative is to have X number of machines pinging the server at Y interval. Has anyone used Blaze, and have some wisdom to share? The potential number of client machines running this app is between 60 and 100. How would Blaze handle this? Does/should it run on the same machine as the CF server? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298152 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Programmatically determine an application's size in memory?
Does anyone know of a way to determine how much memory a single application is taking up? Say I know the app name, is there a method or tag that can tell me how much memory THAT application is using? Either pure CF, or Java would be fine. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298153 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: File upload
Hi Ian, I suspected as so. I don't know of any development platform that can grab the file name before going to the server. I have tried some javascript controls, but it doesn't work the same for all clients, and of course if someone has spyware or browser problems it'll crash their browser. I don't like to depend on the client for anything when it comes to web development. Thanks, Rick You can't with ColdFusion. The browser does not tell the server anything about the file before the upload occurs. It just bundles the entire file up and sends it with the request to the server generated when the user selects the 'submit' control. Then the web server takes the file from the request and writes it to a temp file location. It then passes the request to ColdFusion telling it where this temp location is. ColdFusion then does what you tell it to do with the file. To do anything before this must be done on the Client usually with JavaScript. But it is not so easy to access information about any user file selections with JavaScript for security reasons. The one technique I've seen is to mirror the path string from the file control to a hidden control. One then can do some JS validation with the hidden control value. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298151 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: File upload
Hey Bruce, No worries, I may not have explained it all too well either. Thanks for the friendly name idea. I was hoping there was another way, but I've messed around with this long enough so that's how it's going to be done! Thanks, Rick -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: February-04-08 5:13 PM To: CF-Talk Subject: Re: File upload Actually it was Robert who posted ServerFile post. I misunderstood your post and thought that you wanted the file name that you are sending. My bad. Anyway, I don't think this is possible with CF, but CF can rename the file on it's own if there is a conflict. Just use the makeunique attribut. Typically what I do is when I have a user upload a file, I have them select the file they want to upload, and then I have another field for a friendly name. So if the file is something like 2008budget.xls, I would have them enter something like 2008 Budget. I enter the serverrfile name into the table along with the friendly name. Then when I query the table I show the friendly name to the user and then use the serverfile name for the actual file name. Bruce Rick Sanders wrote: > Hey Bruce, > > Thanks again. I do want to rename the file, so how would I go about this > with serverfile? > > Thanks to everyone else who replied as well. > > Rick > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298149 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: Translating MSSQL Scripts into MySQL Scripts
MSSQL Express might do it: http://www.microsoft.com/sql/editions/express/default.mspx In not MSDE will. SQL Server 2000 Desktop Engine http://www.microsoft.com/sql/prodinfo/previousversions/msde/downloads-default.mspx Both are free On Feb 4, 2008 3:48 PM, Rick Faircloth <[EMAIL PROTECTED]> wrote: > I can get the data from MSSQL with Navicat. > What I want is something to run or translate the > MSSQL table creation scripts the data vendor sent. > > Is there some sort of free or inexpensive MSSQL-type > server that will use the MSSQL 7 scripts that I can use > as a go-between? I don't want to invest much, because > this is a one-time operation. I can do it manually. > > Rick > > > -Original Message- > > From: Todd Rafferty [mailto:[EMAIL PROTECTED] > > Sent: Monday, February 04, 2008 3:16 PM > > To: CF-Talk > > Subject: Re: OT: Translating MSSQL Scripts into MySQL Scripts > > > > You won't be able to use "scripts" as Gerald mentions. This assumes > you've > > got SQL Server running somewhere and you setup an ODBC connection to it > and > > the wizard sucks all that information across and converts it > appropriately. > > Does a great job of it. So, I guess this isn't what you're after, sorry > > about the wild goose chase. > > > > On Feb 4, 2008 3:03 PM, Rick Faircloth <[EMAIL PROTECTED]> wrote: > > > > > I saw that, but I wasn't totally sure that meant it > > > would translate or be able to use MSSQL scripts. > > > > > > Thanks, > > > Rick > > > > > > > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298148 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: New FedEx Webservice
What are the problems your seeing? I've just spent the last 2-3 weeks working through the entire Google Checkout API and there were a number of 'issues' that were not covered in the docs. On Feb 4, 2008 3:07 PM, Jeremy Keith <[EMAIL PROTECTED]> wrote: > They went live with their WebService over the weekend, anyone gotten this > to work with CF(8) yet? > > I'm trying to convert the PHP5 example they have up there without much > luck. > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298147 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Problem with New Threads
I would think that'd keep it as part of the initial thread in the archives. Have you tried creating the thread from the website rather than an email? ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Robert Harrison [mailto:[EMAIL PROTECTED] Sent: Monday, February 04, 2008 4:12 PM To: CF-Talk Subject: Problem with New Threads > Is anyone else having an issue with making new threads? I've been having that issue for a long time now. Just reply to a current thread, strip the email content and change the subject and start the new thread. That will work. Not right, but it works. Robert B. Harrison Director of Interactive services Austin & Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be &. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298146 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: File upload - my new posts aren't coming through
I use Thunderbird and I make sure to select Text Only when sending to any of your lists 99% of what I originally posts goes through fine. Bruce Michael Dinowitz wrote: > The issue is probably due to you posting from a client that has a rich text > post set as default. Rich text posts are usually base64 encoded which is > rejected by the lists. Some rich text posts are html only with no text only > alternate which is also rejected. Replying always works because the reply is > in the same format as the original post which will always be sent to you as > plain text. > What client are you using to post? > > BTW, posting from the archives always works. :) > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298145 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Translating MSSQL Scripts into MySQL Scripts
>I have MSSQL SQL scripts provided by a data vendor >that create tables, etc. in MSSQL7. I use MySQL 5. >I want something that will run the scripts or translate >the scripts so that MySQL 5 can understand them. dave just did the same thing and he said he used this: http://www.sqlscriptbuilder.com/ Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298144 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: File upload - my new posts aren't coming through
The issue is probably due to you posting from a client that has a rich text post set as default. Rich text posts are usually base64 encoded which is rejected by the lists. Some rich text posts are html only with no text only alternate which is also rejected. Replying always works because the reply is in the same format as the original post which will always be sent to you as plain text. What client are you using to post? BTW, posting from the archives always works. :) On Feb 4, 2008 3:57 PM, Andy Matthews <[EMAIL PROTECTED]> wrote: > Is anyone else having an issue with making new threads? I've tried to post > two new threads today (once was sent twice) and it's not going through. > But > then my reply to the File Upload thread came through just fine. > > > andy > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298143 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: New FedEx Webservice
Do you have a link to the service announcement? -- William E. Seiter Have you ever read a book that changed your life? Go to: www.winninginthemargins.com Enter passkey: goldengrove Web Developer / ColdFusion Programmer http://William.Seiter.com -Original Message- From: Jeremy Keith [mailto:[EMAIL PROTECTED] Sent: Monday, February 04, 2008 12:07 PM To: CF-Talk Subject: New FedEx Webservice They went live with their WebService over the weekend, anyone gotten this to work with CF(8) yet? I'm trying to convert the PHP5 example they have up there without much luck. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298142 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Access JDBC driver and Rnd() Function
We recently moved an application the uses an Access database from CF5 to CF8. To display a set of records in random order we had been using a query like: SELECT , Rnd(id) AS randcolumn FROM ... ORDER BY randcolumn The values in randcolumn are floats in the range of 0 to 1. This worked well in CF5, but in CF8 it appears to consistently generate the same sets of numbers for randcolumn. What's really odd is that about 90+% of the time it will return the exact same set of numbers (and so the same sort order), then the remaining 10% of the time there will be a couple other variations. Any ideas about what's going on and whether there's a simple workaround? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298141 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Problem with New Threads
Only drawback is that it won't thread correctly because it's technically part of the original message stream. I've emailed Michael about it, but haven't heard back yet. This is the first time it's happened to me. -Original Message- From: Robert Harrison [mailto:[EMAIL PROTECTED] Sent: Monday, February 04, 2008 3:12 PM To: CF-Talk Subject: Problem with New Threads > Is anyone else having an issue with making new threads? I've been having that issue for a long time now. Just reply to a current thread, strip the email content and change the subject and start the new thread. That will work. Not right, but it works. Robert B. Harrison Director of Interactive services Austin & Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be &. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298140 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: File upload
Actually it was Robert who posted ServerFile post. I misunderstood your post and thought that you wanted the file name that you are sending. My bad. Anyway, I don't think this is possible with CF, but CF can rename the file on it's own if there is a conflict. Just use the makeunique attribut. Typically what I do is when I have a user upload a file, I have them select the file they want to upload, and then I have another field for a friendly name. So if the file is something like 2008budget.xls, I would have them enter something like 2008 Budget. I enter the serverrfile name into the table along with the friendly name. Then when I query the table I show the friendly name to the user and then use the serverfile name for the actual file name. Bruce Rick Sanders wrote: > Hey Bruce, > > Thanks again. I do want to rename the file, so how would I go about this > with serverfile? > > Thanks to everyone else who replied as well. > > Rick > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298139 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Problem with New Threads
> Is anyone else having an issue with making new threads? I've been having that issue for a long time now. Just reply to a current thread, strip the email content and change the subject and start the new thread. That will work. Not right, but it works. Robert B. Harrison Director of Interactive services Austin & Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be &. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298138 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: File upload
Rick Sanders wrote: > Hello Bruce, > > Thanks for your reply. However, I'd like to grab the file name before the > file is actually uploaded to the server. > > Kind regards, > > Rick You can't with ColdFusion. The browser does not tell the server anything about the file before the upload occurs. It just bundles the entire file up and sends it with the request to the server generated when the user selects the 'submit' control. Then the web server takes the file from the request and writes it to a temp file location. It then passes the request to ColdFusion telling it where this temp location is. ColdFusion then does what you tell it to do with the file. To do anything before this must be done on the Client usually with JavaScript. But it is not so easy to access information about any user file selections with JavaScript for security reasons. The one technique I've seen is to mirror the path string from the file control to a hidden control. One then can do some JS validation with the hidden control value. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298137 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: File upload - my new posts aren't coming through
I have that problem once in a while. Not sure what is going on with this though. weird. Bruce Andy Matthews wrote: > Is anyone else having an issue with making new threads? I've tried to post > two new threads today (once was sent twice) and it's not going through. But > then my reply to the File Upload thread came through just fine. > > > andy > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298136 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: File upload - my new posts aren't coming through
Is anyone else having an issue with making new threads? I've tried to post two new threads today (once was sent twice) and it's not going through. But then my reply to the File Upload thread came through just fine. andy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298134 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: File upload
Hey Bruce, Thanks again. I do want to rename the file, so how would I go about this with serverfile? Thanks to everyone else who replied as well. Rick -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: February-04-08 4:47 PM To: CF-Talk Subject: Re: File upload DOH!. (slaps head). Heh. On Feb 4, 2008 12:44 PM, Robert Harrison <[EMAIL PROTECTED]> wrote: > ClientFile is the name of the original file uploaded by the client. > ServerFile is the name of the file after it's uploaded to the server. If > you're doing a rename you may need Serverfile. > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298135 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Translating MSSQL Scripts into MySQL Scripts
Go go fingers! Good luck! On Feb 4, 2008 3:48 PM, Rick Faircloth <[EMAIL PROTECTED]> wrote: > I can get the data from MSSQL with Navicat. > What I want is something to run or translate the > MSSQL table creation scripts the data vendor sent. > > Is there some sort of free or inexpensive MSSQL-type > server that will use the MSSQL 7 scripts that I can use > as a go-between? I don't want to invest much, because > this is a one-time operation. I can do it manually. > > Rick > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298133 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT: Translating MSSQL Scripts into MySQL Scripts
I can get the data from MSSQL with Navicat. What I want is something to run or translate the MSSQL table creation scripts the data vendor sent. Is there some sort of free or inexpensive MSSQL-type server that will use the MSSQL 7 scripts that I can use as a go-between? I don't want to invest much, because this is a one-time operation. I can do it manually. Rick > -Original Message- > From: Todd Rafferty [mailto:[EMAIL PROTECTED] > Sent: Monday, February 04, 2008 3:16 PM > To: CF-Talk > Subject: Re: OT: Translating MSSQL Scripts into MySQL Scripts > > You won't be able to use "scripts" as Gerald mentions. This assumes you've > got SQL Server running somewhere and you setup an ODBC connection to it and > the wizard sucks all that information across and converts it appropriately. > Does a great job of it. So, I guess this isn't what you're after, sorry > about the wild goose chase. > > On Feb 4, 2008 3:03 PM, Rick Faircloth <[EMAIL PROTECTED]> wrote: > > > I saw that, but I wasn't totally sure that meant it > > would translate or be able to use MSSQL scripts. > > > > Thanks, > > Rick > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298132 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: File upload
Hello Bruce, Thanks for your reply. However, I'd like to grab the file name before the file is actually uploaded to the server. Kind regards, Rick -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: February-04-08 4:38 PM To: CF-Talk Subject: Re: File upload ClientFile is the variable you are looking for. Bruce Rick Sanders wrote: > Hello list, > > > > After someone uploads a file in the form field, how can I grab the file name > from the ? > > I've been through the documentation, and I can't see how to retrieve the > file name from the file field? > > I tried displaying the #form.filefield# but it just shows me the temp path > where CF uploaded the file to!? > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298131 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: File upload
DOH!. (slaps head). Heh. On Feb 4, 2008 12:44 PM, Robert Harrison <[EMAIL PROTECTED]> wrote: > ClientFile is the name of the original file uploaded by the client. > ServerFile is the name of the file after it's uploaded to the server. If > you're doing a rename you may need Serverfile. > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298130 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: File upload
CFFILE.clientFile Name of the file uploaded from the client's system CFFILE.serverFile Filename of the file saved on the server http://www.cfquickdocs.com/cf8/#cffile.upload -Original Message- From: Rick Sanders [mailto:[EMAIL PROTECTED] Sent: Monday, February 04, 2008 2:33 PM To: CF-Talk Subject: File upload Hello list, After someone uploads a file in the form field, how can I grab the file name from the ? I've been through the documentation, and I can't see how to retrieve the file name from the file field? I tried displaying the #form.filefield# but it just shows me the temp path where CF uploaded the file to!? Thanks, LogoSig Rick Sanders Webenergy Canada: 902-401-7689 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298129 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: File upload
ClientFile is the name of the original file uploaded by the client. ServerFile is the name of the file after it's uploaded to the server. If you're doing a rename you may need Serverfile. Robert B. Harrison Director of Interactive services Austin & Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be &. -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Monday, February 04, 2008 3:38 PM To: CF-Talk Subject: Re: File upload ClientFile is the variable you are looking for. Bruce Rick Sanders wrote: > Hello list, > > > > After someone uploads a file in the form field, how can I grab the file name > from the ? > > I've been through the documentation, and I can't see how to retrieve the > file name from the file field? > > I tried displaying the #form.filefield# but it just shows me the temp path > where CF uploaded the file to!? > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298128 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: File upload
> After someone uploads a file in the form field, how can I > grab the file name from the ? > > I've been through the documentation, and I can't see how to > retrieve the file name from the file field? > > I tried displaying the #form.filefield# but it just shows me > the temp path where CF uploaded the file to!? File.clientfile is the variable containing the original file name. File.serverfile is the variable containing the file name on the server: http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_f_10. html Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298127 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: File upload
ClientFile is the variable you are looking for. Bruce Rick Sanders wrote: > Hello list, > > > > After someone uploads a file in the form field, how can I grab the file name > from the ? > > I've been through the documentation, and I can't see how to retrieve the > file name from the file field? > > I tried displaying the #form.filefield# but it just shows me the temp path > where CF uploaded the file to!? > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298126 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
File upload
Hello list, After someone uploads a file in the form field, how can I grab the file name from the ? I've been through the documentation, and I can't see how to retrieve the file name from the file field? I tried displaying the #form.filefield# but it just shows me the temp path where CF uploaded the file to!? Thanks, LogoSig Rick Sanders Webenergy Canada: 902-401-7689 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298125 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Upload progress bar
No, they give you the option of adjusting it just to show that you can apparently ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: cf user [mailto:[EMAIL PROTECTED] Sent: Monday, February 04, 2008 2:22 PM To: CF-Talk Subject: Re: Upload progress bar >That failed miserably. The demo takes you to a page with a file field, I >selected a 6-7mb file and hit upload... a popup window came up but never >populated... it finally closed and the parent window redirected to a 404. > >.:.:.:.:.:.:.:.:.:.:.:. >Bobby Hartsfield >http://acoderslife.com > > > >http://www.cftagstore.com/tags/cfxupload.cfm Don't they tell you EXPLICITLY file size limit?? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298123 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Upload progress bar
I tried it again with a 1mb file just to be sure but it yields the same result. ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: cf user [mailto:[EMAIL PROTECTED] Sent: Monday, February 04, 2008 2:22 PM To: CF-Talk Subject: Re: Upload progress bar >That failed miserably. The demo takes you to a page with a file field, I >selected a 6-7mb file and hit upload... a popup window came up but never >populated... it finally closed and the parent window redirected to a 404. > >.:.:.:.:.:.:.:.:.:.:.:. >Bobby Hartsfield >http://acoderslife.com > > > >http://www.cftagstore.com/tags/cfxupload.cfm Don't they tell you EXPLICITLY file size limit?? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298124 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: My first CF 8 Ajax
Dave Watts wrote: > An AJAX call, like any HTTP request, requires that the target of the request > be a valid URL. If you want to invoke some file that's not in your web root > or any subdirectories of your web root, you'll need a virtual directory > configured in your web server. That was my first assumption and I put the CFC in my web root right next to the cfm file. But this cfm file calls a custom tag that builds my bask HTML page with the usual and associated parameters of a good xHTML compliant web page. So I put the tag in this custom tag. I was confused by the 'relative' to the calling page this tag was expecting. Just putting the CFC name into the cfc parameter ended up with a 'Can not find CFC' error. Any combination I tried did not work. Putting the CFC next to the custom tag template in the 'custom_tags' directory worked for the tag. It could find the CFC and generate the JavaScript logic, but it assumed this location was the web root, which it is not, and made the path accordingly. I stumbled upon a working combination by creating a 'Services' directory under my web root and putting 'Services.purDAO' into the cfc parameter of the tag. This is now working properly and I am returning data to my user interface. I still do not understand the in's and out's of these settings. I would like to know more if anybody has a good under the hood type information source. I suspect that my original location would have worked if I had put 'edit/purDAO' into the cfc parameter, but the documentation was rather vague on what is a relative and what is a absolute path from what starting points. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298122 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
New FedEx Webservice
They went live with their WebService over the weekend, anyone gotten this to work with CF(8) yet? I'm trying to convert the PHP5 example they have up there without much luck. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298121 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Translating MSSQL Scripts into MySQL Scripts
You won't be able to use "scripts" as Gerald mentions. This assumes you've got SQL Server running somewhere and you setup an ODBC connection to it and the wizard sucks all that information across and converts it appropriately. Does a great job of it. So, I guess this isn't what you're after, sorry about the wild goose chase. On Feb 4, 2008 3:03 PM, Rick Faircloth <[EMAIL PROTECTED]> wrote: > I saw that, but I wasn't totally sure that meant it > would translate or be able to use MSSQL scripts. > > Thanks, > Rick > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298120 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: Translating MSSQL Scripts into MySQL Scripts
I saw that, but I wasn't totally sure that meant it would translate or be able to use MSSQL scripts. Thanks, Rick > -Original Message- > From: Todd Rafferty [mailto:[EMAIL PROTECTED] > Sent: Monday, February 04, 2008 2:57 PM > To: CF-Talk > Subject: Re: OT: Translating MSSQL Scripts into MySQL Scripts > > Did you look at the feature matrix? > http://www.webyog.com/en/sqlyog_feature_matrix.php > > "Wizard Driven Migration Toolkit" falls under Enterprise. I have enterprise > and it's cheap enough ($97) and does the job and then some - I'm quite happy > and it's worth the money. > > On Feb 4, 2008 2:48 PM, Rick Faircloth <[EMAIL PROTECTED]> wrote: > > > Todd... > > > > Will the Community Version of Sqlyog perform > > the script conversion or does it take the > > Enterprise version? > > > > Rick > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298119 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: Translating MSSQL Scripts into MySQL Scripts
I don't know if it does SQL syntax "translation" per say. http://www.webyog.com/en/sqlyog_feature_matrix.php If you can get it into a MSSQL database you can import it into MySQL. I did it before a couple of years ago. I just don't remember exactly how. If I remember correctly the SQLyog eval version had some restrictions on it's enterprise functionality. On Feb 4, 2008 2:48 PM, Rick Faircloth <[EMAIL PROTECTED]> wrote: > Todd... > > Will the Community Version of Sqlyog perform > the script conversion or does it take the > Enterprise version? > > Rick > > > -Original Message- > > From: Todd Rafferty [mailto:[EMAIL PROTECTED] > > Sent: Monday, February 04, 2008 2:37 PM > > To: CF-Talk > > Subject: Re: OT: Translating MSSQL Scripts into MySQL Scripts > > > > Poke me off list if you need assistance with Sqlyog. > > > > On Feb 4, 2008 2:28 PM, Rick Faircloth <[EMAIL PROTECTED]> wrote: > > > > > Thanks, Todd... I'll check it out! > > > > > > I've got Navicat, which I've used to administer > > > MySQL since version 3, but I'm not sure if it will > > > perform this task. At least I haven't figured out > > > how to make it do it. > > > > > > Rick > > > > > > -- > > http://www.web-rat.com/ > > > > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298118 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Translating MSSQL Scripts into MySQL Scripts
Did you look at the feature matrix? http://www.webyog.com/en/sqlyog_feature_matrix.php "Wizard Driven Migration Toolkit" falls under Enterprise. I have enterprise and it's cheap enough ($97) and does the job and then some - I'm quite happy and it's worth the money. On Feb 4, 2008 2:48 PM, Rick Faircloth <[EMAIL PROTECTED]> wrote: > Todd... > > Will the Community Version of Sqlyog perform > the script conversion or does it take the > Enterprise version? > > Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298117 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT: Translating MSSQL Scripts into MySQL Scripts
Todd... Will the Community Version of Sqlyog perform the script conversion or does it take the Enterprise version? Rick > -Original Message- > From: Todd Rafferty [mailto:[EMAIL PROTECTED] > Sent: Monday, February 04, 2008 2:37 PM > To: CF-Talk > Subject: Re: OT: Translating MSSQL Scripts into MySQL Scripts > > Poke me off list if you need assistance with Sqlyog. > > On Feb 4, 2008 2:28 PM, Rick Faircloth <[EMAIL PROTECTED]> wrote: > > > Thanks, Todd... I'll check it out! > > > > I've got Navicat, which I've used to administer > > MySQL since version 3, but I'm not sure if it will > > perform this task. At least I haven't figured out > > how to make it do it. > > > > Rick > > > > -- > http://www.web-rat.com/ > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298116 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How do I export numerical data into Excel and keep the leading zeroes from disappearing
ITS WORKING THANK YOU!! Its working. I was able to export without tables so I didn't use them. I was using the ascii characters to set the tabs and new line such as Chr(9), chr(13), chr(10) I used the html table code and it all works. Definitely learned something NEW today. Here is the code sample: #i# THANK YOU AGAIN Jeremy, I tried that first. > Not sure if this will do what you want, but you can preface your data > with an apostrophe, that will tell excel it's a "text" field. ie 0001 > would be '0001 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298115 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT: Translating MSSQL Scripts into MySQL Scripts
Thanks, Todd! Rick > -Original Message- > From: Todd Rafferty [mailto:[EMAIL PROTECTED] > Sent: Monday, February 04, 2008 2:37 PM > To: CF-Talk > Subject: Re: OT: Translating MSSQL Scripts into MySQL Scripts > > Poke me off list if you need assistance with Sqlyog. > > On Feb 4, 2008 2:28 PM, Rick Faircloth <[EMAIL PROTECTED]> wrote: > > > Thanks, Todd... I'll check it out! > > > > I've got Navicat, which I've used to administer > > MySQL since version 3, but I'm not sure if it will > > perform this task. At least I haven't figured out > > how to make it do it. > > > > Rick > > > > -- > http://www.web-rat.com/ > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298114 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: My first CF 8 Ajax
> Firebug has given me more information, it is looking for the > CFC at "http://dev-pur/purDAO.cfc";. It is no longer at this > location. To make it work with the tag I > moved it to the 'custom_tags' > directory which is not in the web root. > > I'm back to my original question. How do I chart a path from > my 'custom_tags' directory to my web root? I need to go up > one directory and down a different branch and I do not know > how to do this in dot notation. What is the equivalent of > "../"? Surely not "..." Or I guess I need to provide an > absolute path, but an absolute path from where? My web root? > My site root? My drive root? Do I include the drive letter > as part of the path? An AJAX call, like any HTTP request, requires that the target of the request be a valid URL. If you want to invoke some file that's not in your web root or any subdirectories of your web root, you'll need a virtual directory configured in your web server. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298113 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Translating MSSQL Scripts into MySQL Scripts
Poke me off list if you need assistance with Sqlyog. On Feb 4, 2008 2:28 PM, Rick Faircloth <[EMAIL PROTECTED]> wrote: > Thanks, Todd... I'll check it out! > > I've got Navicat, which I've used to administer > MySQL since version 3, but I'm not sure if it will > perform this task. At least I haven't figured out > how to make it do it. > > Rick > > -- http://www.web-rat.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298112 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 Authority, Purchase Volumes
The discussion is pointless anyway... the beans were traded for a cow. sigh Sorry, Michael... :o) Rick > -Original Message- > From: Michael Dinowitz [mailto:[EMAIL PROTECTED] > Sent: Monday, February 04, 2008 1:18 PM > To: CF-Talk > Subject: Re: Coldfusion Authority, Purchase Volumes > > This thread has moved from a request for info to a 'fun' discussion and is > fodder for CF-Community or CF-OT. If posts about magic beans and the like > can be moved there I'd appreciate it. > Thanks > > On Feb 4, 2008 1:03 PM, Dawson, Michael <[EMAIL PROTECTED]> wrote: > > > He traded it to get his pet cow back. > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298111 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Upload progress bar
>That failed miserably. The demo takes you to a page with a file field, I >selected a 6-7mb file and hit upload... a popup window came up but never >populated... it finally closed and the parent window redirected to a 404. > >.:.:.:.:.:.:.:.:.:.:.:. >Bobby Hartsfield >http://acoderslife.com > > > >http://www.cftagstore.com/tags/cfxupload.cfm Don't they tell you EXPLICITLY file size limit?? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298110 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 Authority, Purchase Volumes
Very true... hadn't thought of that. I doubt Mastercard would put my money back into my bank account... I'm going to get a credit card! Rick > -Original Message- > From: Paul Vernon [mailto:[EMAIL PROTECTED] > Sent: Monday, February 04, 2008 12:53 PM > To: CF-Talk > Subject: RE: Coldfusion Authority, Purchase Volumes > > > So I seriously don't understand why anyone would use debit cards or > > cash if > > credit is an option. > > > > The other point here is security and protection... It is just so much more > secure to use a > Credit card than a debit card or cash... Callbacks just don't happen unless > you have a credit > card or a special "visa" backed debit card which is a rare thing... > > Paul > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298109 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: Translating MSSQL Scripts into MySQL Scripts
Thanks, Todd... I'll check it out! I've got Navicat, which I've used to administer MySQL since version 3, but I'm not sure if it will perform this task. At least I haven't figured out how to make it do it. Rick > -Original Message- > From: Todd Rafferty [mailto:[EMAIL PROTECTED] > Sent: Monday, February 04, 2008 2:17 PM > To: CF-Talk > Subject: Re: OT: Translating MSSQL Scripts into MySQL Scripts > > I use SQLyog ( http://www.webyog.com/en/ ). Just used it recently to > convert a database that was in SQL Server Ent and created MySQL tables, > etc. Very easy and simple to use migration tool. > > ~Todd > > On Feb 4, 2008 1:53 PM, Rick Faircloth <[EMAIL PROTECTED]> wrote: > > > > > Can anyone recommend a program that will translate > > > MSSQL scripts into MySQL scripts? I found some on > > > Google. couldn't find a way to do it on mysql.com. > > > > > > Before I try a program to do this, I thought I'd > > > get some recommendations from those of you with > > > experience at this. > > > > > > I can create the database/tables manually, but > > > I sure would like to save some time! > > > > > > Thanks, > > > Rick > > > > -- > http://www.web-rat.com/ > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298108 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: Translating MSSQL Scripts into MySQL Scripts
I have MSSQL SQL scripts provided by a data vendor that create tables, etc. in MSSQL7. I use MySQL 5. I want something that will run the scripts or translate the scripts so that MySQL 5 can understand them. Thanks for the reply, Gerald! Rick > -Original Message- > From: Gerald Guido [mailto:[EMAIL PROTECTED] > Sent: Monday, February 04, 2008 2:11 PM > To: CF-Talk > Subject: Re: OT: Translating MSSQL Scripts into MySQL Scripts > > I am not sure what you are asking. Do you want to import a MSSQL database to > Mysql? > > Or do you want to get something that will translate the MS's T-SQL dialect > to MySQL? > > > On Feb 4, 2008 1:53 PM, Rick Faircloth <[EMAIL PROTECTED]> wrote: > > > Can anyone recommend a program that will translate > > MSSQL scripts into MySQL scripts? I found some on > > Google. couldn't find a way to do it on mysql.com. > > > > Before I try a program to do this, I thought I'd > > get some recommendations from those of you with > > experience at this. > > > > I can create the database/tables manually, but > > I sure would like to save some time! > > > > Thanks, > > > > Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298107 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: My first CF 8 Ajax
Ian, should be the same way you call any normal CFC. Also note, if you're planning on using AJAXPROXY, then you're going to want to setup under a different Application.CFC that DOES NOT have an OnRequest() function. As I found out the hard way. On Feb 4, 2008 2:07 PM, Ian Skinner <[EMAIL PROTECTED]> wrote: > Ian Skinner wrote: > > Firebug has given me more information, it is looking for the CFC at > "http://dev-pur/purDAO.cfc";. It is no longer at this location. To make > it work with the tag I moved it to the 'custom_tags' > directory which is not in the web root. > > I'm back to my original question. How do I chart a path from my > 'custom_tags' directory to my web root? I need to go up one directory > and down a different branch and I do not know how to do this in dot > notation. What is the equivalent of "../"? Surely not "..." Or I > guess I need to provide an absolute path, but an absolute path from > where? My web root? My site root? My drive root? Do I include the > drive letter as part of the path? > > I do so wish modern documentation would more often include a little more > of WHY things work the way they do so that one can figure out how to > change stuff when you do not follow the set template. Everything I have > read so far assumes that the template containing the > tag is in the web root with the associated CFC at some lower level. > What if this is not the case? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298106 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: Translating MSSQL Scripts into MySQL Scripts
I use SQLyog ( http://www.webyog.com/en/ ). Just used it recently to convert a database that was in SQL Server Ent and created MySQL tables, etc. Very easy and simple to use migration tool. ~Todd On Feb 4, 2008 1:53 PM, Rick Faircloth <[EMAIL PROTECTED]> wrote: > > > Can anyone recommend a program that will translate > > MSSQL scripts into MySQL scripts? I found some on > > Google. couldn't find a way to do it on mysql.com. > > > > Before I try a program to do this, I thought I'd > > get some recommendations from those of you with > > experience at this. > > > > I can create the database/tables manually, but > > I sure would like to save some time! > > > > Thanks, > > Rick > -- http://www.web-rat.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298105 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: My first CF 8 Ajax
Ian Skinner wrote: Firebug has given me more information, it is looking for the CFC at "http://dev-pur/purDAO.cfc";. It is no longer at this location. To make it work with the tag I moved it to the 'custom_tags' directory which is not in the web root. I'm back to my original question. How do I chart a path from my 'custom_tags' directory to my web root? I need to go up one directory and down a different branch and I do not know how to do this in dot notation. What is the equivalent of "../"? Surely not "..." Or I guess I need to provide an absolute path, but an absolute path from where? My web root? My site root? My drive root? Do I include the drive letter as part of the path? I do so wish modern documentation would more often include a little more of WHY things work the way they do so that one can figure out how to change stuff when you do not follow the set template. Everything I have read so far assumes that the template containing the tag is in the web root with the associated CFC at some lower level. What if this is not the case? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298104 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: Translating MSSQL Scripts into MySQL Scripts
I am not sure what you are asking. Do you want to import a MSSQL database to Mysql? Or do you want to get something that will translate the MS's T-SQL dialect to MySQL? On Feb 4, 2008 1:53 PM, Rick Faircloth <[EMAIL PROTECTED]> wrote: > Can anyone recommend a program that will translate > MSSQL scripts into MySQL scripts? I found some on > Google. couldn't find a way to do it on mysql.com. > > Before I try a program to do this, I thought I'd > get some recommendations from those of you with > experience at this. > > I can create the database/tables manually, but > I sure would like to save some time! > > Thanks, > > Rick > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298103 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: Translating MSSQL Scripts into MySQL Scripts
Can anyone recommend a program that will translate MSSQL scripts into MySQL scripts? I found some on Google. couldn't find a way to do it on mysql.com. Before I try a program to do this, I thought I'd get some recommendations from those of you with experience at this. I can create the database/tables manually, but I sure would like to save some time! Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298102 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How do I export numerical data into Excel and keep the leading zeroes from disappearing
Not sure if this will do what you want, but you can preface your data with an apostrophe, that will tell excel it's a "text" field. ie 0001 would be '0001 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298101 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: My first CF 8 Ajax
Ok, I have got the tag to work and I have my CFC connected up to my client, theoretically. When I try to run my first test function that just returns a simple confirmation string, I am getting a 404 'Not Found' error returned from the AJAX call, I presume. Any guidance on what I look for from here? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298100 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: How do I export numerical data into Excel and keep the leading zeroes from disappearing
You might want to try saving the info you want in Excel as a variable using
Then after the output the variable.
#trim(Q_ref_table[i][currentrow])#
#variables.data#
-Original Message-
From: Deetra Whatley [mailto:[EMAIL PROTECTED]
Sent: Monday, February 04, 2008 1:09 PM
To: CF-Talk
Subject: Re: How do I export numerical data into Excel and keep the leading
zeroes from disappearing
But, when I actually import the following code into Excel, the HTML tag and
style is imported into the Excel spreadsheet also.
#trim(Q_ref_table[i][currentrow])#
>The way I actually do it is to create a class.
>
>
> td.text {mso-number-format:"\@";}
>
>
>1
>
>I think you're problem is that the format needs to be quoted. Try the
>above.
>
>
>
>leading zeroes from disappearing
>
>I have used that. Here is the code.
>
>
>
>maxrows="#maxrows#">
>
>
>
>
>#DateFormat(Q_ref_table[i][currentrow],"MM/DD/")#
>
>>#trim(Q_ref_table[i][currentrow])#
>
>
>
>
>
>
>It appears in Excel as:
>
>FBRM
>1
>10
>
>
>
>I am at wits end on this one.
>
>Thanks.
>
>You apply that as a style to the specific cells. Something like this
>need
>>something that would act the way the Excel text import wizard does.
>I've
>not
>>sure how/where to apply this style in my coldfusion code so that the
>>Excel spreadsheet reads instead of 0.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298099
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 Authority, Purchase Volumes
On Feb 4, 2008 11:52 AM, Paul Vernon wrote: > The other point here is security and protection... It is just so much more > secure to use a Credit card than a debit card or cash... Callbacks just > don't happen unless you have a credit card or a special "visa" backed debit > card which is a rare thing... > > Paul > "rare"?? I've had a Visa-backed debit card for well over 10 years now. As a mattere of fact, I cannot recall the last time I saw one that was not Visa/Mastercard backed. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298098 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Upload progress bar
That failed miserably. The demo takes you to a page with a file field, I selected a 6-7mb file and hit upload... a popup window came up but never populated... it finally closed and the parent window redirected to a 404. ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: cf user [mailto:[EMAIL PROTECTED] Sent: Monday, February 04, 2008 11:46 AM To: CF-Talk Subject: Re: Upload progress bar http://www.cftagstore.com/tags/cfxupload.cfm ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298097 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How do I export numerical data into Excel and keep the leading zeroes from disappearing
But, when I actually import the following code into Excel, the HTML tag and
style is imported into the Excel spreadsheet also.
#trim(Q_ref_table[i][currentrow])#
>The way I actually do it is to create a class.
>
>
> td.text {mso-number-format:"\@";}
>
>
>1
>
>I think you're problem is that the format needs to be quoted. Try the
>above.
>
>
>
>leading zeroes from disappearing
>
>I have used that. Here is the code.
>
>
>
>maxrows="#maxrows#">
>
>
>
>
>#DateFormat(Q_ref_table[i][currentrow],"MM/DD/")#
>
>>#trim(Q_ref_table[i][currentrow])#
>
>
>
>
>
>
>It appears in Excel as:
>
>FBRM
>1
>10
>
>
>
>I am at wits end on this one.
>
>Thanks.
>
>You apply that as a style to the specific cells. Something like this
>need
>>something that would act the way the Excel text import wizard does.
>I've
>not
>>sure how/where to apply this style in my coldfusion code so that the
>>Excel spreadsheet reads instead of 0.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298096
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 Authority, Purchase Volumes
This thread has moved from a request for info to a 'fun' discussion and is fodder for CF-Community or CF-OT. If posts about magic beans and the like can be moved there I'd appreciate it. Thanks On Feb 4, 2008 1:03 PM, Dawson, Michael <[EMAIL PROTECTED]> wrote: > He traded it to get his pet cow back. > > -Original Message- > From: Rick Faircloth [mailto:[EMAIL PROTECTED] > Sent: Monday, February 04, 2008 12:01 PM > To: CF-Talk > Subject: RE: Coldfusion Authority, Purchase Volumes > > > We transact all business using magic beans. > > Where's the API documentation? :o) > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298095 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfcontent downloads and IE
Isn't it application/msexcel ? ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Monday, February 04, 2008 11:26 AM To: CF-Talk Subject: cfcontent downloads and IE Hello, I am trying to use cfcontent to make an excel sheet and in Internet Explorer 7 the yellow bar at the top does it's thing and says "To help protect your security, IE has blocked this site from downloading files blah blah blah". I click the yellow bar and select "Download File", but nothing happens. No file is downloaded. If I don't refresh the page and try it again I do get the option to save or open the file and everything looks great. Why doesn't the first attempt to download work? Here is my code: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298094 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 Authority, Purchase Volumes
Please doing business with you michael :) thank you ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298093 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 Authority, Purchase Volumes
He traded it to get his pet cow back. -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Monday, February 04, 2008 12:01 PM To: CF-Talk Subject: RE: Coldfusion Authority, Purchase Volumes > We transact all business using magic beans. Where's the API documentation? :o) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298092 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 Authority, Purchase Volumes
this is a subject that could well go round in circles. the important thing is, is that people do things for different reasons. if that works for you then great, good point about security but there are also ways around that with debit cards. whatever works best for us then great. coldfusion is different as there is best practise for everything and i am honoured that you guys are teaching me so much. when it comes to finances, it is always best to to do what you think is best, there is no right or wrong way, but i will add this to the mix. banks etc... if you pay your credit card on time, you earn points, it costs you nothing, you get added security, you get better credit history. sounds great: where is the catch? > > So I seriously don't understand why anyone would use debit cards or > > cash if > > credit is an option. > > > > The other point here is security and protection... It is just so much > more secure to use a Credit card than a debit card or cash... > Callbacks just don't happen unless you have a credit card or a special > "visa" backed debit card which is a rare thing... > > Paul > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298090 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 Authority, Purchase Volumes
I hear ya! Haven't used credit cards in about 7 years! Yay! However, my debit cards work like credit cards for transactions. It's actually a Mastercard Debit Card. > -Original Message- > From: Richard White [mailto:[EMAIL PROTECTED] > Sent: Monday, February 04, 2008 12:26 PM > To: CF-Talk > Subject: Re: Coldfusion Authority, Purchase Volumes > > Hi Rick, > > we do have them but we have loads of different forms and the clever people > dont get credit > the game of money is all about who owe's who!!! therefore we have debit cards > where you use > the money you have, not the money you haven't - and that way we dont get > charged silly amounts > of money to use other peoples money :) > > hope that helps > > richard > > >Richard, are you saying that *you* don't have a credit card > >or that the UK doesn't have credit cards? > > > >From your statement below it sounds like people in the UK don't > >have Mastercard, AMEX, etc. > > > >Just curious... > > > >Rick > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298091 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 Authority, Purchase Volumes
> We transact all business using magic beans. Where's the API documentation? :o) > -Original Message- > From: Will Swain [mailto:[EMAIL PROTECTED] > Sent: Monday, February 04, 2008 12:29 PM > To: CF-Talk > Subject: RE: Coldfusion Authority, Purchase Volumes > > > We don't. We transact all business using magic beans. > > :) > > -Original Message- > From: Rick Faircloth [mailto:[EMAIL PROTECTED] > Sent: 04 February 2008 17:15 > To: CF-Talk > Subject: RE: Coldfusion Authority, Purchase Volumes > > Richard, are you saying that *you* don't have a credit card or that the UK > doesn't have credit cards? > > From your statement below it sounds like people in the UK don't have > Mastercard, AMEX, etc. > > Just curious... > > Rick > > > -Original Message- > > From: Richard White [mailto:[EMAIL PROTECTED] > > Sent: Monday, February 04, 2008 11:01 AM > > To: CF-Talk > > Subject: Coldfusion Authority, Purchase Volumes > > > > Hi i want to (need to!) purchase all the back issues of the fusion > > authority volumes however we live in the UK and do not have a > > mastercard, amex... we can only pay by paypal, is there anyway that we > > can purchase these by paypal, or does anyone know who we need to contact > to get hold of them otherwise. > > > > we are a little surprised that these are the only apparent payment > > options as the world is now getting smaller and smaller, so us little > people in the UK need to be thought about too!!! > > > > thanks > > > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298089 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Need help - data extraction tool
I know that I can build something to do this with relative ease but I'm wondering if there is something that already exists that I can use: We've built site for client based on relational database. Some of the attributes are Many to Many relations. Client provides us with spreadsheet of data to import that contains comma separated value list of attributes. In some cases, said value list spans multiple rows. Besides throttling the client, my goal is to have a spreadsheet (or table, which is where the data will end up) with something closer to a many-to-many feel with item number/name in one column and attribute value in another. Then I can write an INSERT statement to make the correct tie using joins. Anyone have such beastie that I can borrow? Thanks! Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298088 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 Authority, Purchase Volumes
i dont understand why some people like blonde woman and some people like really thin matchstick woman!!! we are all different. some like to control money in different ways. some people wont understand why other people leave their money in the bank at a small rate of 5% when their are options to get much more than that. if that option works for you thats great, it's not that other people haven't seen that option, its just that they prefer to do what they feel is right for them and their lifestyle. thats just my 2-pence on the matter :) >This is probably the wrong forum for this, but I had to answer. I don't >understand people who would rather use debit cards or cash instead of credit >cards. It just doesn't make sense to me. > >Assuming that you can control your spending, and pay your credit card bills >in full each month, you will get charged NOTHING from the credit card >companies. Not only will you earn points on your credit card (which could >be redeemed for different things, including cash, depending on your card), >but you get to keep your money in your bank account longer (as you don't >have to pay the bill until x amount of days after statement closes, so >anywhere from 30-60 days after your purchase.) The money can stay in your >bank account earning you around 5% interest, if you put it in a high yield >savings account. > >So I seriously don't understand why anyone would use debit cards or cash if >credit is an option. > >Russ > >> ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298087 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 Authority, Purchase Volumes
> So I seriously don't understand why anyone would use debit cards or > cash if > credit is an option. > The other point here is security and protection... It is just so much more secure to use a Credit card than a debit card or cash... Callbacks just don't happen unless you have a credit card or a special "visa" backed debit card which is a rare thing... Paul ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298086 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 Authority, Purchase Volumes
This is probably the wrong forum for this, but I had to answer. I don't understand people who would rather use debit cards or cash instead of credit cards. It just doesn't make sense to me. Assuming that you can control your spending, and pay your credit card bills in full each month, you will get charged NOTHING from the credit card companies. Not only will you earn points on your credit card (which could be redeemed for different things, including cash, depending on your card), but you get to keep your money in your bank account longer (as you don't have to pay the bill until x amount of days after statement closes, so anywhere from 30-60 days after your purchase.) The money can stay in your bank account earning you around 5% interest, if you put it in a high yield savings account. So I seriously don't understand why anyone would use debit cards or cash if credit is an option. Russ > -Original Message- > From: Richard White [mailto:[EMAIL PROTECTED] > Sent: Monday, February 04, 2008 12:26 PM > To: CF-Talk > Subject: Re: Coldfusion Authority, Purchase Volumes > > Hi Rick, > > we do have them but we have loads of different forms and the clever people > dont get credit the game of money is all about who owe's who!!! > therefore we have debit cards where you use the money you have, not the > money you haven't - and that way we dont get charged silly amounts of > money to use other peoples money :) > > hope that helps > > richard > > >Richard, are you saying that *you* don't have a credit card > >or that the UK doesn't have credit cards? > > > >From your statement below it sounds like people in the UK don't > >have Mastercard, AMEX, etc. > > > >Just curious... > > > >Rick > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298085 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: How do I export numerical data into Excel and keep the leading zeroes from disappearing
The way I actually do it is to create a class.
td.text {mso-number-format:"\@";}
1
I think you're problem is that the format needs to be quoted. Try the
above.
-Original Message-
From: Deetra Whatley [mailto:[EMAIL PROTECTED]
Sent: Monday, February 04, 2008 11:24 AM
To: CF-Talk
Subject: Re: How do I export numerical data into Excel and keep the
leading zeroes from disappearing
I have used that. Here is the code.
#DateFormat(Q_ref_table[i][currentrow],"MM/DD/")#
#trim(Q_ref_table[i][currentrow])#
It appears in Excel as:
FBRM
1
10
I am at wits end on this one.
Thanks.
You apply that as a style to the specific cells. Something like this
>should work:
>
>1
>
>
>
>zeroes from disappearing
>
>When I export a file into Excel, the leading zeroes disappear. How do
>you force Excel to treat the codes as text, and leave the zeroes? I
need
>something that would act the way the Excel text import wizard does.
I've
>tried enclosing the variable with single or double quotes, which sorta
>work, except that the quotes show up in Excel along with the zeroes.
>
>I have used a couple of custom tags, but they are not preserving the
>leading zeroes so the text is importing into Excel with no leading
>zeroes.
>
>For example (From CF: Import into Excel: 0)
>
>FYI: I read an answer using the mso-number-format:\@ style, but I am
not
>sure how/where to apply this style in my coldfusion code so that the
>Excel spreadsheet reads instead of 0.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298084
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 Authority, Purchase Volumes
You can call us at 718-951-3235 or email [EMAIL PROTECTED] On Feb 4, 2008 12:15 PM, Richard White <[EMAIL PROTECTED]> wrote: > hi michael, thanks for this. how can we do this in the meantime by email > or phone. will you be able to provide a number for me to call or an email to > me to get the ball rolling > > thanks again > > richard > > >We can send you a Paypal invoice for whatever you need or process it > >directly with you by email or phone. > >Google Checkout is easiest as I've already sweated over the API and got > it > >to do exactly what I want. It does custom shipping so that people in the > UK > >don't get a general 'out of the US' shipping rate but instead one > specific > >to them. I'll look over what Paypal offers API wise and get that going as > an > >option as well. > > > >On Feb 4, 2008 11:01 AM, Richard White <[EMAIL PROTECTED]> wrote: > > > >> > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298083 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 Authority, Purchase Volumes
Hi Rick, we do have them but we have loads of different forms and the clever people dont get credit the game of money is all about who owe's who!!! therefore we have debit cards where you use the money you have, not the money you haven't - and that way we dont get charged silly amounts of money to use other peoples money :) hope that helps richard >Richard, are you saying that *you* don't have a credit card >or that the UK doesn't have credit cards? > >From your statement below it sounds like people in the UK don't >have Mastercard, AMEX, etc. > >Just curious... > >Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298082 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
My first CF 8 Ajax
I am trying to write a tag. I can not get the proper path in the cfc parameter. I am placing the tag in my main page custom tag located in this directory. site ...custom_tags .pur_template.cfm The cfc is in my web root site ...wwroot .edit ...purDOA.cfc what do put into the cfc paramter to get from here to there? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298081 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How do I export numerical data into Excel and keep the leading zeroes from disappearing
I have used that. Here is the code. #DateFormat(Q_ref_table[i][currentrow],"MM/DD/")# #trim(Q_ref_table[i][currentrow])# It appears in Excel as: FBRM 1 10 I am at wits end on this one. Thanks. You apply that as a style to the specific cells. Something like this >should work: > >1 > > > >zeroes from disappearing > >When I export a file into Excel, the leading zeroes disappear. How do >you force Excel to treat the codes as text, and leave the zeroes? I need >something that would act the way the Excel text import wizard does. I've >tried enclosing the variable with single or double quotes, which sorta >work, except that the quotes show up in Excel along with the zeroes. > >I have used a couple of custom tags, but they are not preserving the >leading zeroes so the text is importing into Excel with no leading >zeroes. > >For example (From CF: Import into Excel: 0) > >FYI: I read an answer using the mso-number-format:\@ style, but I am not >sure how/where to apply this style in my coldfusion code so that the >Excel spreadsheet reads instead of 0. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298080 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 Authority, Purchase Volumes
We don't. We transact all business using magic beans. :) -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: 04 February 2008 17:15 To: CF-Talk Subject: RE: Coldfusion Authority, Purchase Volumes Richard, are you saying that *you* don't have a credit card or that the UK doesn't have credit cards? >From your statement below it sounds like people in the UK don't have Mastercard, AMEX, etc. Just curious... Rick > -Original Message- > From: Richard White [mailto:[EMAIL PROTECTED] > Sent: Monday, February 04, 2008 11:01 AM > To: CF-Talk > Subject: Coldfusion Authority, Purchase Volumes > > Hi i want to (need to!) purchase all the back issues of the fusion > authority volumes however we live in the UK and do not have a > mastercard, amex... we can only pay by paypal, is there anyway that we > can purchase these by paypal, or does anyone know who we need to contact to get hold of them otherwise. > > we are a little surprised that these are the only apparent payment > options as the world is now getting smaller and smaller, so us little people in the UK need to be thought about too!!! > > thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298079 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SOT - Exchange
That is a good start. Not counting the Exchange system adminstration, most of the user/mailbox administration is performed in Active Directory Users and Computers. With CFLDAP and CFEXCHANGE, you can do quite a lot of development to bridge Exchange and your web applications. I've had about six years of using AD along with CFLDAP. I wouldn't call myself an expert, but I do have considerable experience with automating quite a few of our processes involving user accounts, groups and mailboxes. There is quite a bit of administration, and automation, that can be performed using CFLDAP with AD. You can save yourself hours, if not days, of manually changing thousands of accounts (if you have that many). Please keep in touch. I would be happy to help with any AD or Exchange questions you may have. M!ke -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Monday, February 04, 2008 10:17 AM To: CF-Talk Subject: Re: SOT - Exchange 2007 version. I have done work with AD a few years ago. Wrote some CF apps that allowed users to update some of their information in AD. Bruce Dave Watts wrote: > What version of Exchange? Are you comfortable with managing Active > Directory already ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298078 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Excel 2007
Try adding the following when creating your HTML output: http://www.w3.org/TR/REC-html40";> -Original Message- From: Timmy Tom [mailto:[EMAIL PROTECTED] Sent: Monday, February 04, 2008 7:58 AM To: CF-Talk Subject: Re: Excel 2007 #Emp_ID# #FirstName# #LastName# when we open the excel file in a machine having office 2003 or earlier no problem , but when we open that file from a machine having office 2007 it shows this warning msg. On Feb 4, 2008 7:21 PM, Tom Chiverton <[EMAIL PROTECTED]> wrote: > On Monday 04 Feb 2008, Timmy K Tom wrote: > > I created Excel file using coldfusion, > > How ? > > -- > Tom Chiverton > Helping to confidentially accelerate visionary materials > on: http://thefalken.livejournal.com > > > > This email is sent for and on behalf of Halliwells LLP. > > Halliwells LLP is a limited liability partnership registered in England > and Wales under registered number OC307980 whose registered office address > is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. > A list of members is available for inspection at the registered office. Any > reference to a partner in relation to Halliwells LLP means a member of > Halliwells LLP. Regulated by The Solicitors Regulation Authority. > > CONFIDENTIALITY > > This email is intended only for the use of the addressee named above and > may be confidential or legally privileged. If you are not the addressee you > must not read it and must not use any information contained in nor copy it > nor inform any person other than Halliwells LLP or the addressee of its > existence or contents. If you have received this email in error please > delete it and notify Halliwells LLP IT Department on 0870 365 2500. > > For more information about Halliwells LLP visit www.halliwells.com. > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298077 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 Authority, Purchase Volumes
Richard, are you saying that *you* don't have a credit card or that the UK doesn't have credit cards? >From your statement below it sounds like people in the UK don't have Mastercard, AMEX, etc. Just curious... Rick > -Original Message- > From: Richard White [mailto:[EMAIL PROTECTED] > Sent: Monday, February 04, 2008 11:01 AM > To: CF-Talk > Subject: Coldfusion Authority, Purchase Volumes > > Hi i want to (need to!) purchase all the back issues of the fusion authority > volumes however > we live in the UK and do not have a mastercard, amex... we can only pay by > paypal, is there > anyway that we can purchase these by paypal, or does anyone know who we need > to contact to get > hold of them otherwise. > > we are a little surprised that these are the only apparent payment options as > the world is now > getting smaller and smaller, so us little people in the UK need to be thought > about too!!! > > thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298076 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 Authority, Purchase Volumes
hi michael, thanks for this. how can we do this in the meantime by email or phone. will you be able to provide a number for me to call or an email to me to get the ball rolling thanks again richard >We can send you a Paypal invoice for whatever you need or process it >directly with you by email or phone. >Google Checkout is easiest as I've already sweated over the API and got it >to do exactly what I want. It does custom shipping so that people in the UK >don't get a general 'out of the US' shipping rate but instead one specific >to them. I'll look over what Paypal offers API wise and get that going as an >option as well. > >On Feb 4, 2008 11:01 AM, Richard White <[EMAIL PROTECTED]> wrote: > >> ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298075 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
