com & wddx

2001-02-28 Thread Richard Meredith-Hardy
32 xmltok.dll I've tried deleting & Reinstalling these files but no diff. ANY Ideas Please! -- Regards; Richard Meredith-Hardy - [EMAIL PROTECTED] Tel: + 44 (0)1462 834776 FAX: + 44 (0)1462 732668 ~~

Re: com & wddx

2001-02-28 Thread Richard Meredith-Hardy
yes, wddx type library is checked in tools --> references JustinMacCarthy wrote: > > Are you sure you are putting the wddx com in the References (in your vba) > > Justin > > >-Original Message- > >From: Richard Meredith-Hardy [mailto:[EMAIL PROTECTED]] &

Re: com & wddx

2001-03-03 Thread Richard Meredith-Hardy
formation > is in the Advanced Ben Forta Book > > -----Original Message- > From: Richard Meredith-Hardy [mailto:[EMAIL PROTECTED]] > Sent: 01 March 2001 05:53 > To: CF-Talk > Subject: com & wddx > > Dear all > > (Its been a while since I was on the list) >

Re: com & wddx

2001-03-05 Thread Richard Meredith-Hardy
bout > >vba to write one myself from scratch. > > > >If anyone happens to have a vba snippett lying around which will do this > >I would be most grateful > > > > > > > >"Scott, Andrew" wrote: > >> > >> With these objects you

Dates in OLEDB

2001-03-10 Thread Richard Meredith-Hardy
le WHERE (STORYDT > now()) There must be a correct syntax - anyone help? I really don't want to alter all my queries which involve time - is this really necessary with OLEDB? This is weird! What's going on? -- Regards; Richard Meredith-Hardy -

RE: Dates in OLEDB

2001-03-10 Thread Richard Meredith-Hardy
ites for the real world" > > ** > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they > are addressed. If yo

RE: Dates in OLEDB

2001-03-12 Thread Richard Meredith-Hardy
t; > > > This immediately makes a migration to OLEDB a waste of time. (Might > > look at it for future apps) > > > > It also makes me think there should be a set of new functions in CF: > > > > createDBdate(mydate,"theDB&

Verity error trapping

2001-03-12 Thread Richard Meredith-Hardy
nice to allow characters eg '"[]() which are permissable, but only in matching pairs. -- Regards; Richard Meredith-Hardy - [EMAIL PROTECTED] Tel: + 44 (0)1462 834776 FAX: + 44 (0)1462 732668

enumerating variables

2001-03-15 Thread Richard Meredith-Hardy
r any other 'automated' way (try adding them to structlist); - is there a way of enumerating them all at the end of a page? -- Regards; Richard Meredith-Hardy - [EMAIL PROTECTED] Tel: + 44 (0)1462 834776 FAX: + 44

Re: enumerating variables

2001-03-16 Thread Richard Meredith-Hardy
re > retrieveable with getClientVariableList(). > > jon > - Original Message - > From: "Richard Meredith-Hardy" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, March 15, 2001 3:09 PM > Subject: enumerating

re: truncation problems

2001-03-24 Thread Richard Meredith-Hardy
etc. The > input > doesn't seem to have a problem, only the . I put big red > & > blue beach balls into the database and all that getback is big red. Or I > put > Floor Jars (over 20" high) and all I get back is Floor Jars (over 2O . > > Thanks in a

Re: HTML2PDF3 on CFMX - whoops

2002-10-18 Thread Richard Meredith-Hardy
I started out using html2pdf3 but found its error trapping not so good. If you get an error in htmldoc, say through some input parameter like a wrongly configured expandpath(), then the htmldoc.exe thread will hang and just sit there on the server consuming resources. Make sure all possible in

Re: Query Question

2002-10-18 Thread Richard Meredith-Hardy
If these are in fact logical values, ie 0 or 1, then you could try something like: SELECT pa_ab, pa_sk, pa_mb, pa_on, pa_nb, pa_pei, pa_ns, pa_nf, pa_bc, pa_bc, pa_pq, pa_yk, pa_nwt, pa_nu FROM USERS WHERE (pa_ab + pa_sk + pa_mb + pa_on + pa_nb + pa_pei + pa_ns + pa_nf + pa_bc + pa_bc + pa_pq + pa

Re: CFX_GIFGD Help

2002-10-22 Thread Richard Meredith-Hardy
my server and resized. > > Can anyone help me out with the syntax? (The help doc isn't much help) > > -- > Mark Smeets / stranger0 / ICQ: 1062196 > [EMAIL PROTECTED] > http://www.prowerks.com/stranger > > "Life is

Re: CFIndex for Verity quit working - Needs Attention by Macromedia!

2002-10-22 Thread Richard Meredith-Hardy
I had a problem something like this with a verity collection based on a DB with about 50,000 records which occasionally falls over after about 10,000 alterations (despite daily optimizations). A CFINDEX action = "PURGE" followed by a CFINDEX action = "REFRESH" usually fixes it but once or twice I

Re: Multiple Records Update Issue

2002-10-23 Thread Richard Meredith-Hardy
ordset1.Liberty# EQ "")>unchecked> > Leave:_ > (#Recordset1.Leave# EQ "")>unchecked> > TAD:_ > (#Recordset1.TAD# EQ "")>unchecked> > SIQ:_ > (#

Re: Adding a row..

2002-10-23 Thread Richard Meredith-Hardy
One way to do this is have a set of empty input field(s) after the end of the lineitems output query called something like "new_fieldname" When you come to submit, you update your existing lineitems, then check if one or more of your new_ fields has a value in it, ie and if the value(s) check ou

cfusion_encrypt URL safe?

2002-10-24 Thread Richard Meredith-Hardy
Dear all Is cfusion_encrypt() URL safe? ie will a string thus encrypted and passed in a URL variable always be correctly decrypted? (it seems to be OK) What is the maximum length a URL can be? thanks -- Regards; Richard Meredith-Hardy

Re: How to remove URL references from printed pages

2002-10-25 Thread Richard Meredith-Hardy
htmldoc works very well, but be SURE to trap all possible errors before you call htmldoc as a bad path or something can leave the htmldoc thread hanging and it simply sits there consuming resources. Note html2pdf (at least the last version I tried) doesn't trap everything. Randell B Adkins wrote:

=?iso-8859-1?Q?Re: =C2 before =A3 with MX form posts??=

2002-10-29 Thread Richard Meredith-Hardy
I recommend you don't use the £ sign as lots of people can't see it. £ or œ should be more reliable. Paul Wilson wrote: > > I am posting some information from one cf page to another but every "£" sign is > proceeded with Â. > > You can see an example here (Look at Binasys Ltd) > http://efilesys

Re: Return of the sql wierdness ERROR message

2002-11-03 Thread Richard Meredith-Hardy
Sometimes I have found you can get this sort of error if the value in the query is not immediately apparent as a simple value - I know it shouldn't matter, but easy to try: (I had this exact problem the other day; Access - memo) instead of INSERT into authorBio (authorBio_authorId,authorBioDeta

Re: HELP!! sql wierdness ERROR message

2002-11-04 Thread Richard Meredith-Hardy
g the failure. Let's have a look at that string.... -- Regards; Richard Meredith-Hardy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.c

M$ mappoint.net

2002-11-13 Thread Richard Meredith-Hardy
have, I would be most grateful for some pointers. Please contact me off list. Thanks. -- Regards; Richard Meredith-Hardy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription:

Re: M$ mappoint.net

2002-11-13 Thread Richard Meredith-Hardy
hmm... makes me feel like I'm about 100 ft under water and about to run out of breath... Looks like I've got some reading to do. Dave Watts wrote: > > > Has anyone on this list managed to integrate a CF > > application (pref. CF 5) with M$'s mappoint web > > service offering? > > > > Is it even

top clause in a SP

2002-12-29 Thread Richard Meredith-Hardy
as? (this is SQL Server 2000 / CF5) -- Regards; Richard Meredith-Hardy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&

Re: excel as a vehicle to collect and write back data to a CF-App

2002-12-29 Thread Richard Meredith-Hardy
I've done this using a vba script in excel to wrap the columns you select into a wddx packet (using wddx_com.dll) and then sending it to the server using asptear.dll works rather well. [EMAIL PROTECTED] wrote: > > I have a customer, > who runs an application, > where he can show, who > is a a

Re: ODBC Date Question

2002-12-30 Thread Richard Meredith-Hardy
A few notes: - is 'File' a reserved word? - I have to say a a European I HATE date formats like mm/dd/ or dd/mm/ for the simple reason that there are too many ways to misunderstand them - when I ask people to put a date in a single field I ask them to use dd mmm which is completely u

Re: Root template directory has not been specified

2002-12-30 Thread Richard Meredith-Hardy
take out the leading / as in Larry Juncker wrote: > > Here is line 17 : > > > and here is Application.DisplayMap in Application.cfm > > > > Larry Juncker > Senior Cold fusion Developer > Heartland Communications Group, Inc. > [EMAIL PROTECTED] > (515) 574-2122 > > CONFIDENTIALITY NOTICE

Re: Errors: can not locate info on

2003-01-02 Thread Richard Meredith-Hardy
I don't know about your client var problem, but I beleve the CF documentation says somewhere it is a bad idea to allow verity searches to happen whilst some sort of management of the collection is going on eg a re-index. I consequently use an application var which is checked before a CFSEARCH is a

Re: registry limit for client variables

2002-09-16 Thread Richard Meredith-Hardy
with your client about the hosting company. > > Good luck! > Jason > CFDynamics.com > > > -Original Message- > > From: Richard Meredith-Hardy [mailto:[EMAIL PROTECTED]] > > Sent: Monday, September 16, 2002 5:50 AM > > To: CF-Talk > > Subject:

Re: SQL Server advice

2002-09-19 Thread Richard Meredith-Hardy
I do this all the time with WDDX packets. I expect XML is the modern way. Depending on how well your machines can talk to each other it could be completely automatic. Douglas Jordon wrote: > > We need to synch a db that drives a web site to the master on our > clients LAN. Because of licensing c

Re: Just curious possible problem

2002-09-19 Thread Richard Meredith-Hardy
what about the field name desc - this is a keyword in SQL and may be upsetting things. Try renaming the field in your DB perhaps. Webmaster wrote: > > It is the original problem it does not like the desc field from the form.. > there must be something in it that is driving SQL crazy > > -O

Re: ArcIMS and Cold Fusion

2002-09-19 Thread Richard Meredith-Hardy
> if you > sliced & diced your imagery (say aerial photos) properly you could build a > nifty image server w/cf. but real internet GIS/location stuff needs > something that knows geography. Depends what you call 'knows geography'. The maps at http://www.adventuredirectory.com work on this basi

Re: ArcIMS and Cold Fusion

2002-09-19 Thread Richard Meredith-Hardy
but... Paul Hastings wrote: > > > Depends what you call 'knows geography'. The maps at > > http://www.adventuredirectory.com work on this basis and are calibrated > > can't buffer. can't route. can't do proximity searches. can't > identity/union/intersect. doesn't know topology. yada yada yada

Re: OT: Forging a web page

2002-09-24 Thread Richard Meredith-Hardy
About the only way I can see you could 'verify' a web page would be to include some sort of custom meta data or comment in the page which contained an encrypted string, a wddx packet perhaps, containing the key data. If there was any question about the validity of the content in a case like this

Re: Cold Fusion and Excel question

2002-09-24 Thread Richard Meredith-Hardy
Depends where your excel file is. If it is on the server then you could set it up as a datasource (or on CF5 as a temporary datasource) and simply query it (not sure how reliable this is) If it is remote, then I have successfully managed to send wddx data directly from excel to the cf server via

OT Xopus

2002-09-30 Thread Richard Meredith-Hardy
off list is better) -- Regards; Richard Meredith-Hardy __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk

Scheduled events

2003-06-02 Thread Richard Meredith-Hardy
Would this work? Thanks -- Regards; Richard Meredith-Hardy - [EMAIL PROTECTED] Mob: + 44 7771 526513 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid

Re: Scheduled events

2003-06-03 Thread Richard Meredith-Hardy
working on an Intranet setup which is on a secure server > (ie > HTTPS://) > > When logged in, I can manually run a script, but the CF scheduler > won't > run it. > > Q1: Is this possible at all? > > Q2: How do you get the WIN2K 'scheduled tasks' thing to

Re: cferror oddities (revisited)

2003-06-03 Thread Richard Meredith-Hardy
I believe that when you submit a form on a mac it often sends at least one white space even from an 'empty' field. fix: trim() all form input. (a nuisance) I have also had trouble in macs when you have a form with ENCTYPE="MULTIPART/FORM-DATA" which you need in forms with a > I posted a week or

trigger problem

2003-01-09 Thread Richard Meredith-Hardy
; "Subquery returned more than 1 value" I had slightly assumed triggers work on a row by row basis, but this would suggest they might not. I am sure there is a simple way around this. Can anyone help please? (this is CF5 by the way) -- Re

Re: Nested Tree DHTML

2003-01-09 Thread Richard Meredith-Hardy
I have something like this (though not 215 seconds worth) and get around it by only running the nested queries when a change is made and it creates a hard page (which can be CFinserted as required) John Quarto-vonTivadar wrote: > > You mean the Joe Celko model? It's a great way to store tree data

Re: trigger problem SOLVED

2003-01-10 Thread Richard Meredith-Hardy
s a simple way around > this. Can anyone help please? > > (this is CF5 by the way) > > -- > Regards; > > Richard Meredith-Hardy > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?for

Scheduled events - client vars

2002-04-13 Thread Richard Meredith-Hardy
pplication scope, has anyone any idea how I can stop this? -- Regards; Richard Meredith-Hardy - [EMAIL PROTECTED] Mob: + 44 7771 526513 __ Get the mailserver that powers th

Re: Scheduled events - client vars

2002-04-14 Thread Richard Meredith-Hardy
Ok, thanks, I thought so, however, two steps forward, one back. See my other post. Kym Kovan wrote: > > Hi Richard, > > >I have been totally perplexed by a proliferation of entries in my dev > >client var store but of course it is a scheduled routine which runs > >every 10 minutes which is cre

client vars - oledb datasources

2002-04-14 Thread Richard Meredith-Hardy
production one is 4.5.1, I have even tried a cold reboot after doing this setup but no difference. -- Regards; Richard Meredith-Hardy - [EMAIL PROTECTED] Mob: + 44 7771 526513 __

Re: client vars - oledb datasources

2002-04-14 Thread Richard Meredith-Hardy
Well this is what I have done, and it works just fine. My server people won't like it though. They are firmly of the opinion that OLEDB <--> SQL Server is much more stable than ODBC <--> SQL Server. (and the reverse with connections to Access) Strange that it says in CF_administrator "To conf

Re: Simple Application.cfm Question

2002-04-14 Thread Richard Meredith-Hardy
My understanding though is that you have to do a duplicate on any complex data types (structs, arrays, queries etc.) you "copy" from application to local page vars (whatever the scope) otherwise, without locks you are still open to corruption because you are accessing the original application var

client cookies - strategy question

2002-04-14 Thread Richard Meredith-Hardy
CFID & CFTOKEN so cookies get set on all "false" sites invisibly. It's the principle of sharing one CFID & CFTOKEN between many sites which I am wondering about though -- Regards; Richard Meredith-Hardy --

Re: options for image resizing tags

2002-04-15 Thread Richard Meredith-Hardy
CFX_IMAGE will do what you want, and a lot more. not sure where you get it at the moment (look in this list's archive, it will be there somewhere) but the latest version (1.4 I think) is thread safe. I have two very busy apps using it practically every page impression; fast with no problems. N

Re: client cookies - strategy question

2002-04-15 Thread Richard Meredith-Hardy
Justin Seems a bit complicated in that you seem to be effectively duplicating the built in functionality of client variables. I am not using session variables on this [shared] server because the *?xx! thing is constantly being restarted and you end up losing stuff. >From what you seem to be say

Re: cferror weirdness

2002-04-15 Thread Richard Meredith-Hardy
CFINCLUDE always looks from where the including template is, not where the base template is. Therefore if you have a call to your error.cfm from one of your child templates then likely the path in your CFINCLUDE will need to be ../error.cfm If you want to use paths always from your base template

Re: cferror weirdness

2002-04-15 Thread Richard Meredith-Hardy
truzzi > Webmaster > 954-321-4703 > [EMAIL PROTECTED] > http://www.sheriff.org > > -Original Message- > From: Richard Meredith-Hardy [mailto:[EMAIL PROTECTED]] > Sent: Monday, April 15, 2002 11:17 AM > To: CF-Talk > Subject: Re: cferror weirdness > > C

Re: bulk insert to SQL server but not from file

2002-04-16 Thread Richard Meredith-Hardy
What about doing your conversion to relational locally to Access (or even to Paradox) and then just shooting up the complete final data. James Sleeman wrote: > > Hi all, > I have an old, ugly and large Paradox database that I inherited and am >converting into a new, beautiful and large SQL

Re: Good alternative to CFPOP ?

2002-04-25 Thread Richard Meredith-Hardy
I bought CFX_POP3 a while back because it could do something which CFPOP couldn't in CF4.0.1. It worked well. I also discovered it couldn't do something which CFPOP could do - so I ended up using both depending on the precise application. Sorry to be so vague, but I can't remember the exact det

Don't leave stuff lying around

2002-05-22 Thread Richard Meredith-Hardy
ably to ascertain its status code, and in so doing invoked the stored procedure deletion / re-creation. Moral: Don't leave stuff lying around. -- Regards; Richard Meredith-Hardy - [EMAIL

htmldoc.exe / cf_html2pdf3 reliability?

2002-05-23 Thread Richard Meredith-Hardy
e GNU executable version from easysw needs to be compiled (which I have no idea how to do), could anyone send me a compiled version off list? -- Regards; Richard Meredith-Hardy - [EMAIL PROTECTED] Mob: + 44 7771 5

Re: htmldoc.exe / cf_html2pdf3 reliability?

2002-05-23 Thread Richard Meredith-Hardy
watch > out for, it hasn't happened to me though. Good luck! > > v/r, > Jeff > > -Original Message- > From: Richard Meredith-Hardy [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 23, 2002 2:01 PM > To: CF-Talk > Subject: htmldoc.exe / cf_html2pdf3 rel

decryption and licencing

2002-06-18 Thread Richard Meredith-Hardy
stall Software Licence Agreement) -- Regards; Richard Meredith-Hardy - [EMAIL PROTECTED] Mob: + 44 7771 526513 __ Your ad could be here. Monies from ads go to support

Re: security module

2002-06-18 Thread Richard Meredith-Hardy
I use a very simple model where everything that needs a permission is given a permission number or reference. In principle the user never even gets to see that a menu item even exists unless he has that permission. It is an easy management setup because all it needs is a page with a load of che

Slightly OT, MSword-->wddx-->cf

2001-09-07 Thread Richard Meredith-Hardy
able in visual basic" Anyone any ideas?? -- Regards; Richard Meredith-Hardy - [EMAIL PROTECTED] ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: ht

Re: CFPop problems!

2001-09-07 Thread Richard Meredith-Hardy
1) In CF 3.1 there used to be a problem with deleting email No.1 (especially if it had an attachment). I don't know if this has been fixed in more recent versions of CF, but in any case I always pre-load the mailbox with a "dummy" No. 1 and then manipulate all mails from no 2 onwards. 2) There i

Re: CF and MS Word Docs

2001-09-10 Thread Richard Meredith-Hardy
I do it in 2 stages; MSFILTER 2 will get rid of a lot of guff, but not all, I then send it up to the server where I then run it thru a CF custom tag I wrote which strips out everything (inc extraneous white space) leaving some style text and most of the body text, (file is then CFINCLUDEed in the

Re: Create Excel document

2001-09-10 Thread Richard Meredith-Hardy
Haven't tried it, but what if you simply write the content to myfile.xls with cffile and then cflocation to it? zap005 wrote: > > Hi There, > > My hosting provider does not allow cfcontent or COM objects. > > I need a way to insert the excel document type into the header of a document > with

Re: Create Excel document

2001-09-10 Thread Richard Meredith-Hardy
whoops...I meant myfile.csv, which excel should open as the default application. Richard Meredith-Hardy wrote: > > Haven't tried it, but what if you simply write the content to myfile.xls > with cffile and then cflocation to it? > > zap005 wrote: > > > > Hi Th

Re: Web content management tools?

2001-10-29 Thread Richard Meredith-Hardy
Pardeep I have built a different kind of tool which gets your local copy of ms word 2000 talking directly to your CF web server. To my mind has 2 advantages: You don't have to be online most of the time and styles are potentially more controllable than most of the online editors I have seen. S

Re: Content Management light

2001-11-03 Thread Richard Meredith-Hardy
Not free, but take a look at DirectLoad http://www.flymicro.com/cf/directload John Anderson wrote: > > Just wondering if anyone knows of a lightweight (possibly free) > > Content management application. > > Requirements: > Allow groups within a company to add files and categories. Also

Re: (ot) Access, SQL Server and Replication

2001-11-13 Thread Richard Meredith-Hardy
Sounds like a job for WDDX I have done something like this where Excel running locally talks to a web server by WDDX so I don't suppose it would be too difficult to get Access to do the same. "Owens, Howard" wrote: > > I have a client with an ecommerce site (not quite finished yet). > > One o

Re: (ot) Access, SQL Server and Replication

2001-11-14 Thread Richard Meredith-Hardy
. "Owens, Howard" wrote: > > Wouldn't CF need to be installed on the local/Access machine for WDDX to > work? > > H. > > Howard Owens > Internet Operations Coordinator > www.insidevc.com > [EMAIL PROTECTED] > AIM: GoCatGo1956 > > > -----Ori

Re: ALTER TABLE in access

2001-11-15 Thread Richard Meredith-Hardy
I had this exact problem once. Only solution I could find was to write a routine something along the lines of - create a new column with a temp name (with desired new size) - copy data from old col to new col - delete old col - rename new col to proper name - recreate indexes etc. I can't rem

Re: Page creation interfaces

2001-11-21 Thread Richard Meredith-Hardy
DirectLoad is a system for creating & editing website pages from MS Word http://www.flymicro.com/cf/directload Steven Katz wrote: > > Are there any existing systems out there that allow people who no > nothing about html to create and maintain their own pages, such as > with a forms-based adm

Re: MS word HTML page with a picture

2001-11-27 Thread Richard Meredith-Hardy
DirectLoad does all this for you and more http://www.flymicro.com/cf/directload As for file naming, it names all the associated files my_file_image_001.jpg etc. and puts them by default in the same directory as the html file. This may not be very tidy but it does mean there can't be confli

Re: Eolas patent suit

2003-10-27 Thread Richard Meredith-Hardy
... back to directly CF related, what is the workaround already put forward, I don't seem to be able to find it.   We use dynamically generated PDF's a lot   Bryan Stevenson wrote: > > Why would you not be able to use the workaround already put forward?  I haven't paid a huge amount of atten

Re: cf calendar

2003-11-25 Thread Richard Meredith-Hardy
I can recommend Jukka Manner's CFX_ISOcalendar, very powerful & flexible. (get the latest version though, there was a small but irritating bug in earlier versions where weekly calendars very occasionally failed). Tony Weeg wrote: > > hi there. > > looking for a cf based calendar, that can have

Quotes in dynamic queries

2003-09-17 Thread Richard Meredith-Hardy
al with single quotes and the double quotes truncation -in the value- with this? Can you? -- Regards; Richard Meredith-Hardy - [EMAIL PROTECTED] Tel: + 44 (0)1462 834776 FAX: + 44 (0)1462 732668 ~~~

Re: Quotes in dynamic queries [solved]

2003-09-17 Thread Richard Meredith-Hardy
m: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, September 17, 2003 8:13 AM > > To: CF-Talk > > Subject: RE: Quotes in dynamic queries > > > > > > look at using cfqueryparam. It will escape stuff > > automagically. I've also used HT

Re: Quotes in dynamic queries [solved]

2003-09-17 Thread Richard Meredith-Hardy
any other characters I can find. Jochem van Dieten wrote: > > Richard Meredith-Hardy wrote: > > > > > have > > That is incorrect, you can use it anywhere. > > > Second off, in a dynamic query like below, you need the > > preservesinglequotes() so th

copying from one datasource to another

2003-09-23 Thread Richard Meredith-Hardy
essLocal... anyone have an example code? -- Regards; Richard Meredith-Hardy - [EMAIL PROTECTED] Tel: + 44 (0)1462 834776 FAX: + 44 (0)1462 732668 ~| [Todays Thre

Re: dates nightmare again!

2003-09-23 Thread Richard Meredith-Hardy
To avoid this confusion I tend to always use a mmm month as in "25 Jul 2003", I expect someone will tell me otherwise, but I have never come across a date in this format which isdate() recognizes wrongly. Users don't get confused either. Claude Schneegans wrote: > > >>In CF4.5 > I

Re: copying from one datasource to another

2003-09-23 Thread Richard Meredith-Hardy
select ...from ... etc. > > ) > > HTH > Kola > > -----Original Message- > From: Richard Meredith-Hardy [mailto:[EMAIL PROTECTED] > Sent: 23 September 2003 10:40 > To: CF-Talk > Subject: copying from one datasource to another > > I have 2

intranet permissions?

2003-10-03 Thread Richard Meredith-Hardy
& Mac cgi.AUTH_TYPE is NTLM What does the very long string belonging to cgi.HTTP_AUTHORIZATION mean? -- Regards; Richard Meredith-Hardy - [EMAIL PROTECTED] Tel: + 44 (0)1462 834776 FAX: + 44 (0)1462 732668 [Todays Threads] [

Re: intranet permissions?

2003-10-03 Thread Richard Meredith-Hardy
OK, thanks What is a salt? Jochem van Dieten wrote: > > Richard Meredith-Hardy wrote: > > On Win2k / CF5, rather than having everyone login to an Intranet site > > (in this case a new login is forced daily) how reliable is it to > > identify the user from cgi.AUTH_U

Re: CFContent and PDF problems

2003-10-08 Thread Richard Meredith-Hardy
Not sure what's wrong with a regular hyperlink to the PDF file if you want to "push files to a client page"? DELETEFILE="no"> ...works for us with PDF's and brings up the "save as" box. Shawn Grover wrote: > > We're using a CFContent to push files to a client page (after they've > clicked o

Re: Posting to the web from an Excel spreadsheet

2001-11-30 Thread Richard Meredith-Hardy
As I recall the WDDX SDK (http://www.wddx.org) has an example of how to do this by serializing the data using the wddx com object and then send it to the server via something like AspTear. I have used this method to send data straight out of Excel on the client to a CF server very successfully.

Select concantenation problem

2002-01-03 Thread Richard Meredith-Hardy
f a mystery to me thanks in advance.. -- Regards; Richard Meredith-Hardy - [EMAIL PROTECTED] __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB

Re: Select concantenation problem

2002-01-03 Thread Richard Meredith-Hardy
Perfect fix! thankyou! ref. the maps thread earlier today, I looked at your thing, much cleverer than ours, but ours does the trick and works entirely in CF see http://www.adventuredirectory.com for a world map or http://www.pti.org.uk for a UK one Paul Hastings wrote: > > > SELECT x, y, 'ma

Re: Select concantenation problem

2002-01-03 Thread Richard Meredith-Hardy
Paul Paul Hastings wrote: > > > ref. the maps thread earlier today, I looked at your thing, much > > cleverer than ours, but ours does the trick and works entirely in CF > > well there must be something on the backend processing those images Only a (large) shed load of slices and CFX_IMAGE to

OT Language reference

2002-01-04 Thread Richard Meredith-Hardy
copied straight from www.amazon.co.uk ColdFusion 5 Language Reference Ben Forta List Price: £14.50 Our Price: £11.60 You Save: £2.90 (20%) Availability: Usually dispatched within 2-3 days Category(ies): Children's Books , Computers & Internet -- Regards; Richard Mered

Re: word files and databases

2002-01-09 Thread Richard Meredith-Hardy
it > will do a collection of documents (I guess that one is sorta wishful > thinking) > > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists --

Re: Content protection?

2002-01-09 Thread Richard Meredith-Hardy
Nobody has mentioned the MEDIA element of a LINK tag If you have two links to style sheets thus: by simply styling the text as very small, same colour as the background and invisible in the MEDIA="PRINT" style sheet will flummox most people. Won't of course stop ctrl-c Certainly works in

Re: OT: DHTML Menus

2002-01-09 Thread Richard Meredith-Hardy
Javascript, but I really like http://milonic.co.uk/menu/ I have built a CF wrapper for this which builds dynamic cascading menus of unlimited depth, contact me off list if you are interested. Eric Carlisle wrote: > > On a new project, I need to choose a good DHTML menu system. The one I > lik

Re: hair-tearing Jet SQL problem!

2002-01-12 Thread Richard Meredith-Hardy
In my experience Access via ODBC to CF does not support the DEFAULT clause in CREATE or ALTER table statements. Don't know about an OLEDB connection (I do know OLEDB to Access creates a whole new set of probs eg ODBC date & time formats are not supported). Joseph Thompson wrote: > > I can't w

Re: Build your own

2002-01-12 Thread Richard Meredith-Hardy
CFX_IMAGE does simple graphs "Rick Osborne [Mojo]" wrote: > > Ron Anderson asked: > > Has anyone reached the point of frustration with CFGraph, > > where they've just built their own? > > I did, but I did it in Perl with the GD module. > > http://www.rickosborne.org/<-- Look at the Inso

Re: New Kind of Error

2002-01-14 Thread Richard Meredith-Hardy
You get this error if you have the file open at the same time in MS Word (even if it is a HTML file). James Maltby wrote: > > We are getting the following error from one of our sites: > > > Error Diagnostic Information > Cannot load template file /xxx/xxx//x

Re: OT: Using CSS to make pretty printouts

2002-01-14 Thread Richard Meredith-Hardy
this works, (in MSIE anyway) "Carlisle, Eric" wrote: > > Believe me, I'd prefer to draw print friendly versions from a DB, but > much > of the site is simple HTML. :) > > I see what you saying about toggling the visibility. > I was thinking of using 2 stylesheets one for display, one for pri

Re: Replacement for HierMenus now that it costs $$$?

2002-01-15 Thread Richard Meredith-Hardy
I have written a CF wrapper for milonic menus which will iterate a directory structure of unlimited depth (works, albeit a bit 'alpha'). Contact me off list if you are interested. UXB Internet wrote: > > Matt, > > Try this one; it seems to be feature rich. > > http://milonic.co.uk/menu/ > >

hierarchical database.....

2002-01-18 Thread Richard Meredith-Hardy
idea someone threw at me was XML well I understand WDDX, but I don't understand the principles of using XML as an actual database. Could this solve my problem? All ideas & suggestions welcome! -- Regards; Richard Meredith-Hardy --

Re: hierarchical database.....

2002-01-18 Thread Richard Meredith-Hardy
r of E-Commerce Development > Electric Edge Systems Group Inc. > p. 250.920.8830 > e. [EMAIL PROTECTED] > --------- > Macromedia Associate Partner > www.macromedia.com > > - Original Message - > From: "Richard Meredith-Hardy" <[EMAIL PROTECTED]> > To: &

CFHTTP-->CFFILE

2002-01-31 Thread Richard Meredith-Hardy
I wonder if anyone could explain why a file obtained with a CFHTTP get operation and subsequently written to disk with a CFFILE operation is double line spaced compared to a browser source. How to stop it? a REREPLACE against the CFHTTP.FileContent? -- Regards; Richard Meredith-Hardy

Re: CFHTTP-->CFFILE

2002-02-02 Thread Richard Meredith-Hardy
everyline, and that > fixed it. > > __ > steve oliver > atnet solutions, inc. > http://www.atnetsolutions.com > > -----Original Message- > From: Richard Meredith-Hardy [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 31, 2002 10:06 PM > To:

  1   2   3   >