I wrote:
A client asked me to see if I could get a copy of his old web site up
and
running. I did a restore of the backed up database onto my PC. The
problem is that all the table names have the name of the database
prepended
to them.
When I view the tables in SQL Server
hello fellow cftalkers,
i have changed my dev environment to a CF8 multi-server setup, and then
installed CF9 as an instance in it.
cf8 instance has context root set to /, and cf9 is set to use /cf9
context root.
this all is on Win XP with Apache 2.2 as web server.
while everything else seems
I didn't see a mention of which version of SQL Server you're running,
but it sounds to me like canadianofficespacecom is either an object
owner or a schema:
http://www.sqlteam.com/article/understanding-the-difference-between-owners-and-schemas-in-sql-server
I'm assuming that it's most likely
but it sounds to me like canadianofficespacecom is either
an object
owner or a schema:
+1
That would make more sense than being part of the actual table name.
~|
Want to reach the ColdFusion community with
I have a loop which counts, I need to detect multiples of 6 i.e
loop count
is it a multiple of 6? true
else do nothing
is there a tag that does this?
~|
Want to reach the ColdFusion community with something they want? Let
Hello.
I was ask to help build a dynamic website for a volunteer fire department were
they could add news and photos. Iâm having trouble with the photos. Does
anybody know of a free or paid website were I can find some coldfusion code to
add, edit, update, and delete images. I would like to
You can use the modulus operator (ie MOD)
cfif someNumber MOD 6 EQ 0
the number is a multiple of 6 .. or the value is 0
/cfif
~|
Want to reach the ColdFusion community with something they want? Let them know
on
The following will only execute the stuff inside the CFIF statement if the
count is *not* a multiple of 6.
cfloop from=1 to=96 index=i
cfif i mod 6
!--- do whatever you need to ---
/cfif
/cfloop
~|
Want to reach the
i have changed my dev environment to a CF8 multi-server setup, and then
installed CF9 as an instance in it.
cf8 instance has context root set to /, and cf9 is set to use /cf9
context root.
this all is on Win XP with Apache 2.2 as web server.
In general, I would recommend that you install CF
thanks for your answer, Dave!
setting up virtual Apache servers - something tells me it is not the
same as vhosts, is it?
but google seems to think it is... could you point me to where i can
find more info on how to set them up?
if it is same as vhosts, then that's how i have it set up, too.
i
This is an actual mail server though correct? My mail server is not the
issue it spools out fine. It's the CF Spooler that is my bottleneck.
-Original Message-
From: Erik-Jan Jaquet [mailto:erik...@toomba.nl]
Sent: Thursday, December 10, 2009 10:44 AM
To: cf-talk
Subject: Re: Faster
try googling cfimage, or if you like learning by example, download galleon
forums and play around with the avatar uploader. i'm sure there are more (and
possibly better) examples but it's the first thing that comes to mind
Hello.
I was ask to help build a dynamic website for a volunteer
Hi, Barry...
Did you ever get any private response for your image-handling issue?
(I see that no one has responded publicly...)
Rick
-Original Message-
From: Barry Mcconaghey [mailto:bmcconag...@gmail.com]
Sent: Friday, December 11, 2009 7:55 AM
To: cf-talk
Subject: Working With
setting up virtual Apache servers - something tells me it is not the
same as vhosts, is it?
but google seems to think it is... could you point me to where i can
find more info on how to set them up?
Yes, it's the same. You have to put the instance-specific JRun
directives in each vhost,
Hi all, I understand the gist of cftransaction, but I've tried using it with a
conditional rollback on an action page in the below example and it doesn't seem
to work. saveDataToDatabase() submits data to a stored procedure, which always
returns a string: empty string if the data was saved, or
Hmm, what's the chance the extra part isn't really the database name,
but it is the owner name. Kind of like the default owner is dbo and your
full path to a table is database.dbo.tablename. Perhaps it is
databasename.somethingyoudontpect.tablename. Perhaps you need to look
at altering the
that's exactly how i have it - a different jrun directive in the cf9 vhost.
this is in my httpd.conf:
IfModule mod_jrun22.c
JRunConfig Verbose false
JRunConfig Apialloc false
JRunConfig Ignoresuffixmap false
JRunConfig Serverstore D:/JRun4/lib/wsconfig/1/jrunserver.store
I'm pretty sure the rollback is not occurring because your cfstoredproc call
inside your saveDataToDatabase() function is running in it's own
transaction. I think you'd need to include a rollback; command inside
your stored procedure if you have a failure.
Dave
-Original Message-
From:
Yes, google cfimage and check out the google docs, etc.
After checking that out, let me know if you need any more
assistance understanding how to put it all together.
Rick
-Original Message-
From: Jessica Kennedy [mailto:police_kidnapped_your_child...@yahoo.com]
Sent: Friday, December
The way the code is written, the cfif will never be true because it will always
have br in so the length will never be below 4.
Hi all, I understand the gist of cftransaction, but I've tried using
it with a conditional rollback on an action page in the below example
and it doesn't seem to
Barry,
Try installing this product I built. It handles single level categories and
uses fckeditor for editing the image description but also does sorting, crop,
rotate, many categories to one image relationships, etc. It also works with
mysql and mssql.
Nevermind, I read the cfif backwards. I was thinking it was looking for an
empty string. In that case, the cfif will always be true. This doesn't
explain the rollback issue, but once the rollback is fixed, it will always
rollback.
Do you have any commits in your stored procedure? If so,
that's exactly how i have it - a different jrun directive in the cf9 vhost.
Set up separate vhosts for each. Each should have its own settings.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our
i went and manually edited the context-root setting in the instance's
jrun-web.xml and all is good now!
trying to set context root to / in JMC did not work, but manually
editing jrun-web.xml did the trick. strangely, though, in JMC now the
instance's context root appears just empty, not / ...
Good catch - you're right; I would normally include a cfif to append the return
string and the br to allReturnMessages only if the return string isn't
empty.
The stored proc was written by someone else, so I'm not 100% sure what's
happening with it, which is part of the problem. I suppose
yea, i do have a separate named vhost set up for each website.
but you do not need separate jrun settings for each vhost - only for
those that must use a server instance different from the global one
defined in httpd.conf
(in my case all my other sites use a cf8 instance; only one uses cf9 for
I've never used the Windows SMTP service for this, anyone know
if it runs multiple threads and how configurable it is?
It does, and it's smoking fast. As for configurable, it takes mail and
sends it out, not a lot of options there. It does give you some control
over where to copy bounces to,
This is an actual mail server though correct? My mail server is
not the issue it spools out fine. It's the CF Spooler that is my
bottleneck.
Bypass it. Some mail servers have a place where a message file can be
written or copied to and it will pick it up and process it. The Microsoft
SMTP
So all I would need to do is recreate the txt file that is
those .cfmail files or is there more to it than that?
Thanks,
Patrick J Hedgepath
Pegasus Web Productions
webmas...@pegweb.com
(803)-996-0578
On Dec 11, 2009, at 2:11 PM, Justin Scott jscott-li...@gravityfree.com
wrote:
This is
There is more to it than that. Javamail translates the spooler file into
smtp commands which result in the file on the SMTP server. Get ahold of one
of the .eml files from the /queue directory of the IIS SMTP server..
That's the one you need to emulate.
-Mark
Mark A. Kruger, CFG, MCSE
(402)
So all I would need to do is recreate the txt file that
is those .cfmail files or is there more to it than that?
Those are formatted specifically for ColdFusion. Most mail servers want a
.msg file formatted with all of your usual headers, one per line, then two
line breaks and the message
The way the CFTransaction tag works is CF is putting the TRANSACTION statements
in the T-SQL it sends to the server. So the rollback tag will rollback any
transactions that haven't been committed. You could have 100's of queries
running with Inserts/deletes/updates and everything will
I suppose what I should be asking is - is it even possible
to do what I'm trying to do?
Yes. Unless, as someone else mentioned, the procedure you are calling is using
its own transaction. Is it?
-Leigh
~|
Want
Hi Rick.
I already tried googling cfimage but I have been unsuccessful in finding any
good CRUD with CF8 Images.
Barry
Yes, google cfimage and check out the google docs, etc.
After checking that out, let me know if you need any more
assistance understanding how to put it all together.
Erik,
You said
We're using Infusion Mail server for this kinf of thing. Works really
well and its really fast.
When was the last time you were able to contact **anyone** at infusion? As
far as I know they are no longer in business and its impossible to reach
anyone there. I am also using
Recap of problem: I imported an old, backed up SQL Server file. Now, when
I view the tables or try to access them in CF, it requires me to prefix all
table names with canadianofficespacecom..
Ezra Parker wrote:
I didn't see a mention of which version of SQL Server you're running,
but it
I'm tired of writing form input validation routines over and over again.
Using CFINPUT and its validation options work great for the front end, but
it's still a pain to write input validation on the server-side, and the
rules between the two can get out of sync, and the built-in validation rules
I like it in principle but what is your idea of ajax based server side
validation... Server side validation needs to always be done prior to the
server uitlizing the inputs (inserting into the DB etc). You can't validate
using an ajax request and THEN submit the form values using a submit
I haven't tried these but they may be what you are looking for
http://www.validatethis.org/
http://www.validatethis.org/http://thor.riaforge.org/
http://thor.riaforge.org/
2009/12/12 Justin Scott jscott-li...@gravityfree.com
I'm tired of writing form input validation routines over and over
I like it in principle but what is your idea of ajax based
server side validation... Server side validation needs to
It would use JavaScript to push the form data to a validation routine on the
server before the form is posted to give the user a better experience as a
preferred method. If
The app can do both. The idea is to write one set of server-side
validation routines in CF. The app then uses AJAX to check fields as
the used fills them out, for the benefit of the user; it also checks
them server side on submission to ensure data integrity and prevent
circumvention of the
I haven't tried these but they may be what you are looking for
http://www.validatethis.org/
That looks very promising and similar to what I had in mind. I certainly
don't want to reinvent the wheel if this does what it appears to say it
does. I'll check it out over the weekend and post back.
Got... Clever. I see exactly what you are getting at. The use of ajax for
client side makes the validation run the exact same routines.
Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com
-Original Message-
From: James Holmes
On Fri, Dec 11, 2009 at 2:53 PM, Larry Soo l...@bc4x4.com wrote:
So would I be correct in assuming that
the problem I'm having is that the default schema for dbo is master
instead of canadianofficespacecom?
I believe so, yes. In order to resolve this from the user side of
things you're going
44 matches
Mail list logo