Can anyone help me with this, my brain is fuzzy after the 8 or 9 pints from
last night's work's curry night.
I have a table with a text column in it (SQL2000)
I want to return a bit (1|0) indicating whether or not the row has text in
it. The column either has text in it, or has no text in it
Rich,
use DATALENGTH(a.content) to get the length...
HTH
Douglas
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]]
Sent: 12 September 2002 10:12
To: '[EMAIL PROTECTED]'
Subject: [ cf-dev ] sql help
Can anyone help me with this, my brain is fuzzy after the 8 or 9 pints
An interesting one this
I have two files which I want to edit in studio 4.5.
I have RDS connection to the server.
I try to load the two documents and get this fantastic error message
A system call that should never fail has failed
I can't load either of these pages into a browser, I
beautiful. cheers mate.
-Original Message-
From: Douglas Humphris [mailto:[EMAIL PROTECTED]]
Sent: 12 September 2002 10:39
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] sql help
Rich,
use DATALENGTH(a.content) to get the length...
HTH
Douglas
-Original
Try opening them in Notepad and see what they look like...
D
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: 12 September 2002 10:43
To: [EMAIL PROTECTED]
Subject: [ cf-dev ] AGGH
An interesting one this
I have two files which I want to
BTW, varchar supports 8000 chars, so don't use text unless you really need
to, as it works completely different to varchar as it is a BLOB (no comments
please Shaila).
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]]
Sent: 12 September 2002 10:29
To: '[EMAIL PROTECTED]'
Okay, if all else fails, then create a duplicate table with one difference -
a VARCHAR instead of a BLOB. Then keep them synchronised with triggers. Then
base your search on the duplicate.
Paolo
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]]
Sent: 12 September 2002
i wasn't planning on making any comments Russ :)
ROFL
At 11:08 12/09/2002, you wrote:
BTW, varchar supports 8000 chars, so don't use text unless you really need
to, as it works completely different to varchar as it is a BLOB (no comments
please Shaila).
-Original Message-
From: Rich
eh?
I'm not searching on the text, I'm just checking to see if theres text in
there or not.
the reason I have to use text is because of the amount of text in there - it
really is quite large.
I know I can't use DISTINCT either, as well as some other functions, but
thats ok, because I don't
I'm not searching on the text, I'm just checking to see if
theres text in
there or not.
Yes, you are searching on text!
Paolo
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL
no, I'm not, I'm retrieving the size of the text contents, not searching on
the contents.
why would I want to go to the hassle of creating a duplicate of the column
and storing it in a new table with triggers etc when datalength(column)
works just fine?
-Original Message-
From: Paolo
Because I sent my email before the 'datalength(column)' solution was
suggested and I did say a last resort.
I do repeat though that you are searching on a text column. Whether you are
calculating the length or evaluating the value, you are still searching on
the text column.
Paolo
and how do you think it gets the size ?
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]]
Sent: 12 September 2002 11:25
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] sql help
no, I'm not, I'm retrieving the size of the text contents, not searching on
the contents.
why
Thank you, Russ.
-Original Message-
From: Russ 'Snake' Michaels [mailto:[EMAIL PROTECTED]]
Sent: 12 September 2002 11:39
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] sql help
and how do you think it gets the size ?
-Original Message-
From: Rich Wild [mailto:[EMAIL
But datalength has to do a search.
Okay, I'll accept your 'semantics' argument, just to save space on my hard
disk.
:-)
Paolo
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]]
Sent: 12 September 2002 11:35
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] sql help
Guys,
Anyone used CF_ADVANCEDEMAIL with CFMX. Supposedly it doesn't work or
something. I just wanted to double check.
Cheers
Niklas
CGI.SERVER_NAME ?? maybe...
-Original Message-
From: Damian Watson [mailto:[EMAIL PROTECTED]]
Sent: 12 September 2002 12:41
To: [EMAIL PROTECTED]
Subject: [ cf-dev ] server_name
Hi,
I've been setting a session variable with #server_name# to give me a site
URL -- however on our servers
douglas, that is exactly what he is already using. cgi.server_name and
server_name is the same thing.
-Original Message-
From: Douglas Humphris [mailto:[EMAIL PROTECTED]]
Sent: 12 September 2002 12:48
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] server_name
CGI.SERVER_NAME ??
yeah, I knew that...just testing. ;?)
-Original Message-
From: Russ 'Snake' Michaels [mailto:[EMAIL PROTECTED]]
Sent: 12 September 2002 12:48
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] server_name
douglas, that is exactly what he is already using. cgi.server_name and
server_name is
looks fine, what error u getitng.
The only thing could be the datatypes are wrong for the fields uy are using
-Original Message-
From: Justin MacCarthy [mailto:[EMAIL PROTECTED]]
Sent: 12 September 2002 13:20
To: [EMAIL PROTECTED]
Subject: [ cf-dev ] Stupid SQL question
Hi, due to
I'm confused by this...
DNS name www.whatever.com - Proxy webserver 1
Proxy webserver 2
Proxy webserver 3
So SERVER_NAME should aways be whatever.com ???
Unless, when you go to www.whatever.com you get
ok -- so cgi.server_name don't need no scoping...
- Original Message -
From: Matt Horn [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, September 12, 2002 12:54 PM
Subject: RE: [ cf-dev ] server_name
SCOPING!!
At 12:47 12/09/02 +0100, you wrote:
douglas, that is exactly
Sorry shoulda been more specific -- proxy redirects are being used so the
server name is the DNS name...
- Original Message -
From: Justin MacCarthy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, September 12, 2002 1:33 PM
Subject: RE: [ cf-dev ] server_name
I'm confused by
I'm assuming that you haven't really named your table as 'table'
BTW: You don't need the parentheses around the where clause, only around the
list.
Taz
UPDATETable
SET Field = 1
WHERE(ID in (12,13,14))
if there is what would be the correct syntax to get the desired result..
you request www.domain.com/whatever
proxy directs to www2.domain.com/whatever
user always sees the domain they type, but coldfusion sees what the proxy
redirects to.
Thus if coldFusion uses server_name it will us ethe wrong address as it uses
the proxy address.
Damian needs the address that is
Well, we have localdirector on a cluster here (a proxy of sorts)
where
www.whatever.com - [localdirector] - web1.whatever.com
- web2.whatever.com
- ggdhkjj.whatever.com
thanks Russ
anyone tried netTracker? apparently that also parses BV logs
-Original Message-
From: Russ 'Snake' Michaels [mailto:[EMAIL PROTECTED]]
Sent: 12 September 2002 14:13
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] boredvision logs
I hated webtrends. livestats is a
I personally prefer Webtrends to Livestats -- seems to make more sense of
the data and go deeper with it-- though it maybe cos it looked nicer or I
had a dumbed down version of LiveStats...
- Original Message -
From: Rich Wild [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday,
Webtrends is the best reporting package that I've used, the only downsides
are the price and its fascination with outputting US format dates... but
most decent reporting apps are pricey and the date stuff can be sorted with
report customisation.
Lots of functionality though.
Taz
also - I
Erm, is you proxy including anything in the header?
If your using 5 or above...
cfset test = GetHttpRequestData()
cfdump var=#test#
[EMAIL PROTECTED] 12/09/02 13:48:01
ok lets try another explanation.
user type www.domain.com/whatever
coldfusion generates the URL's as
personally I like Analog, cos it's simple and free. Doesn't do the fancy
3D graphs or some of the more interesting things that Webtrends can,
although can be used with ReportMagic for prettying the output. Anyone
ever used it's computer-format output, in conjunction with CF or anything
else,
cfset application.URL = www.whatever.com in application.cfm?
Duncan Cumming
IT Manager
http://www.alienationdesign.co.uk
mailto:[EMAIL PROTECTED]
Tel: 0141 575 9700
Fax: 0141 575 9600
Creative solutions in a technical world
you are in this case yes.
-Original Message-
From: Justin MacCarthy [mailto:[EMAIL PROTECTED]]
Sent: 12 September 2002 14:20
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] server_name
Well, we have localdirector on a cluster here (a proxy of sorts)
where
www.whatever.com -
no good for a hosting enviromnent if I remember though.
-Original Message-
From: Taz -=TT=- [mailto:[EMAIL PROTECTED]]
Sent: 12 September 2002 14:28
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] boredvision logs
Webtrends is the best reporting package that I've used, the only downsides
There was a trigger on the table...agg!
Thanks all
Justin
-Original Message-
From: Justin MacCarthy [mailto:[EMAIL PROTECTED]]
Sent: 12 September 2002 14:18
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Stupid SQL question
UPDATEDocuments
SET EveryoneBit = 1
Yeah -- that's what I was trying to avoid doing because this same prob runs
across a number of the same applications so I was trying to save some
work... kind of thing you always forget to reset when you're just copying
across code to set up a new site. oh well = ;^)
- Original Message
Well, just the one for now anyway...
I have a list of services, clients and employees. Each client is linked
to a number of services (via a link table, in which the client and
service IDs are specified, along with a cost to that client). The same
is true for an employee.
I want to SELECT a
Can't you just shove an if in there along the lines of, if data exists for
client and employer, select only client?
- Original Message -
From: Tim Blair [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, September 12, 2002 2:56 PM
Subject: [ cf-dev ] More SQL Q's...
Well, just
a beta version yes
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]]
Sent: 12 September 2002 14:51
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] boredvision logs
great! so you'll be giving it away for free then?
-Original Message-
From: Russ 'Snake' Michaels
so u have two sets of prices. one in the service table and one in the
employee table, is that correct.
And if a service is listed under both the employee and the customer, then
you want to us ethe price listed in the employee table and not in the
service table.
-Original Message-
From:
Anyone have a custom tag that works with CFMX to send multi-part emails?
Cheers
Niklas
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL
so cf_advancedemail definitely doesn't work with cfmx then?
arse.
do you know why?
-Original Message-
From: Niklas Richardson [mailto:[EMAIL PROTECTED]]
Sent: 12 September 2002 15:25
To: [EMAIL PROTECTED]
Subject: [ cf-dev ] Multi-part (HTML + Plain Text) Emails
Anyone have
cfoutput query=yourQuery
cfif Len(yourQuery.EmployeeCost)
Cost: #DecimalFormat(yourQuery.EmployeeCost)#
cfelseif Len(yourQuery.ServiceCost)
Cost: #DecimalFormat(yourQuery.ServiceCost)#
/cfif
/cfoutput
and in your query have something like
SELECT E.Cost AS EmployeeCost,
Thanks for the help there. I know there are some around, but afaik they
don't work with CFMX!
-Original Message-
From: Russ 'Snake' Michaels [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 12, 2002 3:21 PM
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Multi-part (HTML +
The mail format is different in CFMX than in previous versions.
The guy hasn't updated CF_ADVANCEDEMAIL to work with the CFMX format
yet!
Do you know of any others?
Cheers
Niklas
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 12, 2002
the cfmx code analyser returns this info on the advancedemail and
advancedemailparam files:
REFINDNOCASE Info
In CF5 a regular expression with a leading quantifier (?+*), such as
reFind(*, abc), would always match. In CFMX quantifiers must follow
something in the expression.
How to
Hi, I've not used CFTRY before but I can't see why this doesn't work:
cftry
cfinclude template=qry_getSearches.cfm
cfcatch type=any
cfset request.fieldIsNumeric = false
cfinclude template=qry_getSearches.cfm
/cfcatch
/cftry
I expect the qry_getSearches.cfm to fail sometimes
you tried CFCatch type=Database ?
Duncan Cumming
IT Manager
http://www.alienationdesign.co.uk
mailto:[EMAIL PROTECTED]
Tel: 0141 575 9700
Fax: 0141 575 9600
Creative solutions in a technical world
--
Get your domain names
have u tested them ?
-Original Message-
From: Niklas Richardson [mailto:[EMAIL PROTECTED]]
Sent: 12 September 2002 15:31
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Multi-part (HTML + Plain Text) Emails
Thanks for the help there. I know there are some around, but afaik they
don't
there may be an issue with an error occuring inside an included file between
the catch block. Try inserting the code directly and not including it see if
it works.
-Original Message-
From: Giles Roadnight [mailto:[EMAIL PROTECTED]]
Sent: 12 September 2002 15:34
To: [EMAIL PROTECTED]
Just working on itrewriting a VERY basic version
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 12, 2002 3:22 PM
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] Multi-part (HTML + Plain Text) Emails
in what way is it different?
Can't find any at the momenttag gallery dead!
-Original Message-
From: Russ 'Snake' Michaels [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 12, 2002 3:32 PM
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Multi-part (HTML + Plain Text) Emails
have u tested them ?
I can't wait, it sounds awesome
-Original Message-
From: Russ 'Snake' Michaels [mailto:[EMAIL PROTECTED]]
Sent: 12 September 2002 15:16
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] boredvision logs
a beta version yes
-Original Message-
From: Rich Wild [mailto:[EMAIL
well the easiest way is just to grab both prices and give one
an alias, then you have access to both of them in your code.
Sorted in some fashion. Grabbing the client service info and doing a
left join on the employee one so if there's an employee cost it gets
returned, otherwise NULL, so I
That's what I'm doing! :)
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 12, 2002 3:36 PM
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] Multi-part (HTML + Plain Text) Emails
why reinvent the wheel? :@/
just rewrite the mail
ok then slap an IF statement in the query and pull out the appropriate
column.
-Original Message-
From: Tim Blair [mailto:[EMAIL PROTECTED]]
Sent: 12 September 2002 15:45
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] More SQL Q's...
*poster fist*
But now I'm just trying to be
Well it will be if the coder ever gets off his ass :-)
-Original Message-
From: Peter Harrison [mailto:[EMAIL PROTECTED]]
Sent: 12 September 2002 15:48
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] boredvision logs
I can't wait, it sounds awesome
-Original Message-
From: Russ
I have some data in an xml format which I want to insert into a SQL 2000
db table.
e.g. The db table has the following fields:
PersonID int(4)
FirstName varchar(50)
LastName varchar(50)
Age int(4) NULL
Salary decimal NULL
Email varchar(50) NULL
The xml is in the following form:
PERSON
58 matches
Mail list logo
