Re: RE: dbcreate set to update, then errors out
Or you could just call ApplicationStop() or better yet ORMReload().
Mark
Sent from my mobile device.
On 05/02/2011 2:05 PM, Andrew Scott andr...@andyscott.id.au wrote:
Those errors are because you need to stop and restart the Application, the
most effective way is to change the Application name. The reason is that
the
ORM is cached with the Entites, therefore a change will not take place
until
the Application is restarted, hence the errors you are getting.
Regards,
Andrew Scott
http://www.andyscott.id.au/
-Original Message-
From: Carol F [mailto:cfcn...@gmail.com]
Sent: Saturday, 5 February 2011 1:31 PM
To: cf-talk
Subject: dbcreate set to update, then errors out
Hi I'm a noobie with CF and ORM. I'm using SQL Server 2008
I have a test CF app, and I have the ormSettings.dbcreate set to
update,
like so:
this.ormSettings = {
datasource = dsn,
dbcreate = update,
schema = dbo,
logsql = true
};
Here's my Account.cfc
component persistent=true {
property name=id column=AccountID generator=identity;
property name=username;
property name=password;
property name=datecreated;
}
Here's my test.cfm, in cfscript:
ormReload()
x = new Account();
x.setUsername(user1);
x.setPassword(pw1);
entitySave(x);
It was working at first, so I decided to delete the database from the SQL
side
(via Management Studio).
So now, when I reload test.cfm, I get this error:
Error in executing the DDL.[Macromedia][SQLServer JDBC
Driver][SQLServer]Identity column 'AccountID' must be of data type int,
bigint, smallint, tinyint, or decimal or numeric with a scale of 0, and
constrained to be nonnullable.
I tried changing dbcreate to dropcreate, and I get the same error, but
this
new message is there as well:
[Macromedia][SQLServer JDBC Driver][SQLServer]Cannot drop the table
'dbo.Account', because it does not exist or you do not have permission.
How do I get it working again? I tried restarting the service, but that
did not
help. I even recreated the table, and CF dropped it but I still get the
Error in
executing the DDL error.
Thanks!
~~
~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-
Anthology/dp/1430272155/?tag=houseoffusion
Archive: http://www.houseoffusion.com/groups/cf-
talk/message.cfm/messageid:341870
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-
talk/unsubscribe.cfm
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341874
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFImage at 300dpi
But some compassion and empathy can usually go a lng way in helping another weather a storm. And while a job (money) is often a major component of many of life's crisis moments, it almost never the only factor. If this place is truly about community, it has to go beyond code at times... -Original Message- From: Tony Weeg [mailto:tonyw...@gmail.com] Sent: Friday, February 04, 2011 8:25 PM To: cf-talk Subject: Re: CFImage at 300dpi first of all, if he does kill himself, it's no ones fault on this or any other list, don't go blaming yourself. secondly, if he in fact is looking for attention, then he is sicker than I thought to begin with. because, michael, this attention you've gotten now will certainly not help you get a job. For his familys sake I hope he hasn't done that most stupid and selfish thing, but if he has, there was no stopping him anyway. Sent from my iPhone... Don't hate. On Feb 4, 2011, at 7:48 PM, Bryan Stevenson br...@electricedgesystems.com wrote: Yes and I asked Mike D about thisno reply as of yet On Fri, 2011-02-04 at 16:46 -0600, Mark A. Kruger wrote: Anyone else think Mike might be in trouble? -Original Message- From: Michael Firth [mailto:mftr...@att.net] Sent: Friday, February 04, 2011 4:11 PM To: cf-talk Subject: Re: CFImage at 300dpi Life aint worth living anymore. Peace out and goodbye everyone ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341875 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Charge for meetings
Hi All, I have a question; when you guys do consulting or freelance programming, do you charge for meetings? Or do you absorb meeting time into your fees? Thanks, Paul ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341876 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Charge for meetings
I charge per hour. If you want to have a meeting for that time, I charge for it. Talk away. :) Now, the initial meeting, I tend not to charge for. But those I like to keep short and focused. On Sat, Feb 5, 2011 at 2:05 PM, Paul Alkema paulalkemadesi...@gmail.com wrote: Hi All, I have a question; when you guys do consulting or freelance programming, do you charge for meetings? Or do you absorb meeting time into your fees? Thanks, Paul ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341877 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Charge for meetings
Absolutely. Otherwise, the client will use a ton of your time picking your brain and discussing changes. Just make sure they know in advance that you will be charging. On Sat, Feb 5, 2011 at 2:05 PM, Paul Alkema paulalkemadesi...@gmail.com wrote: Hi All, I have a question; when you guys do consulting or freelance programming, do you charge for meetings? Or do you absorb meeting time into your fees? Thanks, Paul ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341878 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Charge for meetings
I follow the same basic rule. No charge on the initial consult, but hourly after that. It helps force the client to prepare and think through why they really want. Sent from my iPhone On Feb 5, 2011, at 4:19 PM, Phillip Vector vec...@mostdeadlygame.com wrote: I charge per hour. If you want to have a meeting for that time, I charge for it. Talk away. :) Now, the initial meeting, I tend not to charge for. But those I like to keep short and focused. On Sat, Feb 5, 2011 at 2:05 PM, Paul Alkema paulalkemadesi...@gmail.com wrote: Hi All, I have a question; when you guys do consulting or freelance programming, do you charge for meetings? Or do you absorb meeting time into your fees? Thanks, Paul ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341879 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Charge for meetings
Completely agree. Once into a project, all the project time is client time; bill accordingly. On 2/5/2011 5:37 PM, Brian Cain wrote: I follow the same basic rule. No charge on the initial consult, but hourly after that. It helps force the client to prepare and think through why they really want. Sent from my iPhone On Feb 5, 2011, at 4:19 PM, Phillip Vectorvec...@mostdeadlygame.com wrote: I charge per hour. If you want to have a meeting for that time, I charge for it. Talk away. :) Now, the initial meeting, I tend not to charge for. But those I like to keep short and focused. On Sat, Feb 5, 2011 at 2:05 PM, Paul Alkemapaulalkemadesi...@gmail.com wrote: Hi All, I have a question; when you guys do consulting or freelance programming, do you charge for meetings? Or do you absorb meeting time into your fees? Thanks, Paul ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341880 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Charge for meetings
I agree with Brian Cane. Jason Durham On Sat, Feb 5, 2011 at 4:37 PM, Brian Cain bcc9...@gmail.com wrote: I follow the same basic rule. No charge on the initial consult, but hourly after that. It helps force the client to prepare and think through why they really want. Sent from my iPhone On Feb 5, 2011, at 4:19 PM, Phillip Vector vec...@mostdeadlygame.com wrote: I charge per hour. If you want to have a meeting for that time, I charge for it. Talk away. :) Now, the initial meeting, I tend not to charge for. But those I like to keep short and focused. On Sat, Feb 5, 2011 at 2:05 PM, Paul Alkema paulalkemadesi...@gmail.com wrote: Hi All, I have a question; when you guys do consulting or freelance programming, do you charge for meetings? Or do you absorb meeting time into your fees? Thanks, Paul ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341881 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Charge for meetings
Hi All, I have a question; when you guys do consulting or freelance programming, do you charge for meetings? Or do you absorb meeting time into your fees? Thanks, Paul ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341882 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Charge for meetings
+1 Remember, if you are a consultant, you are charging for your knowledge and experience. If you do coding that is part of it, so are meetings. A solicitor (or Lawyer) charges all his time. You are also a professional in your field. MD Apologies for the brevity. Sent from my iPhone On 5 Feb 2011, at 23:08, Michael Firth mftr...@att.net wrote: Hi All, I have a question; when you guys do consulting or freelance programming, do you charge for meetings? Or do you absorb meeting time into your fees? Thanks, Paul ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341883 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Charge for meetings
I charge for meeting and drive time, past the initial sell. I then charge extra for in person meetings, so clients don't have me driving all over for something that can handkerchief over email or phone. Sent from my HTC on the Now Network from Sprint! - Reply message - From: Michael Firth mftr...@att.net Date: Sat, Feb 5, 2011 16:08 Subject: Charge for meetings To: cf-talk cf-talk@houseoffusion.com Hi All, I have a question; when you guys do consulting or freelance programming, do you charge for meetings? Or do you absorb meeting time into your fees? Thanks, Paul ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341884 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Lightweight code editor, CF support would be a plus
I'm looking for a good, lightweight code/text editor that I can install on a dev server with limited resources. I'll primarily use it for log files, etc., but there might be the odd instance where I need to directly edit a html of cf file, so support for html and cf would be useful. Any suggestions? And, no, I don't want to use vi. Thanks, Pete ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341885 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Date format in HTML cfgrid
Well, it won't support properly in your SQL solution because you've converted it to a varchar. Pete On Thu, Feb 3, 2011 at 10:13 AM, Steve Sequenzia c...@thinksys.com wrote: I am trying to format dates in an HTML cfgrid. I cannot seem to make it work in CF when using HTML as the grid type. I have also tried doing it in MSSQL by using - CONVERT(VARCHAR(10), startDate, 101) AS startDate. When I do that it shows up right in the grid but the grid will not sort on the date properly. Anyone know of a way to make it show up in the grid in a mm/dd/ format and also sort on the date properly? Any help would be great. Thanks in advance. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341886 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Lightweight code editor, CF support would be a plus
You didn't mention what OS, but if your looking for a Windows editor I'd recommend Emeditor by Emurasoft. It's lightweight, GREAT for log files and has a CF plugin. The plugin is out of date but works in a pinch. - Rod On Sat, Feb 5, 2011 at 8:53 PM, Pete Ruckelshaus pruckelsh...@gmail.comwrote: I'm looking for a good, lightweight code/text editor that I can install on a dev server with limited resources. I'll primarily use it for log files, etc., but there might be the odd instance where I need to directly edit a html of cf file, so support for html and cf would be useful. Any suggestions? And, no, I don't want to use vi. Thanks, Pete ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341887 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Lightweight code editor, CF support would be a plus
Yes, I'm on Windows. Also looking for something that is ideally free. On Sat, Feb 5, 2011 at 10:30 PM, Rodney Enke renk...@gmail.com wrote: You didn't mention what OS, but if your looking for a Windows editor I'd recommend Emeditor by Emurasoft. It's lightweight, GREAT for log files and has a CF plugin. The plugin is out of date but works in a pinch. - Rod On Sat, Feb 5, 2011 at 8:53 PM, Pete Ruckelshaus pruckelsh...@gmail.com wrote: I'm looking for a good, lightweight code/text editor that I can install on a dev server with limited resources. I'll primarily use it for log files, etc., but there might be the odd instance where I need to directly edit a html of cf file, so support for html and cf would be useful. Any suggestions? And, no, I don't want to use vi. Thanks, Pete ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341888 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Lightweight code editor, CF support would be a plus
Editplus is awesome. $30. -Original Message- From: Pete Ruckelshaus [mailto:pruckelsh...@gmail.com] Sent: Saturday, February 05, 2011 9:44 PM To: cf-talk Subject: Re: Lightweight code editor, CF support would be a plus Yes, I'm on Windows. Also looking for something that is ideally free. On Sat, Feb 5, 2011 at 10:30 PM, Rodney Enke renk...@gmail.com wrote: You didn't mention what OS, but if your looking for a Windows editor I'd recommend Emeditor by Emurasoft. It's lightweight, GREAT for log files and has a CF plugin. The plugin is out of date but works in a pinch. - Rod On Sat, Feb 5, 2011 at 8:53 PM, Pete Ruckelshaus pruckelsh...@gmail.com wrote: I'm looking for a good, lightweight code/text editor that I can install on a dev server with limited resources. I'll primarily use it for log files, etc., but there might be the odd instance where I need to directly edit a html of cf file, so support for html and cf would be useful. Any suggestions? And, no, I don't want to use vi. Thanks, Pete ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341889 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SOT - site monitors
I need to automatically monitor about 3 CF sites that run on hosted servers (they're not my boxes). All I need to know is that the site is up - maybe check once or twice a day. I unashamedly admit I don't want to pay for a service if I can. Can anyone recommend anything or alternatively I'm happy to run it off my own box if someone can recommend some code etc TIA! ++ Kevin Parker Advanced Imaging e: webmas...@advancedimaging.com.au w: www.advancedimaging.com.au m: 0418 815 527 ++ http://au.linkedin.com/in/krparker ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341890 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SOT - site monitors
pingdom.com offers a trial service, for some reason I thought they had something free, but they may have changed that. On Sat, Feb 5, 2011 at 10:21 PM, Kevin Parker tras...@internode.on.netwrote: I need to automatically monitor about 3 CF sites that run on hosted servers (they're not my boxes). All I need to know is that the site is up - maybe check once or twice a day. I unashamedly admit I don't want to pay for a service if I can. Can anyone recommend anything or alternatively I'm happy to run it off my own box if someone can recommend some code etc TIA! ++ Kevin Parker Advanced Imaging e: webmas...@advancedimaging.com.au w: www.advancedimaging.com.au m: 0418 815 527 ++ http://au.linkedin.com/in/krparker ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341891 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: SOT - site monitors
Just did some more digging - stumbled across http://www.alertra.com - 95c a month/URL for what I want to do - I'm not so tight I can't afford that :-) Has anyone sued this service at all or can recommend one like it TIA ++ Kevin Parker Advanced Imaging e: webmas...@advancedimaging.com.au w: www.advancedimaging.com.au m: 0418 815 527 ++ http://au.linkedin.com/in/krparker -Original Message- From: Kevin Parker [mailto:tras...@internode.on.net] Sent: Sunday, 6 February 2011 16:21 To: cf-talk Subject: SOT - site monitors I need to automatically monitor about 3 CF sites that run on hosted servers (they're not my boxes). All I need to know is that the site is up - maybe check once or twice a day. I unashamedly admit I don't want to pay for a service if I can. Can anyone recommend anything or alternatively I'm happy to run it off my own box if someone can recommend some code etc TIA! ++ Kevin Parker Advanced Imaging e: webmas...@advancedimaging.com.au w: www.advancedimaging.com.au m: 0418 815 527 ++ http://au.linkedin.com/in/krparker ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341892 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: other companies and developers to watch out for
Mike D, that's terrible news about your cousin.. I hope you and her parents find some peace and comfort.. and you so didn't need certain people's drama right now.. you know your online peeps are here if you need us On Fri, Feb 4, 2011 at 4:26 PM, Michael Dinowitz mdino...@houseoffusion.com wrote: Guys, I was busy with a funeral for my young cousin and didn't come down on this thread like I should have. One word here: STOP Stop with the fighting, the threats, the personal attacks, the various actions that have caused some people to leave this list. Stop now or I'll start banning people left and right. I'm trying to provide a resource for the community but if all it does is lead to flames and all then I'll just drop this list. I don't want to but all of this is harming much more than you, it's harming me, your fellow community members, and the ColdFusion itself. If people do a search for ColdFusion jobs and sees the stuff that's coming up on this list, they'll run for their lives. I'm going to ask this one more time. Lets keep this professional. Thank you Michael Dinowitz ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4460 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-jobs-talk/unsubscribe.cfm
