Hi Bud
In SQL Server, it's
SELECT T1.*, T2.*, T3.*
FROM Table1 T1
LEFT OUTER JOIN table2 T2 ON T1.ID = T2.ID
LEFT OUTER JOIN table3 T3 ON T1.ID = T3.ID
LEFT OUTER JOIN table4 T4 ON T1.ID = T4.ID
WHERE (whatever)
Other DB's may differ,
Isn't as simple as
cfoutput
b#ProductFamily#/bi#ProductFunction#/i
/cfoutput
or have I missed the point completely?
Do you possibly mean that the entry in the DB is e-terracontrol?
Like Donnie said, when you do find a solution, separate them in the db and
change your code.
Ade
watch out for wordwrap:
cfset formattedProduct = rereplacenocase(this, (e-terra)([[:alnum:]]*),
b\1/bi\2/i, ALL)
-Original Message-
From: William H. Bowen [mailto:[EMAIL PROTECTED]]
Sent: 18 May 2002 00:17
To: CF-Talk
Subject: Find a string and then italicize all after to next
sorry, missed the bit about up to the next chr(32) (space)
this'll work:
cfset formattedProduct = rereplacenocase(this,
(e-terra)([^[:space:]]*[:space:]), b\1/bi\2/i, ALL)
-Original Message-
From: Rich Wild
Sent: 20 May 2002 11:16
To: '[EMAIL PROTECTED]'
Subject: RE: Find a
**
WESTMINSTER CITY COUNCIL
Please refer to the disclaimer beneath this message
**
Hi,
Is it possible, and if so how can you open a MS Word document from a
I want to output all records in a table where a certain field is
duplicated at least once. My first instinct is to filter in the SQL -
but how?! I'm using Access 2000, and the field in question is VARCHAR.
DISTINCT doesn't *seem* to support being negated with NOT, and anyway,
isn't it only
On 5/19/02, Eric J Hoffman penned:
LEFT OUTER JOIN mycarinfo on mycust.id = mycarinfo.custid
JOIN mycarmodel on mycarmodel.id = mycarinfo.carmodel
JOIN mycarmake on mycarmake.id = mycarinfo.carmake
WHERE blah
/cfquery
Does that make sense? We are joining onto multiple tabels from our main
one,
- Original Message -
From: Philip Arnold - ASP [EMAIL PROTECTED]
If you want only the multiples, then why not try grouping?
Select myField
From myTable
Group by myField
Where count(myField)1
I actually need each record listed, if there are duplicates in a
I'll second that! TopStyle seems to be a real progression
from HomeSite
in the thoughtfulness of its design. If Nick's got the spare
time, give
him a team and a budget and make Macromedia Coder MX the
hand-coder's
dream. It has always had a market beyond CF coders, too.
It looks like Nick
Does anyone know if PHP has good built-in email handling? How does it
compare to CFMAIL?
A client is considering having the mailing section on a CF site handled
with PHP cos they've heard about problems with CFMAIL. Could anyone
outline the precise nature of these problems? Their host's using
Thanks for the insight. I never would have thought of considering the difference
between parsing and executing in this case. It works correctly now.
Thanks everyone for their ideas.
Mike Mertsock
Date: Mon, 20 May 2002 12:28:08 +1200
From: James Sleeman [EMAIL PROTECTED]
Greetings,
is it at all possible to keep a page in the browser displaying a loading
message
while CF server is compiling and returning the requested template,
I've got a view ideas knocking about in my head but unawares if they will
work,
any ideas would be appreciated,
respectfully,
j
I think there are several ways to do this... Flash, Javascript, hidden
frames but how long do you anticipate your results to take?
Remember that showing the result could take 1sec, and showing a Please
Wait message for a tik would be a tad overkill..
Neil Clark
Team Macromedia
I've been having mail server problems so I may have missed any
suggestions. I've made no progress except for the fact that I know the
command has to be called as
something.Replace (, '... )
But beyond that I'm lost. Anyone have any ideas? Comet.com has some
excellent examples but I can't
How can I programmatically change a stylesheet class via JavaScript? I'd
like to change the background of a text box from white to red if some form
validation fails. I've seen it done before, but haven't been able to track
down the code to do it.
Thanks,
Dave.
Oh, definately 10 to 20 seconds,
a customer can manipulate reports from the query object,
for instance,
actual hours worked over a date range would return the hours worked for
each day, average for the duration,
then a driver idling report, a stopped report, a location report and so on,
the
Yes, you can change a CSS style by using Javascript, I cant remember off
the top of my head exactly how but it can be done by referencing the
objects style (or BG) and colour.
item.style.color='#4d4d4d';
and then asking it to change it on mouseover/mouseout.
- Original Message -
From: Dave Carabetta [EMAIL PROTECTED]
How can I programmatically change a stylesheet class via JavaScript? I'd
like to change the background of a text box from white to red if some
form
validation fails. I've seen it done before, but haven't been able to
track
down
Is your form validation done in CF or JS?
-Craig
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Sounds like a job for CFFLUSH to me,
Jb.
-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]]
Sent: 20 May 2002 14:06
To: CF-Talk
Subject: RE: keeping a loading page in the browser
Oh, definately 10 to 20 seconds,
a customer can manipulate reports from the
The other day I talked to our DBA about some deadlocks and she started to
look for them... And found a whole bunch of deadlocks in the CFGLOBAL table.
Those are row level locks and if she didn't start looking for them, I would
never take notice that those were happening.
Does anyone know why I
document.getElementById('textBoxId').className = 'class';
Dave Carabetta wrote:
How can I programmatically change a stylesheet class via JavaScript? I'd
like to change the background of a text box from white to red if some form
validation fails. I've seen it done before, but haven't been
Hello All:
Could someone please tell me how to list all the .txt files when you
want to check the server your logging onto using CFFTP? Is it possible
to filter or query some how?
Thanks,
James Blaha
CFFTP CONNECTION=FTP2HOST
USERNAME=anonymous
PASSWORD=guest@unknown
SERVER=testsvr
Is your form validation done in CF or JS?
-Craig
Actually, both...But I'm looking to change the style when I do the JS
validation up front. The CF validation is really just my fall-back should
the user have JS disabled or something.
Thanks,
Dave.
have I have no idea why this happened, but all of a sudden cfmail fails
every time it send out an email. I'm using the smtp service that comes with
IIS to send out mails. Seems that every time an email is sent it goes right
into the badmail directory. The error that is sent into the badmail
Someone on the list posted the core of this code last week - I'll pass
it along in Tag format.
This basically bypasses CFMAIL and dumps mail straight into the mailroot
spooler.
Thanks to whomever that was that posted the CFFILE code, you're my new
best friend!
!---
Have they heard or have they experienced CFMAIL problems?
PHP has good mail handling depending on what you mean.
On Mon, 20 May 2002, Gyrus wrote:
Does anyone know if PHP has good built-in email handling? How does it
compare to CFMAIL?
A client is considering having the mailing section
cameron childress presented a similiar solution at cfnorth a couple of weeks
ago
(cameron, aren't you lurking here somewhere?)
he suggested that due to the nature of the spool folder (its constantly
being polled for new files) its best to write the files in batches in a
different folder, and
We recently launched an app that uses LDAP. It's a phone directory. Since
its release we have had problems with CF locking up. Anyone know if LDAP is
a CF resource hog?
James
__
Your ad could be here. Monies from ads go to
Have they heard or have they experienced CFMAIL problems?
They've never had anything doing more than a few (30) mails at a time.
It's just the poor reputation that CFMAIL has - they're wanting to go
with something more stable (?) from the start for this site for
scalability.
PHP has good mail
forgot to mention this, but the first thing I did was go through my cf-talk
archives and try the code that writes directly to the pickup directory. get
the same results, immediatly I get badmail errors. I guess what I'm
basically looking for is not a cf solution but a windows error solution.
From: Petruzzi, Tony
Sent: Sunday, May 19, 2002 6:21 PM
To: CF-Talk (E-mail)
Subject: cfmail error question
have I have no idea why this happened, but all of a sudden cfmail fails
every time it send out an email. I'm using the smtp service that comes
with IIS to send out
the query time is slower than hitting a regular db, how large are your queries? how
powerful is your ldap server?, whats the network connection to it like? this things
can cause a ldap query to be significantly slowedand may cause cf to lock up on
rare occasions.
[EMAIL PROTECTED]
Hello All,
I'm trying to develop a way to differentiate between a new record or the
editing of a previous entered record using a single template. The user
clicks on the link which passes the variable ID to the template for the
cfif new and cfelse edit - but can only get one portion of the
I'm not really sure of this, but a switch statement will be broken out of
once a match/condition has been made.. I think you can have multiple
conditions for a block though. Any chance of some code?
-Original Message-
From: Ben Covington [mailto:[EMAIL PROTECTED]]
Sent: 20 May 2002
is there any other variables distinguishing between a new and an edit? if
not you should try passing a type variable that does.
Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org
-Original Message-
From: Ben Covington [mailto:[EMAIL PROTECTED]]
Sent:
Does anyone know if PHP has good built-in email handling? How does it
compare to CFMAIL?
How much volume are they looking at?
I'm not a PHP junkie, but I would assume there's more work involved with
sending mail from PHP than CF. CFMAIL is fairly safe if used on a
low-volume basis in my
You see on the join stuff...they all are being done to the table
mycarinfo...So table 2,3, and 4 are all being joined on table 1.
We run on SQL, and if we used LEFT OUTER JOIN on each instance, it
crapped. Couldn't figure out why, but this works swimmingly and returns
the info we need if there
I diferentiate by looking at the id. For a new item, its blank or not
defined so isnumeric(id) or isdefined(id) tells you whether your editing
or adding the entry.
However, I am a bit confused as to your wording can only get one portion of
the template to show at a time? Does that mean you
From a previous post I know that CF5 could be run in distributed mode, and
that this was only done to satisfy security requirements. Well that's what I
need to do.
But I wondered what the process might be to manage this for MX?
I assume it must be a different process. Can't find anything in the
I know this is OT, but I've seen some SQL on this list lately, so I figured
I ask:
Let's say I have this query:
Col1Col2Col3
1 a 10
2 b 11
3 c 12
4 d 13
5 e 14
6 f 15
But I'd like to add a column to this
I've thought of that, but there should be a way of checking the table
for the record and then running the cfif cfelse code?
In my frustration yesterday I deleted the code for the cfswtich cfcase,
but it was something like Location_ID IS NOT Location_ID, Location_ID IS
Location_ID - pretty much
Queries can be based off individuals, or by letter (i.e. all beginning with
A) or by department. The data contains about 1200 names, phone numbers,
emails and street addresses. Not sure about answers to the other questions
since I am not the one who developed the app.
-Original Message-
do a google search on alter table
-Original Message-
From: Ryan Pieszak [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 9:13 AM
To: CF-Talk
Subject: OT (SQL): Add column to query?
I know this is OT, but I've seen some SQL on this list lately, so I figured
I ask:
Let's say I have
Do you want it in the table, or just in the returned query?
Jerry Johnson
[EMAIL PROTECTED] 05/20/02 11:12AM
I know this is OT, but I've seen some SQL on this list lately, so I figured
I ask:
Let's say I have this query:
Col1Col2Col3
1 a 10
2 b 11
3
ALTER TABLE table_name
ADD column_name datatype
Or
ALTER TABLE table_name
DROP COLUMN column_name
-Original Message-
From: Ryan Pieszak [mailto:[EMAIL PROTECTED]]
Sent: 20 May 2002 16:13
To: CF-Talk
Subject: OT (SQL): Add column to query?
I know this is OT, but I've seen some SQL
Are you referring to form reuse? You would like to write one form lets say,
if it's new it displays something's different than if it is editing an
existing record?
We normally will key off of 0. If ID gt 0 then you are editing else your not
editing. Then at the top of the template you param id
No you are right, I don't want to see both at the same time. The
template is working but not displaying the form. I have tried the
IsDefinded but I did not leave it blank, and have not tried the
isnumeric. I will take another look at this.
Thanks, Ben
-Original Message-
From: Andre
just in the returned query
-Original Message-
From: Jerry Johnson [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 11:31 AM
To: CF-Talk
Subject: Re: OT (SQL): Add column to query?
Do you want it in the table, or just in the returned query?
Jerry Johnson
[EMAIL PROTECTED]
I have seen this in MySQL editors, but does MS SQL have an export feature that will
export the table structures and such or an export that builds the CREATE TABLE syntax
for a list of tables.
Any help would be great!
Paul Giesenhagen
QuillDesign
This physically alters a table not a query - do you mean table or query
Ryan? - if you mean query then just add the column name to the table. If
you mean table then I try to steer clear of Alter table. What I tend to do
is write an SP which creates a temp table of the old structure of your
I think he doesn't want to alter the table... just the results.
And it's not during the query, it's after you get the results... right?
Otherwise you could query like
select col1, col2, col3, '24' as myCol from mytable
-Original Message-
From: Andre Turrettini [mailto:[EMAIL PROTECTED]]
Look for the CF_Processing tag in the DevExch
http://devex.macromedia.com/developer/gallery/info.cfm?ID=CA347514-2830-11D4-AA9700508B94F380method=Full
Randy Adkins
[EMAIL PROTECTED] 05/20/02 09:06 AM
Oh, definately 10 to 20 seconds,
a customer can manipulate reports from the query object,
Sorry, I'm not real good with SQL
I assume I can treat this query as a table, but how do I know the name of
it?
And how can I tell is what data to put into this added column?
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 11:26 AM
To:
1 as column name
-Original Message-
From: Ryan Pieszak [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 11:29 AM
To: CF-Talk
Subject: RE: OT (SQL): Add column to query?
just in the returned query
-Original Message-
From: Jerry Johnson [mailto:[EMAIL PROTECTED]]
Sent:
yeah i think it's called generate sql scripts or something like that...
enterprise manager
-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 11:31 AM
To: CF-Talk
Subject: OT: MS SQL - Exporting table structures
I have seen this in MySQL
this is exactly right, just the query, not the table, and after I get the
results. thanks for clarifying.
-Original Message-
From: Hoag, Claudia (LNG) [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 11:30 AM
To: CF-Talk
Subject: RE: OT (SQL): Add column to query?
I think he
Hi,
My challenge of the week is to provide automated forwarding services to
URL's that return a File not found 404 error. This would act as a sort of
switchboard that, whenever a 404 error was encountered, a query would be
run against a database for the requested URL, and if there were a new
well, you could copy the resultset to a new structure and add your fake
column to the structure, and use the structure instead of the query
resultset. I don't think you can simply add your fake column to the
resultset, even though it is a structure.
-Original Message-
From: Ryan Pieszak
And just to make his option set complete, he could add a column to the query AFTER it
is returned to CF.
cfset myColFiller=arrayNew(1)
cfset temp=ArraySet(myColFiller, 1, myQuery.recordCount, '24')
cfset temp=QueryAddColumn(myQuery, 'myCol', myColFiller)
Again, this is not the best way.
Hi Bill,
It Seem that Same Primary Key Value is been inserted.You can do like
this.Prior Inserting You make a check if it is existing Give a message that
already existing else go with insertion.This way there is no chance of
Inserting on Refreshing the page also.
With Regards
Nagaraj.A
-
The error you are getting suggests that your PK value is not unique for the
row that you are inserting into tblBenefit. Are you using IDENTITY on
the PK for that table, or are you inserting the value from the SP?
--
Scott Van Vliet
Sempra Energy
555 W. 5th St., 21st Floor
Los Angeles, CA 90013
QueryAddColumn(query, column-name, array-name)
Check the CF Docs :)
-Original Message-
From: Ryan Pieszak [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 11:39 AM
To: CF-Talk
Subject: RE: OT (SQL): Add column to query?
this is exactly right, just the query, not the table,
Tim,
Thanks for the reply, and thanks for the great example! I want to
direct the user to different forms, the new form has dropdowns and the
edit form does not. Is there a way to incorporate the different forms
into the cfif statement?
Best regards, Ben
-Original Message-
From:
How much of a performance hit is this? It's probably quicker doing it is
sql, right? The piece of code I'm working on isn't going to be used
regularly, so I could see this cf snippet being a good option. I'll
implement this and see if it truly affects performance. Thanks, everyone,
for the
I should explain my process a little better:
I'm calling a stored procedure from CF. This first SP calls a second SP
which does the query. This query is then returned back to CF (through the
initial SP?) with the CFPROCRESULT. I want to somehow intercept this
returning query in the first SP
I'm having an issue
Error,TID=361,05/20/102,10:54:12,ODBC Error Code = 23000 (Integrity
constraint violation)P [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of
PRIMARY KEY constraint 'PK benefit'. Cannot insert duplicate key in object
'tblBenefit'.PP SQL = sp_newmeal
Heres whats
Hi everyone,
Might be an easy problem for everyone else but having some problems due to
not knowing Flash well.
I'm sending a variable into a Flash movie. The variable is a ordered
record set. Problem is after each field I need to put in a line break.
cfsetting ENABLECFOUTPUTONLY=yes
cfset
You assume wrong, my man.
PHP is super-easy to use for mail. Connects right up to SMTP, no problem.
http://www.php.net/manual/en/function.mail.php
Works exactly how one would expect.
-- jon
-
jon roig
senior manager, online production
epilepsy foundation
phone: 215.850.0710
Does anyone know why I get row level deadlocks in CFGLOBAL and what are the
implications of that?
The other day I talked to our DBA about some deadlocks (not related to
CFGLOBAL) and she started to look for them... And found a whole bunch of
deadlocks in the CFGLOBAL table. Those are row level
Thanks for the link. DLing the .fla right now.
I'm loading it up into a movie and outputting it.
We had originally passed it to the Flash movie as separate variables with
the row number as the part of the variable name.
Unfortunately the part of the movie we are outputting it is a
- Original Message -
From: jon [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, May 20, 2002 4:58 PM
Subject: RE: CF vs. PHP email handling
You assume wrong, my man.
PHP is super-easy to use for mail. Connects right up to SMTP, no
problem.
Either the generate scripts function or my experience is very limited.
The scripts contain object ID references that seems to be specific to the
SQL Server that generates the scripts.
Additionally, don't expect the scripts to work on other RDBMs, such as
MySQL or Oracle.
It might be useful
You assume wrong, my man.
PHP is super-easy to use for mail. Connects right up to SMTP, no problem.
http://www.php.net/manual/en/function.mail.php
Works exactly how one would expect.
Ah, very nice. I stand corrected. My experiences with PHP have not been
very successful, so I tend to
Client variables use a cookie to look up the client value from the database,
so it is possible and I imagine cfglobal table gets a lot of Update or
Select/Insert (I'm not sure how CF handles updating that table) queries
under load.
You might want to go into the CF admin and just disable global
Can you put in a site-wide error handler in CF admin? If so that would
let you code in pretty much anything you want. I just reroute to the
current domain's index.cfm, but there's no reason you couldn't do
something more complex/useful.
--Matt Robertson--
MSB Designs, Inc.
I, for instance, have a list of 17,000 people in a database who need to
receive an email every week or so. There are two main issues for me, anyway:
1) CF does not run in the command line, so everytime I invoke it, I have to
go to a URL to send the mail. Even with the page timeout set to like 30
Thanks, I didn't realize that's all it was storing in CGLOBAL :)
-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 12:38 PM
To: CF-Talk
Subject: Re: deadlocks in CFGLOBAL
Client variables use a cookie to look up the client value from the database,
1) CF does not run in the command line, so everytime I invoke it, I have
to
go to a URL to send the mail. Even with the page timeout set to like 30
minutes, this is a somewhat dubious experience. PHP, on the other hand,
can
run right from the command line for an unlimited amount of time.
Actually I have to to CHECK if its there and if its there to UPDATE and if
its not their to INSERT
but its throwing the damn error i guess the SERIALIZE ISOLATION level doesn
not do what it says
it says its supposed to keep those rows locked until the transaction is
completed
Bill Wheatley
Well the value is not unique becuase the key is on
MEALID and MEALTIME which is like 1 = monday time = 1(breakfast)
i just was reading about that serialize isoloation level and thought that
should do the trick
Bill Wheatley
Senior Database Developer
Macromedia Certified Advanced Coldfusion
Strange. Deadlocks most often happen when you have code that updates one
row in the DB based on info from another row. Example:
UPDATE cellGlobal
SET myVar = (SELECT myVar from cellGlobal WHERE foo = 1)
WHERE foo = 2;
This code is dangerous because it could cause deadlocks... what if it's
how do you have the table setup? what column and default are you using for
your PK? if you are using the two columns to form a PK, then you would get
this error because, like you said, the values aren't unique. personally i
always use uniqueidentifiers as PK and set the default of the column to
Error Diagnostic InformationODBC Error Code = S1000 (General error)
[MERANT][ODBC Oracle 8 driver][Oracle 8]ORA-01461: can bind a LONG value
only for insert into a LONG column
SQL = Insert into Reports (RID, Job_Num, Job_Name, alias_name,
report_date, report_body, First_Name, Last_Name)
In addition to what Jon suggested you may want to consider implementing the
UUIDToken solution described here:
http://www.macromedia.com/v1/Handlers/index.cfm?ID=22427Method=Full
It helped our site when we were seeing Session/Client variables being
improperly shared by different users as you
We use CF5 in distributed mode at the moment...and we're moving to CFMX. I
can't confirm 100% but all you have to do is configure the apache module to
farm out all jsp/cfm/cfc requests to the app server IP address rather than
localhost:55000 or whatever it is normally.
As for IIS configuration
Jim,
Short answer no with an if. Long answer yes with a but. just kidding ;)
You can certainly create and index which contains multiple columns. Whether
or not you want to do this is another topic completely.
There are alot of questions which you need to answer to properly index a
table.
Checkout the JRun install guide, should give ya the answer!
http://livedocs.macromedia.com/jrun4docs/
-Original Message-
From: Stacy Young [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 1:36 PM
To: CF-Talk
Subject: RE: MX in distributed mode?
We use CF5 in distributed mode
Ok I was curious myself ;)
http://livedocs.macromedia.com/jrun4docs/JRun_Administrators_Guide/connector
s4.jsp#1124835
I believe you should be able to manually edit an equivalent file on the CFMX
install.
Stace
-Original Message-
From: Stacy Young [mailto:[EMAIL PROTECTED]]
Sent:
has CFMAIL improved in 4.5, 5, MX?
It's marginally better in later versions, up to 5, than in CF 4.
However, it should be much, much better in CF MX, which uses the java.mail
API instead of the code that Allaire/MM wrote themselves to interface with
SMTP. In addition, CF MX supports spooling
thanks.. That helps...
All of my ID's are Primary Keys in their respective tables. ( i left out
attorney_ID (PK) in my example)
I assumed I should create indexes for all of the foreign keys within a table
as well as all of the fields I search on, but just wanted to double check.
All of my
That's not the only situation where you get deadlocks. On Friday we were
discussing that, and the problem then was due to page locks in MSSQL.
The deadlocks in CGLOBAL are at row level, and I see now what that has to do
with the mixing client variables. People probably sent out URLs with their
try using a CFTRANSACTION like this...
cftransaction
cfquery name=
EXECUTE sp_newmeal
/cfquery
/cftransaction
It is my understanding that the CFTRANSACTION will single thread ALL
requests to the specified DB (instead of just row-level or table-level
locks). That
Actually in both version 4.5 and 5 (I am not sure if you could do it in
earlier versions or in CFMX) you can invoke CF from the command line by
calling the CFML.exe engine..
I don't quite understand what you mean by CF not letting you CFMAIL from
within a query...can you please elaborate?
I thought you have to committ the transaction as well?
I've had SQL problems using this syntax w/o a commit..
- j
-Original Message-
From: Bryan Love [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 2:39 PM
To: CF-Talk
Subject: RE: Annoying DB question
try using a CFTRANSACTION
Dear MM,
Your forums blow. I have tried to log in many times and it seems
almost random if I get in.
Anyway, I figured I would post something here so you know why I am not
going to waste my time trying to tell you about your preview product.
If others are having close to the same level of
wow. that was remarkably professional.
- Original Message -
From: Rick Walters [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, May 20, 2002 3:11 PM
Subject: Macromedia Forums (aka FuseTalk)
Dear MM,
Your forums blow. I have tried to log in many times and it seems
I'm sure they're crushed. Absolutely devastated. They're probably
going to cancel the whole thing based upon your input.
-Original Message-
From: Rick Walters [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 2:12 PM
To: CF-Talk
Subject: Macromedia Forums (aka FuseTalk)
Dear MM,
try using a CFTRANSACTION like this...
cftransaction
cfquery name=
EXECUTE sp_newmeal
/cfquery
/cftransaction
It is my understanding that the CFTRANSACTION will single
thread ALL requests to the specified DB (instead of just
row-level or table-level locks).
I am trying to parse an email address due to the
friendly email addresses by using CFPOP.
If the #FROM# resembles: [EMAIL PROTECTED]
then I am fine however since there are friendly email
address which look like myname [EMAIL PROTECTED]
then I have to use HTMLEditFormat to get the email address.
1 - 100 of 169 matches
Mail list logo