Re: RE: dbcreate set to update, then errors out
Thank you very much. That worked!
Mark, I found this article of yours, but I can't get it to work. I am
getting the error An association from the table musician_instrument refers
to an unmapped class:
Here is the code for Musician.cfc
cfcomponent hint=I am a musician output=false persistent=true
cfproperty name=musicianID hint=The id for the musician
fieldtype=id type=numeric ormtype=integer generator=identity
cfproperty name=name hint=name of the musician type=string
length=255
cfproperty name=age hint=Age of the Musician type=numeric
ormtype=integer
cfproperty name=instruments type=array hint=Array of instruments
singularname=instrument
fieldtype=many-to-many cfc=model.Instrument
linktable=musician_instrument
FKColumn=musicianID inversejoincolumn=instrumentID
orderby=name
/cfcomponent
Here is the code for Instrument.cfc
cfcomponent hint=An instrument persistent=true output=false
cfproperty name=instrumentID hint=id for the instrument
fieldtype=id ormtype=integer generator=identity
cfproperty name=name hint=The instument name type=string
length=255/
cfproperty name=noise hint=the noise it makes type=string
length=255 /
/cfcomponent
In Musician.cfc, it works if I take out this line:
cfproperty name=instruments type=array hint=Array of
instruments singularname=instrument...
I am on CF9.0.1 with MSSQL. What am I doing wrong?
On Sat, Feb 5, 2011 at 3:55 AM, Mark Mandel mark.man...@gmail.com wrote:
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:342135
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
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
Re: Incorrect Perfmon Values in CF9
How did you enabled performance monitoring in the CF Admin? I tried adding the CF9 counters in Perfmon, but all the counters have the ADD button greyed out. On Thu, Aug 26, 2010 at 10:12 AM, WebMastesr Smarte webmastersma...@gmail.com wrote: I upgraded from CF8 Standard to CF9.01 Standard and I enabled performance monitoring in the CF Admin. When I add the CF9 jrun counter for Average Req Time it spikes to over 4 billion basically an overflow. Furthermore, I uninstalled CF9 and removed the CF9 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336589 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Easy Regex question?
Thanks Bobby and Che!
On Mon, Mar 15, 2010 at 6:00 AM, Che Vilnonis ch...@asitv.com wrote:
Carol, I used...
reReplaceNoCase(myHTML, table.*?.*?/table, , ALL)
-Original Message-
From: Bobby Hartsfield [mailto:bo...@acoderslife.com]
Sent: Saturday, March 13, 2010 10:01 AM
To: cf-talk
Subject: RE: Easy Regex question?
Rereplace(html, table.*?/table, , all')
Or
Rereplace(html, table[^]+/table, , all')
-Original Message-
From: Carol F [mailto:cfcn...@gmail.com]
Sent: Saturday, March 13, 2010 1:59 AM
To: cf-talk
Subject: Re: Easy Regex question?
I tried it on:
htmlhead/headbodytexttablewhatever/table/body/html
but it's returning this string in an array
tablewhatever/table
instead of
htmlhead/headbodytexttablewhatever/table/body/html
I guess I can do
arrTable = reMatchNoCase('table[^]+/table', myString);
for(a=1; a = arrayLen(arrTable); a++){
myString = replace(myString, arrTable[a], );
}
but is there an easier way?
On Fri, Mar 12, 2010 at 8:29 PM, andy matthews
li...@commadelimited.comwrote:
Should be able to do this:
REMatchNoCase('table[^]+/table', myString)
-Original Message-
From: Carol F [mailto:cfcn...@gmail.com]
Sent: Friday, March 12, 2010 6:52 PM
To: cf-talk
Subject: Re: Easy Regex question?
do you mind sharing the solution please?
On Fri, Mar 12, 2010 at 1:28 PM, Che Vilnonis ch...@asitv.com wrote:
Scratch that... I figured it out!
-Original Message-
From: Che Vilnonis [mailto:ch...@asitv.com]
Sent: Friday, March 12, 2010 4:25 PM
To: 'cf-talk@houseoffusion.com'
Subject: Easy Regex question?
This should be easy.
How do I remove all text between table/table tags from a larger
string?
Thanks, Che
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331756
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Easy Regex question?
I tried it on:
htmlhead/headbodytexttablewhatever/table/body/html
but it's returning this string in an array
tablewhatever/table
instead of
htmlhead/headbodytexttablewhatever/table/body/html
I guess I can do
arrTable = reMatchNoCase('table[^]+/table', myString);
for(a=1; a = arrayLen(arrTable); a++){
myString = replace(myString, arrTable[a], );
}
but is there an easier way?
On Fri, Mar 12, 2010 at 8:29 PM, andy matthews li...@commadelimited.comwrote:
Should be able to do this:
REMatchNoCase('table[^]+/table', myString)
-Original Message-
From: Carol F [mailto:cfcn...@gmail.com]
Sent: Friday, March 12, 2010 6:52 PM
To: cf-talk
Subject: Re: Easy Regex question?
do you mind sharing the solution please?
On Fri, Mar 12, 2010 at 1:28 PM, Che Vilnonis ch...@asitv.com wrote:
Scratch that... I figured it out!
-Original Message-
From: Che Vilnonis [mailto:ch...@asitv.com]
Sent: Friday, March 12, 2010 4:25 PM
To: 'cf-talk@houseoffusion.com'
Subject: Easy Regex question?
This should be easy.
How do I remove all text between table/table tags from a larger
string?
Thanks, Che
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331723
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Easy Regex question?
do you mind sharing the solution please? On Fri, Mar 12, 2010 at 1:28 PM, Che Vilnonis ch...@asitv.com wrote: Scratch that... I figured it out! -Original Message- From: Che Vilnonis [mailto:ch...@asitv.com] Sent: Friday, March 12, 2010 4:25 PM To: 'cf-talk@houseoffusion.com' Subject: Easy Regex question? This should be easy. How do I remove all text between table/table tags from a larger string? Thanks, Che ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331720 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfscript for cfsetting
I am learning to program using cfscript instead of cf tags. What is the CFSCRIPT equivalent for the CFSETTING tag? Does anybody know if the CF9 Live Docs are going to updated with the new CFSCRIPT equivalents? Thanks! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330142 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfscript for cfsetting
sorry, I saw that page before, but I could not find cfsetting, or is it somewhere buried there? On Tue, Jan 26, 2010 at 10:23 AM, Matt Quackenbush quackfu...@gmail.comwrote: The CF9 docs have had this ever since CF9 was released. http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSe9cbe5cf462523a02805926a1237efcbfd5-7fff.html ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330150 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfscript for cfsetting
Ok thanks everyone! On Tue, Jan 26, 2010 at 12:17 PM, Jason Durham jdur...@cti-stl.com wrote: That link is for the CFML equivalents in CFScript. If it's not there... there is no equivalent. :) -Original Message- From: Carol F [mailto:cfcn...@gmail.com] Sent: Tuesday, January 26, 2010 2:04 PM To: cf-talk Subject: Re: cfscript for cfsetting sorry, I saw that page before, but I could not find cfsetting, or is it somewhere buried there? On Tue, Jan 26, 2010 at 10:23 AM, Matt Quackenbush quackfu...@gmail.com wrote: The CF9 docs have had this ever since CF9 was released. http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSe9cbe5cf462523a02805926a1237efcbfd5-7fff.html ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330160 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
