Re: How do you guys deploy databases to shared servers?

2009-01-04 Thread Mike Kear
huh?  the COMPARE product is the one that copies data and structure
between two servers???   Really??

Cheers
MIke Kear


On Mon, Jan 5, 2009 at 4:28 PM, John M Bliss  wrote:
> I can't live without Red-Gate...
>
>> Which of them do you use to copy/duplicate/synchronise
>
> http://www.red-gate.com/products/SQL_Compare/ for DB structure.
> http://www.red-gate.com/products/SQL_Data_Compare/ for DB contents.
>
> On Sun, Jan 4, 2009 at 10:55 PM, Mike Kear  wrote:
>
>> Thanks Paul.  I see those Red gates packages are a series of $395
>> applications.  My tiny company isn't going to afford $5000 worth of
>> tools,  or even the bundle price around $1000.
>>
>> Which of them do you use to copy/duplicate/synchronise databases
>> between two servers?
>>
>> Cheers
>> Mike Kear
>> Windsor, NSW, Australia
>> Adobe Certified Advanced ColdFusion Developer
>> AFP Webworks
>> http://afpwebworks.com
>> ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
>>
>>
>>
>> On Mon, Jan 5, 2009 at 3:38 PM, Paul Kukiel  wrote:
>> > We recently got Red gates toolbelt SQL tools.  Like you upgrading/
>> > moving databases was time consuming and difficult.  Now its just so
>> > much easier.  http://www.red-gate.com/products/
>> > SQL_Professional_Toolbelt/index.htm
>> >
>> > Paul Kukiel
>> >
>> >
>> >
>> > On 04/01/2009, at 7:30 PM, Mike Kear wrote:
>> >
>> >> I'm heartily sick of the tedious way I have to spend half a day or
>> >> more EACH WEEK uploading and downloading databases from my
>> >> SQLServer2005 web sites.
>> >> I'm going to have another go at learning the best way to do this . .
>> >>
>> >> Can someone please give me some help...IN the old days I used
>> >> to have a
>> >> DTS task running overnight automatically, copying databases to and
>> >> from my dev environment to the production web sites.
>> >>
>> >> Since SQLServer2005 there has been no way that I can find,  to create
>> >> a DTS task and reuse it  EACH TIME I have to create it, and regardless
>> >> of whether I save the DTS task or not,  it's not available next time
>> >> for me to reuse.
>> >> I have ot create it all over again.Needless to say it's really
>> >> PISSING
>> >> ME OFF!
>> >>
>> >> Can someone please tell me how I can create a method of copying entire
>> >> databases which might have 40tables or more with the indexes, and key
>> >> relationships etc from remote servers to my local database server,  or
>> >> conversely from my dev environment to my production server.
>> >>
>> >> And also how I can do this in a way that the task is repeatable
>> >> without having to be created every time.
>> >>
>> >> I've tried using Visual Studio 2005 but that has finally defeated me.
>> >> I can never find what I want to use,  and the MS Help files are total
>> >> gobbldegook
>> >> to me.   I cant make head nor tail of it.  After 3 years of
>> >> wrestling with
>> >> Visual Studio I have had to give up.  There's no way to save any
>> >> file from
>> >> that and reuse it.   Not that I've found anyway.The best I've ever
>> >> managed to do is create a solution,  and run debug every time.
>> >> And that
>> >> takes 30 minutes to an hour to run a simple job of copying 3 tables,
>> >> and ties up my machine completely for the duration.
>> >>
>> >> I'm sure my problem is that I'm trying to use the wrong tools,  or
>> >> that I just don't know how to use the tools correctly,  but I'm
>> >> despairing of ever getting back to the neat and tidy way I had to do
>> >> this in the old SQLServer2000 days.
>> >>
>> >> Incidentally, just as an additional comment to my plea ...
>> >>
>> >> I cant use the copy database wizard, because it's a shared server and
>> >> I don't have admin rights.So I cant create a database on the
>> >> remote server using SQLServer management studio.
>> >>
>> >> For the same reason I cant create a backup and then restore it on the
>> >> other server..
>> >>
>> >> For the same reason I cant use replication in any way.
>> >>
>> >> For the same reason, detaching, FTP then attach to the other server is
>> >> out as well.
>> >>
>> >>
>> >> I think Microsoft forgot entirely about the thousands of people using
>> >> shared hosting servers when they developed SQLServer2005.   And I'm
>> >> told there's no provision for it in the new 2008 version either.
>> >> 
>> >>
>> >> So what do the rest of you people on shared hosts do??
>> >> --
>> >> Cheers
>> >> Mike Kear
>> >> Windsor, NSW, Australia
>> >> Adobe Certified Advanced ColdFusion Developer
>> >> AFP Webworks
>> >> http://afpwebworks.com
>> >> ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
>> >>
>> >>
>> >
>> >
>>
>>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317383
Subscription: http://www.houseoffusion.com/groups/cf-talk/

Re: How do you guys deploy databases to shared servers?

2009-01-04 Thread John M Bliss
I can't live without Red-Gate...

> Which of them do you use to copy/duplicate/synchronise

http://www.red-gate.com/products/SQL_Compare/ for DB structure.
http://www.red-gate.com/products/SQL_Data_Compare/ for DB contents.

On Sun, Jan 4, 2009 at 10:55 PM, Mike Kear  wrote:

> Thanks Paul.  I see those Red gates packages are a series of $395
> applications.  My tiny company isn't going to afford $5000 worth of
> tools,  or even the bundle price around $1000.
>
> Which of them do you use to copy/duplicate/synchronise databases
> between two servers?
>
> Cheers
> Mike Kear
> Windsor, NSW, Australia
> Adobe Certified Advanced ColdFusion Developer
> AFP Webworks
> http://afpwebworks.com
> ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
>
>
>
> On Mon, Jan 5, 2009 at 3:38 PM, Paul Kukiel  wrote:
> > We recently got Red gates toolbelt SQL tools.  Like you upgrading/
> > moving databases was time consuming and difficult.  Now its just so
> > much easier.  http://www.red-gate.com/products/
> > SQL_Professional_Toolbelt/index.htm
> >
> > Paul Kukiel
> >
> >
> >
> > On 04/01/2009, at 7:30 PM, Mike Kear wrote:
> >
> >> I'm heartily sick of the tedious way I have to spend half a day or
> >> more EACH WEEK uploading and downloading databases from my
> >> SQLServer2005 web sites.
> >> I'm going to have another go at learning the best way to do this . .
> >>
> >> Can someone please give me some help...IN the old days I used
> >> to have a
> >> DTS task running overnight automatically, copying databases to and
> >> from my dev environment to the production web sites.
> >>
> >> Since SQLServer2005 there has been no way that I can find,  to create
> >> a DTS task and reuse it  EACH TIME I have to create it, and regardless
> >> of whether I save the DTS task or not,  it's not available next time
> >> for me to reuse.
> >> I have ot create it all over again.Needless to say it's really
> >> PISSING
> >> ME OFF!
> >>
> >> Can someone please tell me how I can create a method of copying entire
> >> databases which might have 40tables or more with the indexes, and key
> >> relationships etc from remote servers to my local database server,  or
> >> conversely from my dev environment to my production server.
> >>
> >> And also how I can do this in a way that the task is repeatable
> >> without having to be created every time.
> >>
> >> I've tried using Visual Studio 2005 but that has finally defeated me.
> >> I can never find what I want to use,  and the MS Help files are total
> >> gobbldegook
> >> to me.   I cant make head nor tail of it.  After 3 years of
> >> wrestling with
> >> Visual Studio I have had to give up.  There's no way to save any
> >> file from
> >> that and reuse it.   Not that I've found anyway.The best I've ever
> >> managed to do is create a solution,  and run debug every time.
> >> And that
> >> takes 30 minutes to an hour to run a simple job of copying 3 tables,
> >> and ties up my machine completely for the duration.
> >>
> >> I'm sure my problem is that I'm trying to use the wrong tools,  or
> >> that I just don't know how to use the tools correctly,  but I'm
> >> despairing of ever getting back to the neat and tidy way I had to do
> >> this in the old SQLServer2000 days.
> >>
> >> Incidentally, just as an additional comment to my plea ...
> >>
> >> I cant use the copy database wizard, because it's a shared server and
> >> I don't have admin rights.So I cant create a database on the
> >> remote server using SQLServer management studio.
> >>
> >> For the same reason I cant create a backup and then restore it on the
> >> other server..
> >>
> >> For the same reason I cant use replication in any way.
> >>
> >> For the same reason, detaching, FTP then attach to the other server is
> >> out as well.
> >>
> >>
> >> I think Microsoft forgot entirely about the thousands of people using
> >> shared hosting servers when they developed SQLServer2005.   And I'm
> >> told there's no provision for it in the new 2008 version either.
> >> 
> >>
> >> So what do the rest of you people on shared hosts do??
> >> --
> >> Cheers
> >> Mike Kear
> >> Windsor, NSW, Australia
> >> Adobe Certified Advanced ColdFusion Developer
> >> AFP Webworks
> >> http://afpwebworks.com
> >> ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
> >>
> >>
> >
> >
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317382
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 you guys deploy databases to shared servers?

2009-01-04 Thread Mike Kear
How long does it take to publish a database using that database
publishing wizard??   I have had the 85MB SQL script running now for
28 minutes (and counting), giving my users database errors all that
time.


Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month



On Mon, Jan 5, 2009 at 3:55 PM, Mike Kear  wrote:
> Thanks Paul.  I see those Red gates packages are a series of $395
> applications.  My tiny company isn't going to afford $5000 worth of
> tools,  or even the bundle price around $1000.
>
> Which of them do you use to copy/duplicate/synchronise databases
> between two servers?
>
> Cheers
> Mike Kear
> Windsor, NSW, Australia
> Adobe Certified Advanced ColdFusion Developer
> AFP Webworks
> http://afpwebworks.com
> ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
>
>

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317381
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: iPhone Development

2009-01-04 Thread Bryan Hogan
That's what I was looking for. Thanks Barney

Bryan F. Hogan
Product Manager 
eDonor(r) - Recruit, Retain, Repeat
A Global Med Technologies(r) Company

P  602.489.7844
F  602.489.7801
www.edonor.com

The information contained in this electronic mail message, including all
attachments hereto, is confidential information intended only for
distribution to the individual(s) named above. If the reader of this
message is not the intended recipient, you are hereby notified that any
dissemination, distribution, use or copying of this  communication, and
the information contained herein, is strictly prohibited. If you have
received this communication in error, please immediately notify us by
telephone at (602) 489-7800 and delete the original message. Thank you.


-Original Message-
From: Barney Boisvert [mailto:bboisv...@gmail.com] 
Sent: Sunday, January 04, 2009 9:48 PM
To: cf-talk
Subject: Re: iPhone Development

If you just go grab Safari for Windows and use JS to resize it to the
right viewport you can get a pretty close approximation.  Not perfect,
particularly for mouse interaction, but it's reasonable.  If you're
serious about developing iPhone apps, you're gonna want an
iPhone/iTouch.

For native development, you have to have an Intel-based Mac running
OSX 10.5 and the free SDK from Apple.  Apps are built in Objective-C
(as mentioned above).  If you want to distribute, you have to pay $100
to get a key and then you can submit to the app store.

cheers,
barneyb

On Sun, Jan 4, 2009 at 8:41 PM, Bryan Hogan  wrote:
> Of course it can't be built with CFML. ;)  I understand that, what I'm
> looking to do is get started building applications for the iPhone.
The
> first of which is simple enough as Barney explained, just create the
> application to fit within a certain size and add the meta tag telling
> the iPhone browser that it is an iPhone site.
>
> This is simple enough, I am wondering though, if anyone knows of any
> emulator for Windows where I can test these applications.
>
> Furthermore, I would like to learn more about developing natively for
> the iPhone client to create embedded applications.
>
> Bryan F. Hogan
> Product Manager
> eDonor(r) - Recruit, Retain, Repeat
> A Global Med Technologies(r) Company
>
> P  602.489.7844
> F  602.489.7801
> www.edonor.com
>
> The information contained in this electronic mail message, including
all
> attachments hereto, is confidential information intended only for
> distribution to the individual(s) named above. If the reader of this
> message is not the intended recipient, you are hereby notified that
any
> dissemination, distribution, use or copying of this  communication,
and
> the information contained herein, is strictly prohibited. If you have
> received this communication in error, please immediately notify us by
> telephone at (602) 489-7800 and delete the original message. Thank
you.
>
> -Original Message-
> From: Ryan Stille [mailto:r...@cfwebtools.com]
> Sent: Sunday, January 04, 2009 5:01 PM
> To: cf-talk
> Subject: Re: iPhone Development
>
> Bryan Hogan wrote:
>> Can someone point me into the right direction to get started
> developing
>> iPhone applications with CFML?  I would like to develop on Windows if
> at
>> all possible.
>>
>
> You can't develop iPhone applications with CFML.  You can build a *web
> application* thats targeted to mobile (very small screen) browsers,
> however, using CFML.
>
> iPhone applications are developed using Objective-C and the iPhone
SDK.
>
> -Ryan
>
>
>
>
>
> 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317380
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 you guys deploy databases to shared servers?

2009-01-04 Thread Mike Kear
Thanks Paul.  I see those Red gates packages are a series of $395
applications.  My tiny company isn't going to afford $5000 worth of
tools,  or even the bundle price around $1000.

Which of them do you use to copy/duplicate/synchronise databases
between two servers?

Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month



On Mon, Jan 5, 2009 at 3:38 PM, Paul Kukiel  wrote:
> We recently got Red gates toolbelt SQL tools.  Like you upgrading/
> moving databases was time consuming and difficult.  Now its just so
> much easier.  http://www.red-gate.com/products/
> SQL_Professional_Toolbelt/index.htm
>
> Paul Kukiel
>
>
>
> On 04/01/2009, at 7:30 PM, Mike Kear wrote:
>
>> I'm heartily sick of the tedious way I have to spend half a day or
>> more EACH WEEK uploading and downloading databases from my
>> SQLServer2005 web sites.
>> I'm going to have another go at learning the best way to do this . .
>>
>> Can someone please give me some help...IN the old days I used
>> to have a
>> DTS task running overnight automatically, copying databases to and
>> from my dev environment to the production web sites.
>>
>> Since SQLServer2005 there has been no way that I can find,  to create
>> a DTS task and reuse it  EACH TIME I have to create it, and regardless
>> of whether I save the DTS task or not,  it's not available next time
>> for me to reuse.
>> I have ot create it all over again.Needless to say it's really
>> PISSING
>> ME OFF!
>>
>> Can someone please tell me how I can create a method of copying entire
>> databases which might have 40tables or more with the indexes, and key
>> relationships etc from remote servers to my local database server,  or
>> conversely from my dev environment to my production server.
>>
>> And also how I can do this in a way that the task is repeatable
>> without having to be created every time.
>>
>> I've tried using Visual Studio 2005 but that has finally defeated me.
>> I can never find what I want to use,  and the MS Help files are total
>> gobbldegook
>> to me.   I cant make head nor tail of it.  After 3 years of
>> wrestling with
>> Visual Studio I have had to give up.  There's no way to save any
>> file from
>> that and reuse it.   Not that I've found anyway.The best I've ever
>> managed to do is create a solution,  and run debug every time.
>> And that
>> takes 30 minutes to an hour to run a simple job of copying 3 tables,
>> and ties up my machine completely for the duration.
>>
>> I'm sure my problem is that I'm trying to use the wrong tools,  or
>> that I just don't know how to use the tools correctly,  but I'm
>> despairing of ever getting back to the neat and tidy way I had to do
>> this in the old SQLServer2000 days.
>>
>> Incidentally, just as an additional comment to my plea ...
>>
>> I cant use the copy database wizard, because it's a shared server and
>> I don't have admin rights.So I cant create a database on the
>> remote server using SQLServer management studio.
>>
>> For the same reason I cant create a backup and then restore it on the
>> other server..
>>
>> For the same reason I cant use replication in any way.
>>
>> For the same reason, detaching, FTP then attach to the other server is
>> out as well.
>>
>>
>> I think Microsoft forgot entirely about the thousands of people using
>> shared hosting servers when they developed SQLServer2005.   And I'm
>> told there's no provision for it in the new 2008 version either.
>> 
>>
>> So what do the rest of you people on shared hosts do??
>> --
>> Cheers
>> Mike Kear
>> Windsor, NSW, Australia
>> Adobe Certified Advanced ColdFusion Developer
>> AFP Webworks
>> http://afpwebworks.com
>> ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
>>
>>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317379
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: iPhone Development

2009-01-04 Thread Barney Boisvert
If you just go grab Safari for Windows and use JS to resize it to the
right viewport you can get a pretty close approximation.  Not perfect,
particularly for mouse interaction, but it's reasonable.  If you're
serious about developing iPhone apps, you're gonna want an
iPhone/iTouch.

For native development, you have to have an Intel-based Mac running
OSX 10.5 and the free SDK from Apple.  Apps are built in Objective-C
(as mentioned above).  If you want to distribute, you have to pay $100
to get a key and then you can submit to the app store.

cheers,
barneyb

On Sun, Jan 4, 2009 at 8:41 PM, Bryan Hogan  wrote:
> Of course it can't be built with CFML. ;)  I understand that, what I'm
> looking to do is get started building applications for the iPhone.  The
> first of which is simple enough as Barney explained, just create the
> application to fit within a certain size and add the meta tag telling
> the iPhone browser that it is an iPhone site.
>
> This is simple enough, I am wondering though, if anyone knows of any
> emulator for Windows where I can test these applications.
>
> Furthermore, I would like to learn more about developing natively for
> the iPhone client to create embedded applications.
>
> Bryan F. Hogan
> Product Manager
> eDonor(r) - Recruit, Retain, Repeat
> A Global Med Technologies(r) Company
>
> P  602.489.7844
> F  602.489.7801
> www.edonor.com
>
> The information contained in this electronic mail message, including all
> attachments hereto, is confidential information intended only for
> distribution to the individual(s) named above. If the reader of this
> message is not the intended recipient, you are hereby notified that any
> dissemination, distribution, use or copying of this  communication, and
> the information contained herein, is strictly prohibited. If you have
> received this communication in error, please immediately notify us by
> telephone at (602) 489-7800 and delete the original message. Thank you.
>
> -Original Message-
> From: Ryan Stille [mailto:r...@cfwebtools.com]
> Sent: Sunday, January 04, 2009 5:01 PM
> To: cf-talk
> Subject: Re: iPhone Development
>
> Bryan Hogan wrote:
>> Can someone point me into the right direction to get started
> developing
>> iPhone applications with CFML?  I would like to develop on Windows if
> at
>> all possible.
>>
>
> You can't develop iPhone applications with CFML.  You can build a *web
> application* thats targeted to mobile (very small screen) browsers,
> however, using CFML.
>
> iPhone applications are developed using Objective-C and the iPhone SDK.
>
> -Ryan
>
>
>
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317378
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 you guys deploy databases to shared servers?

2009-01-04 Thread Mike Kear
What a big disappointment, Dave.  It wont connect to a remote database
to update, only to a web service.  Who the hell inserts 40,000 records
into a database using a web service???

So instead i have to have the tool create a big SQLscript.  I have to
run a 85MB SQLscript.   by cutting and pasting it into my Query
Analyser.   It's been running 8 minutes now,  and i hope it isnt going
to timeout on me.Not fillng me with confidence, but at least
it's a move forward. Thanks for suggesting it.

Cheers
Mike Kear


On Mon, Jan 5, 2009 at 3:20 PM, Mike Kear  wrote:
> No I havent, Dave,  and I'm surprised that in all the whinging I've
> done to Microsoft in the last 3 years, no one there has mentioned it.
> I'ave gone at them over this issue so many times,  i have had to ease
> off in the last few months lest i be classed as a "vexatious support
> caller" and get myself banned.
>
> Perhaps my pestering over the years resulted in an outcome, but no one
> there figured it was worth telling me.
>
> I dont know but i'll give it a try.   On the face of it,   this looks
> like the solution for me.   Thanks!
>
> Cheers
> Mike Kear
> Windsor, NSW, Australia
> Adobe Certified Advanced ColdFusion Developer
> AFP Webworks
> http://afpwebworks.com
> ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
>
>
> On Mon, Jan 5, 2009 at 3:06 PM, Dave Watts  wrote:
>>> Can someone please give me some help...IN the old days I used to have a
>>> DTS task running overnight automatically, copying databases to and
>>> from my dev environment to the production web sites.
>>
>> Have you tried this?
>> http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en
>>
>> Dave Watts, CTO, Fig Leaf Software
>> http://www.figleaf.com/
>>
>> Fig Leaf Software provides the highest caliber vendor-authorized
>> instruction at our training centers in Washington DC, Atlanta,
>> Chicago, Baltimore, Northern Virginia, or on-site at your location.
>> Visit http://training.figleaf.com/ for more information!
>>
>> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317377
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: iPhone Development

2009-01-04 Thread Bryan Hogan
Of course it can't be built with CFML. ;)  I understand that, what I'm
looking to do is get started building applications for the iPhone.  The
first of which is simple enough as Barney explained, just create the
application to fit within a certain size and add the meta tag telling
the iPhone browser that it is an iPhone site.

This is simple enough, I am wondering though, if anyone knows of any
emulator for Windows where I can test these applications.  

Furthermore, I would like to learn more about developing natively for
the iPhone client to create embedded applications.

Bryan F. Hogan
Product Manager 
eDonor(r) - Recruit, Retain, Repeat
A Global Med Technologies(r) Company

P  602.489.7844
F  602.489.7801
www.edonor.com

The information contained in this electronic mail message, including all
attachments hereto, is confidential information intended only for
distribution to the individual(s) named above. If the reader of this
message is not the intended recipient, you are hereby notified that any
dissemination, distribution, use or copying of this  communication, and
the information contained herein, is strictly prohibited. If you have
received this communication in error, please immediately notify us by
telephone at (602) 489-7800 and delete the original message. Thank you.

-Original Message-
From: Ryan Stille [mailto:r...@cfwebtools.com] 
Sent: Sunday, January 04, 2009 5:01 PM
To: cf-talk
Subject: Re: iPhone Development

Bryan Hogan wrote:
> Can someone point me into the right direction to get started
developing
> iPhone applications with CFML?  I would like to develop on Windows if
at
> all possible.
>   

You can't develop iPhone applications with CFML.  You can build a *web 
application* thats targeted to mobile (very small screen) browsers, 
however, using CFML.

iPhone applications are developed using Objective-C and the iPhone SDK.

-Ryan





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317376
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 you guys deploy databases to shared servers?

2009-01-04 Thread Paul Kukiel
We recently got Red gates toolbelt SQL tools.  Like you upgrading/ 
moving databases was time consuming and difficult.  Now its just so  
much easier.  http://www.red-gate.com/products/ 
SQL_Professional_Toolbelt/index.htm

Paul Kukiel



On 04/01/2009, at 7:30 PM, Mike Kear wrote:

> I'm heartily sick of the tedious way I have to spend half a day or
> more EACH WEEK uploading and downloading databases from my
> SQLServer2005 web sites.
> I'm going to have another go at learning the best way to do this . .
>
> Can someone please give me some help...IN the old days I used  
> to have a
> DTS task running overnight automatically, copying databases to and
> from my dev environment to the production web sites.
>
> Since SQLServer2005 there has been no way that I can find,  to create
> a DTS task and reuse it  EACH TIME I have to create it, and regardless
> of whether I save the DTS task or not,  it's not available next time
> for me to reuse.
> I have ot create it all over again.Needless to say it's really  
> PISSING
> ME OFF!
>
> Can someone please tell me how I can create a method of copying entire
> databases which might have 40tables or more with the indexes, and key
> relationships etc from remote servers to my local database server,  or
> conversely from my dev environment to my production server.
>
> And also how I can do this in a way that the task is repeatable
> without having to be created every time.
>
> I've tried using Visual Studio 2005 but that has finally defeated me.
> I can never find what I want to use,  and the MS Help files are total
> gobbldegook
> to me.   I cant make head nor tail of it.  After 3 years of  
> wrestling with
> Visual Studio I have had to give up.  There's no way to save any  
> file from
> that and reuse it.   Not that I've found anyway.The best I've ever
> managed to do is create a solution,  and run debug every time.
> And that
> takes 30 minutes to an hour to run a simple job of copying 3 tables,
> and ties up my machine completely for the duration.
>
> I'm sure my problem is that I'm trying to use the wrong tools,  or
> that I just don't know how to use the tools correctly,  but I'm
> despairing of ever getting back to the neat and tidy way I had to do
> this in the old SQLServer2000 days.
>
> Incidentally, just as an additional comment to my plea ...
>
> I cant use the copy database wizard, because it's a shared server and
> I don't have admin rights.So I cant create a database on the
> remote server using SQLServer management studio.
>
> For the same reason I cant create a backup and then restore it on the
> other server..
>
> For the same reason I cant use replication in any way.
>
> For the same reason, detaching, FTP then attach to the other server is
> out as well.
>
>
> I think Microsoft forgot entirely about the thousands of people using
> shared hosting servers when they developed SQLServer2005.   And I'm
> told there's no provision for it in the new 2008 version either.
> 
>
> So what do the rest of you people on shared hosts do??
> -- 
> Cheers
> Mike Kear
> Windsor, NSW, Australia
> Adobe Certified Advanced ColdFusion Developer
> AFP Webworks
> http://afpwebworks.com
> ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317375
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 you guys deploy databases to shared servers?

2009-01-04 Thread Mike Kear
No I havent, Dave,  and I'm surprised that in all the whinging I've
done to Microsoft in the last 3 years, no one there has mentioned it.
I'ave gone at them over this issue so many times,  i have had to ease
off in the last few months lest i be classed as a "vexatious support
caller" and get myself banned.

Perhaps my pestering over the years resulted in an outcome, but no one
there figured it was worth telling me.

I dont know but i'll give it a try.   On the face of it,   this looks
like the solution for me.   Thanks!

Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month


On Mon, Jan 5, 2009 at 3:06 PM, Dave Watts  wrote:
>> Can someone please give me some help...IN the old days I used to have a
>> DTS task running overnight automatically, copying databases to and
>> from my dev environment to the production web sites.
>
> Have you tried this?
> http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
>
> Fig Leaf Software provides the highest caliber vendor-authorized
> instruction at our training centers in Washington DC, Atlanta,
> Chicago, Baltimore, Northern Virginia, or on-site at your location.
> Visit http://training.figleaf.com/ for more information!
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317374
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 you guys deploy databases to shared servers?

2009-01-04 Thread Dave Watts
> Can someone please give me some help...IN the old days I used to have a
> DTS task running overnight automatically, copying databases to and
> from my dev environment to the production web sites.

Have you tried this?
http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317373
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Best performace/practice for storing temp data

2009-01-04 Thread j s
Working on shopping cart app and stuck between storing shipping info in a db 
shipTable or in client scope.  I'm hesitant to store shipping info into the db 
because some users might not complete the transaction and take up rows in the 
db.  On the other hand if I store shipping info in the client scope I'm not 
sure if this would impact the server.

The goal is hold the users shipping info and later display/process the data on 
the final checkout page.  I tried using form variables but that only works from 
template to template.

Any suggestions or opinions would be greatly appreciated.

Thanks in advance. 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317372
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 you guys deploy databases to shared servers?

2009-01-04 Thread Toby Tremayne
I'll second that on  navicat - worth the very small fee for the pro  
version even.  The ability to just select a source and destination db  
and copy al structure and or data automatically is wonderful.  Doesn't  
matter whether the source or destination are local or remote or both.

Toby
On 05/01/2009, at 2:15 PM, Will Tomlinson wrote:

>> I'm heartily sick of the tedious way I have to spend half a day or
>> more EACH WEEK uploading and downloading databases from my
>> SQLServer2005 web sites.
>
>
> Not that it helps you any, but this is exactly the reason I've moved  
> most of my websites to MySQL. Navicat makes this kinda thing  
> completely brainless for me.
>
> Will
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317371
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 you guys deploy databases to shared servers?

2009-01-04 Thread Will Tomlinson
>I'm heartily sick of the tedious way I have to spend half a day or
>more EACH WEEK uploading and downloading databases from my
>SQLServer2005 web sites.


Not that it helps you any, but this is exactly the reason I've moved most of my 
websites to MySQL. Navicat makes this kinda thing completely brainless for me.

Will 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317370
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: [SOT] avg hourly rate for mid and adv cf programmer

2009-01-04 Thread Aaron Rouse
That seems to be the going rate down here in this neck of the woods for self
employed developers working 1099.  I'd thought up in DC people would get
more since the cost of living I am told is much higher up there than down
here.  Although it also does not surprise me because the few times I have
gone looking for work, I would always get out of state offers that paid no
more than what I would get here but always be in places that had a higher
cost of living.

On Sun, Jan 4, 2009 at 6:29 PM, Pete Ruckelshaus wrote:

> Development only with a well-defined project spec?  $60/hr.  Otherwise,
> $75/hr.
>
>


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317369
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: [SOT] avg hourly rate for mid and adv cf programmer

2009-01-04 Thread Gerald Guido
Most of the independents that I know get between $40 to $130/hr. Those
numbers vary by the nature of the work and overhead.

Basically if the client gives you a predefined scope of work, i.e sub
contracting for another shop (B2B), where you don't have to deal directly
with the client, the rates are lower. If you are working in house (or
remotely) as a temp/subcontractor for say, a 1-3 month project, the hourly
rate (on Monster.com) is between 30-60 hr. No hassles... you just get paid
for the work you do. For contract work acting as the design/development
house and walking in cold, doing a scope of work, writing the
proposal/contract etc. you start getting into the higher end of the range
(greater risk/more work). If you have to do administrative work like writing
contracts, book keeping, customer service etc. you need to figure that in to
your hourly rate as overhead.

When I was running my shop I billed at $50/hr when I first started and moved
up to $75 to $95 /hr. One of my friends (a client)  said that I should raise
my rates because people would question the quality of the work if my rate it
too low. The next project I did for him I jacked my rate up $25 an hr.
(Hey... you said I need to raise my rates.)

In any event, my advice for doing *ANY* client/contract work (I have been
burned by a non profit mind you) is to get a bullet proof contract. I bought
the "Web Development and Hosting Suite" from http://www.contractedge.com and
it has served me well. Define the scope of work as best you can, leave as
little to interpretation as possible and *document everything*.

HTH

G



On Sun, Jan 4, 2009 at 7:29 PM, Pete Ruckelshaus wrote:

> Development only with a well-defined project spec?  $60/hr.  Otherwise,
> $75/hr.
>
> On Thu, Nov 3, 2005 at 10:38 AM, John Lucania 
> wrote:
> > Morning, Gurus!
> >
> > What is the avg hourly rate for mid and adv cf programmer for
> > gov/non-for-profit contract work in Wash DC area and surburb?The
> > hourly rate won't include any benefits or whatsoever.
> >
> > jl
> >
> >
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317368
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: iPhone Development

2009-01-04 Thread Barney Boisvert
Just google it.  Just a way of telling the phone about how your app
wants to be displayed.  Its not required, but you almost always want
it.

cheers,
barneyb

On 1/4/09, Les Schmidt  wrote:
>>Web apps, you mean?  Go grab the meta tag you need to lock the screen
>>size, and the develop as normal. HTML, JS and CSS are virtually
>>identical to the normal browser, mouse events are the biggest
>>difference to deal with.
>>
>>cheers,
>>barneyb
>>
>>
>>>
>
> Barney,
> Can you expand/explain further please on what you mean by "go grab the meta
> tag you need to lock the screen size"?  Haven't dealt with meta tags
> previously...
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317367
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 you guys deploy databases to shared servers?

2009-01-04 Thread Toby Tremayne
actually that may be a problem - sql litespeed works via a number of  
stored procedures you install, but I'm afraid I can't remember the  
permission requirements either for install or use.  There's a free  
demo though, so you can give it a try.

Toby
On 05/01/2009, at 11:48 AM, Mike Kear wrote:

> Thanks Toby.Does it allow you to back up and restore if you dont
> have administrator priveleges?   That's the problem with shared
> hosting - Microsoft dont seem to have made any provision for database
> owners to do any of these tasks,  only server administrators.
> Obviously, on a shared system where you might have hundreds of people
> creating and managing databases, you cant allow them all to have admin
> rights.A web site owner usually only has dbo rights.
>
> Cheers
> Mike Kear
> Windsor, NSW, Australia
> Adobe Certified Advanced ColdFusion Developer
> AFP Webworks
> http://afpwebworks.com
> ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
>
>
>
> On Mon, Jan 5, 2009 at 11:39 AM, Toby Tremayne  
>  wrote:
>> check out sql litespeed for very quick and powerful backup and
>> restore.  Can be a handy way to move them about - although I must
>> admit I'm out of date now as I tend to stick to postgresql and mysql
>> which have very simple porting methods.
>>
>> Toby
>>
> --
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317366
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 you guys deploy databases to shared servers?

2009-01-04 Thread Mike Kear
Thanks Toby.Does it allow you to back up and restore if you dont
have administrator priveleges?   That's the problem with shared
hosting - Microsoft dont seem to have made any provision for database
owners to do any of these tasks,  only server administrators.
Obviously, on a shared system where you might have hundreds of people
creating and managing databases, you cant allow them all to have admin
rights.A web site owner usually only has dbo rights.

Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month



On Mon, Jan 5, 2009 at 11:39 AM, Toby Tremayne  wrote:
> check out sql litespeed for very quick and powerful backup and
> restore.  Can be a handy way to move them about - although I must
> admit I'm out of date now as I tend to stick to postgresql and mysql
> which have very simple porting methods.
>
> Toby
>
--

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317365
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 you guys deploy databases to shared servers?

2009-01-04 Thread Toby Tremayne
check out sql litespeed for very quick and powerful backup and  
restore.  Can be a handy way to move them about - although I must  
admit I'm out of date now as I tend to stick to postgresql and mysql  
which have very simple porting methods.

Toby

On 05/01/2009, at 11:30 AM, Mike Kear wrote:

> I'm heartily sick of the tedious way I have to spend half a day or
> more EACH WEEK uploading and downloading databases from my
> SQLServer2005 web sites.
> I'm going to have another go at learning the best way to do this . .
>
> Can someone please give me some help...IN the old days I used to  
> have a
> DTS task running overnight automatically, copying databases to and
> from my dev environment to the production web sites.
>
> Since SQLServer2005 there has been no way that I can find,  to create
> a DTS task and reuse it  EACH TIME I have to create it, and regardless
> of whether I save the DTS task or not,  it's not available next time
> for me to reuse.
> I have ot create it all over again.Needless to say it's really  
> PISSING
> ME OFF!
>
> Can someone please tell me how I can create a method of copying entire
> databases which might have 40tables or more with the indexes, and key
> relationships etc from remote servers to my local database server,  or
> conversely from my dev environment to my production server.
>
> And also how I can do this in a way that the task is repeatable
> without having to be created every time.
>
> I've tried using Visual Studio 2005 but that has finally defeated me.
> I can never find what I want to use,  and the MS Help files are total
> gobbldegook
> to me.   I cant make head nor tail of it.  After 3 years of  
> wrestling with
> Visual Studio I have had to give up.  There's no way to save any  
> file from
> that and reuse it.   Not that I've found anyway.The best I've ever
> managed to do is create a solution,  and run debug every time.   And  
> that
> takes 30 minutes to an hour to run a simple job of copying 3 tables,
> and ties up my machine completely for the duration.
>
> I'm sure my problem is that I'm trying to use the wrong tools,  or
> that I just don't know how to use the tools correctly,  but I'm
> despairing of ever getting back to the neat and tidy way I had to do
> this in the old SQLServer2000 days.
>
> Incidentally, just as an additional comment to my plea ...
>
> I cant use the copy database wizard, because it's a shared server and
> I don't have admin rights.So I cant create a database on the
> remote server using SQLServer management studio.
>
> For the same reason I cant create a backup and then restore it on the
> other server..
>
> For the same reason I cant use replication in any way.
>
> For the same reason, detaching, FTP then attach to the other server is
> out as well.
>
>
> I think Microsoft forgot entirely about the thousands of people using
> shared hosting servers when they developed SQLServer2005.   And I'm
> told there's no provision for it in the new 2008 version either.
> 
>
> So what do the rest of you people on shared hosts do??
> -- 
> Cheers
> Mike Kear
> Windsor, NSW, Australia
> Adobe Certified Advanced ColdFusion Developer
> AFP Webworks
> http://afpwebworks.com
> ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317364
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: [SOT] avg hourly rate for mid and adv cf programmer

2009-01-04 Thread Pete Ruckelshaus
Any elected representative of mine who votes for that sure as hell
isn't getting my vote in the next election cycle.  I have a handful of
friends, really good developers, who are currently jobless, and the
only reason I'm probably not jobless is because I've switched careers
to teaching.

Pete

On Thu, Nov 3, 2005 at 11:13 AM, Lee  wrote:
> Congress is looking at adding another
> 210,000 or so HB1 Visas which could trend those numbers
> lower.
>
> Lee
>

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317363
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


How do you guys deploy databases to shared servers?

2009-01-04 Thread Mike Kear
I'm heartily sick of the tedious way I have to spend half a day or
more EACH WEEK uploading and downloading databases from my
SQLServer2005 web sites.
I'm going to have another go at learning the best way to do this . .

Can someone please give me some help...IN the old days I used to have a
DTS task running overnight automatically, copying databases to and
from my dev environment to the production web sites.

Since SQLServer2005 there has been no way that I can find,  to create
a DTS task and reuse it  EACH TIME I have to create it, and regardless
of whether I save the DTS task or not,  it's not available next time
for me to reuse.
I have ot create it all over again.Needless to say it's really PISSING
ME OFF!

Can someone please tell me how I can create a method of copying entire
databases which might have 40tables or more with the indexes, and key
relationships etc from remote servers to my local database server,  or
conversely from my dev environment to my production server.

And also how I can do this in a way that the task is repeatable
without having to be created every time.

I've tried using Visual Studio 2005 but that has finally defeated me.
I can never find what I want to use,  and the MS Help files are total
gobbldegook
to me.   I cant make head nor tail of it.  After 3 years of wrestling with
Visual Studio I have had to give up.  There's no way to save any file from
that and reuse it.   Not that I've found anyway.The best I've ever
managed to do is create a solution,  and run debug every time.   And that
takes 30 minutes to an hour to run a simple job of copying 3 tables,
and ties up my machine completely for the duration.

I'm sure my problem is that I'm trying to use the wrong tools,  or
that I just don't know how to use the tools correctly,  but I'm
despairing of ever getting back to the neat and tidy way I had to do
this in the old SQLServer2000 days.

Incidentally, just as an additional comment to my plea ...

I cant use the copy database wizard, because it's a shared server and
I don't have admin rights.So I cant create a database on the
remote server using SQLServer management studio.

For the same reason I cant create a backup and then restore it on the
other server..

For the same reason I cant use replication in any way.

For the same reason, detaching, FTP then attach to the other server is
out as well.


I think Microsoft forgot entirely about the thousands of people using
shared hosting servers when they developed SQLServer2005.   And I'm
told there's no provision for it in the new 2008 version either.


So what do the rest of you people on shared hosts do??
-- 
Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317362
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: [SOT] avg hourly rate for mid and adv cf programmer

2009-01-04 Thread Pete Ruckelshaus
Development only with a well-defined project spec?  $60/hr.  Otherwise, $75/hr.

On Thu, Nov 3, 2005 at 10:38 AM, John Lucania  wrote:
> Morning, Gurus!
>
> What is the avg hourly rate for mid and adv cf programmer for
> gov/non-for-profit contract work in Wash DC area and surburb?The
> hourly rate won't include any benefits or whatsoever.
>
> jl
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317361
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Extending application.cfc

2009-01-04 Thread s. isaac dealey
> And then in your subdirectory/Application.cfc use
> extends="appcfcproxy.cfc" 

Or rather extends="appcfcproxy"... oops!

-- 
s. isaac dealey  ^  new epoch
 isn't it time for a change? 
 ph: 781.769.0723

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;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317360
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: iPhone Development

2009-01-04 Thread Ryan Stille
Bryan Hogan wrote:
> Can someone point me into the right direction to get started developing
> iPhone applications with CFML?  I would like to develop on Windows if at
> all possible.
>   

You can't develop iPhone applications with CFML.  You can build a *web 
application* thats targeted to mobile (very small screen) browsers, 
however, using CFML.

iPhone applications are developed using Objective-C and the iPhone SDK.

-Ryan



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317359
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: iPhone Development

2009-01-04 Thread Les Schmidt
>Web apps, you mean?  Go grab the meta tag you need to lock the screen
>size, and the develop as normal. HTML, JS and CSS are virtually
>identical to the normal browser, mouse events are the biggest
>difference to deal with.
>
>cheers,
>barneyb
>
>
>>

Barney,
Can you expand/explain further please on what you mean by "go grab the meta tag 
you need to lock the screen size"?  Haven't dealt with meta tags previously... 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317358
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Extending application.cfc

2009-01-04 Thread s. isaac dealey
> Hey all.
> 
> I have been extending an Application.cfc from my root in a sub directory
> using mappings. I recently implemented THIS.mappings and it doesn't appear
> that the mapping for the extended Application.cfc is working. can anyone
> test this and confirm deny it?

You can't. Mappings created in the Application.cfc can't affect the
extends attribute of the Application.cfc. If you're using Adobe's CF
server, you can create a file in the current directory like this: 

appcfcproxy.cfc 


And then in your subdirectory/Application.cfc use
extends="appcfcproxy.cfc" 

I'm not sure about Railo or Smith but I know this won't work with
BlueDragon. 

The onTap framework's Application.cfc was designed to eliminate the need
for this kind of nesting (as was common with Application.cfm) by making
the onRequestStart and onRequestEnd events tiered. This way you can
easily add whatever you need in those events for a given subdirectory
without doing this kind of tapdancing with the Application.cfc. 


-- 
s. isaac dealey  ^  new epoch
 isn't it time for a change? 
 ph: 781.769.0723

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;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317357
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Extending application.cfc

2009-01-04 Thread jonese
Hey all.

I have been extending an Application.cfc from my root in a sub directory
using mappings. I recently implemented THIS.mappings and it doesn't appear
that the mapping for the extended Application.cfc is working. can anyone
test this and confirm deny it?

Thanks in advance!
___
Eric Jones aka jonese
http://www.jonese.us
http://twitter.com/jonese


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317356
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) Java-Hibernate-problem: Optimistic concurrency control problem, I need a second opinion !

2009-01-04 Thread Barney Boisvert
I'm not sure I understand your problem.  You'll need to create four
distinct Address objects, you can't reuse then for different fields,
but as long as you're doing that, I don't see a problem.  Here's some
psuedo-code, assuming Address has a pair of constructors - one with
individual arguments and one copy constructor:

cust = dao.getCustomer(...);
cust.contactAddress = new Address(form.contacttreet, ...);
cust.companyAddress = new Address(form.companyStreet, ...);
cust.deliveryAddress = new Address(cust.contactAddress);
cust.billingAddress = new Address(cust.companyAddress);
dao.saveCustomer(cust);

cheers,
barneyb

On Sun, Jan 4, 2009 at 2:16 AM,   wrote:
> Hi list,
>
> in our freshly build Java B2B-Shop-Customer-System (build from scratch, based
> on Hibernate. Spring etc.) we have
> four adresses in the MS-SQL-DB (MS-SQL-2000): contact_address,
> company_address, delivery_address, billing_address.
>
> In the end-customer's registration process the following happens (in case the
> customer says that the delivery_address + billing address is being
> assembled out of the contact/-delivery_addresses and doesn't have to fill it
> seperately):
>
> a) contact_address is stored first -> ok
> b) company_address is stored first -> ok
> c) delivery_adress is stored from the data of the company_adress
> d) billing_adress is stored from the data of the company_address
>
> My Java-developer is trying to tell me, that this is not possible. He
> mentioned the following: in part c) Hibernate recognizes, that the
> object which is the most recent is older than the stored version in
> the DB. The same happens when it comes to part d).
> And he mentions that this is a Optimistic Concurrency Control problem.
> (see: http://en.wikipedia.org/wiki/Optimistic_concurrency_control )
> I told him that with ColdFusion, PHP and other scripting languages
> this shouldn't be a problem, since you can store the data in server or
> clientside variables/parameters. He replied, that this isn't possible with
> Hibernate. This irritates me, since it would be a major problem, if
> we have to change the business logic of this shop-feature feature from
> ground up.
>
> Any ideas ? Does anybody know of another good (Java)-forum where I can post
> this question ? Thanks !!
>
> Uwe
>
>
>
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317355
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Creating Web Connector to QuickBooks

2009-01-04 Thread Andy
Updating my wife's business from Peachtree to QB.  Have any of you written a
Web Connector for QB?  They use SOAP.  Are they examples out there that I
can use to short-cut the development?
 
Andy




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317354
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: market rates

2009-01-04 Thread John M Bliss
FWIW, in my 13-year career in the US (most of it spent doing CFML and SQL
Server), I've seen rates of about $40/hr for junior developers up to $200/hr
for senior developers.  (Granted: $200/hr for senior developers was in the
middle of the dot-com-boom in Washington, DC, and it's gone down from there,
but senior CFML/SQL Server people can still live very comfortably.)

On Sat, Jan 3, 2009 at 5:46 PM, Glyn Jackson wrote:

> this question depends on what part the the UK you are. we had someone on a
> contract  on £35 per hour but that was a short contract only 3 months and we
> really needed them. we advertised for someone with 2 years CF experience
> last year to work fully time at our offices, we found it VERY hard to find
> anyone! most stated they had CF experience but after the interview it was
> clear they did not! it took us 3 months to find someone and they started on
> £25k per year in the Midlands in London this would have been around £35k. I
> would say in the UK its 22-38k depending on experience. I have knew a fellow
> CF developer that left us  and got a Job in London on 68k very much open,
> its all up to the person.
>
> I did find that Java developers ask for the same sort of salary if thats
> anything to go by. PHP developers are ten a penny here so thats not a good
> market to compare to, and 2 years + php developer we can get starting at 17k
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317353
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


(ot) Java-Hibernate-problem: Optimistic concurrency control problem, I need a second opinion !

2009-01-04 Thread cf-talk
Hi list,

in our freshly build Java B2B-Shop-Customer-System (build from scratch, based
on Hibernate. Spring etc.) we have
four adresses in the MS-SQL-DB (MS-SQL-2000): contact_address,
company_address, delivery_address, billing_address.

In the end-customer's registration process the following happens (in case the
customer says that the delivery_address + billing address is being
assembled out of the contact/-delivery_addresses and doesn't have to fill it
seperately):

a) contact_address is stored first -> ok
b) company_address is stored first -> ok
c) delivery_adress is stored from the data of the company_adress
d) billing_adress is stored from the data of the company_address

My Java-developer is trying to tell me, that this is not possible. He
mentioned the following: in part c) Hibernate recognizes, that the
object which is the most recent is older than the stored version in
the DB. The same happens when it comes to part d).
And he mentions that this is a Optimistic Concurrency Control problem.
(see: http://en.wikipedia.org/wiki/Optimistic_concurrency_control )
I told him that with ColdFusion, PHP and other scripting languages
this shouldn't be a problem, since you can store the data in server or
clientside variables/parameters. He replied, that this isn't possible with
Hibernate. This irritates me, since it would be a major problem, if
we have to change the business logic of this shop-feature feature from
ground up.

Any ideas ? Does anybody know of another good (Java)-forum where I can post
this question ? Thanks !!

Uwe





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317352
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4