com wddx

2001-02-28 Thread Richard Meredith-Hardy
d 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 ~~ Stru

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]] Sent: Wednesday, February 28, 2001 6:53

Re: com wddx

2001-03-05 Thread Richard Meredith-Hardy
of components to include, I don't recall the exact name for the wddx stuff. However I think this information 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 wd

Dates in OLEDB

2001-03-10 Thread Richard Meredith-Hardy
but not exactly very flexible 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
and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -- Regards; Richard Meredith-Hardy

RE: Dates in OLEDB

2001-03-12 Thread Richard Meredith-Hardy
also makes me think there should be a set of new functions in CF: createDBdate(mydate,"theDB") createDBdatetime(mydatetime,"theDB") Where theDB could be "Access", "SQLServer","ODBC"(!) etc. -- Regards; Richard Meredith-Hardy

Verity error trapping

2001-03-12 Thread Richard Meredith-Hardy
quot;)) Does anyone have a re which is a bit more subtle? In particular it would be nice to allow characters eg '"[]() which are permissable, but only in matching pairs. -- Regards; Richard Meredith-Hardy - [EMAIL PROTECTED] Tel: +

Re: enumerating variables

2001-03-16 Thread Richard Meredith-Hardy
urity reason. Client variables are 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 variables W

re: truncation problems

2001-03-24 Thread Richard Meredith-Hardy
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 advance, Michael Gribbin Digital Marketing Alliance -- Regards; Richard Meredith-Hardy ---

Slightly OT, MSword--wddx--cf

2001-09-07 Thread Richard Meredith-Hardy
contains all the data which is serialized 'sent to the server so it works OK in principle mystruct.setprop theimgfile, imgbinary 'tidy up Close #1 The error is on the Get.. line: 458, Variable uses an automation type not available in visual basic Anyone any ideas?? -- Regards; Richard Meredith

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 is

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

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 without

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 There, My hosting provider does not allow

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.

Re: Content Management light

2001-11-03 Thread Richard Meredith-Hardy
plug Not free, but take a look at DirectLoad http://www.flymicro.com/cf/directload /plug 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.

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 of the

Re: (ot) Access, SQL Server and Replication

2001-11-14 Thread Richard Meredith-Hardy
, 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 -Original Message- From: Richard Meredith-Hardy [SMTP:[EMAIL PROTECTED

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

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

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

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

Re: help:opening a excel file on web but read only to user

2002-02-25 Thread Richard Meredith-Hardy
I think you will have to make the excel file itself read only rather than any setting you can make in the way it is served up. han peng wrote: hihi... making help calls to all gurus/ expert out there... to open a EXCEL file in web... window.location='test.xls' how i can let a user

it's finally happened

2002-03-05 Thread Richard Meredith-Hardy
it... it would save ms a lot of hair pulling thanks. -- Regards; Richard Meredith-Hardy - [EMAIL PROTECTED] __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256

Re: it's finally happened

2002-03-05 Thread Richard Meredith-Hardy
? Anyone know where? Richard Meredith-Hardy wrote: Studio crashed and the file I was playing with is blank. I can find no files starting cf~ with anything in them which has been suggested as a solution on this list. I do have an encrypted version of the the original file, I wonder

html to pdf

2002-03-07 Thread Richard Meredith-Hardy
Can someone out there tell me where I can get a compiled version of htmldoc.exe v. 1-8-18 (ie the latest version) Much appreciated, thanks. -- Regards; Richard Meredith-Hardy - [EMAIL PROTECTED

Re: html to pdf

2002-03-07 Thread Richard Meredith-Hardy
Thanks, but I don't believe easysw distribute the compiled command line version of htmlDOC for free, you have to compile it yourself (which I have no idea how to do) which is why I put this request out to the list. Stephen Moretti wrote: Can someone out there tell me where I can get a

Re: Stored Procedure Variables from CF

2002-03-19 Thread Richard Meredith-Hardy
THANKYOU for raising this issue... just playing with cfstoredproc and couldn't understand why I was getting strange results now I know why. (this is definitely something which is an exception to usual CF behaviour) Rosa, Issac wrote: When passing variables from ColdFusion to a MSSQL stored

Industrial strength....

2002-03-24 Thread Richard Meredith-Hardy
Detail: DB; SQLState: HYT00 DB; NativeErrorCode: 0 -- Regards; Richard Meredith-Hardy - [EMAIL PROTECTED] Mob: + 44 7771 526513 __ Get the mailserver that powers this list

Re: Column level change logging

2002-03-25 Thread Richard Meredith-Hardy
A trigger is the anawer, compare the values of INSERTED and DELETED Paul Hastings wrote: I need to record field/column level changes to a change log for a financial application. Does anyone have a good model of how to do this? isn't the sql server trans logs enough or that? if not

Re: OT: count(distinct) in MS Access

2002-03-25 Thread Richard Meredith-Hardy
I think this is right An Access DISTINCT = DISTINCTROW ie ACCCESS only accepts SELECT DISTINCT [combination of values of all columns in each row you are outputting] This is not such a big problem (unless it is a subquery) as you can do a SELECT DISTINCT count(unique_keyvalue) AS mycount,

asynchronous verity

2002-04-03 Thread Richard Meredith-Hardy
? -- Regards; Richard Meredith-Hardy - [EMAIL PROTECTED] Mob: + 44 7771 526513 __ Your ad could be here. Monies from ads go to support these lists and provide more resources

Scheduled events - client vars

2002-04-14 Thread Richard Meredith-Hardy
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 this list

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 creating a

client vars - oledb datasources

2002-04-14 Thread Richard Meredith-Hardy
after doing this setup but no difference. -- Regards; Richard Meredith-Hardy - [EMAIL PROTECTED] Mob: + 44 7771 526513 __ Your ad could be here. Monies from ads go

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

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-15 Thread Richard Meredith-Hardy
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 - [EMAIL PROTECTED] Mob: + 44 7771 526513

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.

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

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

Re: cferror weirdness

2002-04-15 Thread Richard Meredith-Hardy
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 CFINCLUDE always looks from where the including template is, not where the base template

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

Select concantenation problem

2002-01-03 Thread Richard Meredith-Hardy
.. -- Regards; Richard Meredith-Hardy - [EMAIL PROTECTED] __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free

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,

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 do the

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 Meredith-Hardy

Re: word files and databases

2002-01-09 Thread Richard Meredith-Hardy
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 -- Regards; Richard Meredith-Hardy

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: LINK REL=stylesheet TYPE=text/css HREF=style.css MEDIA=SCREEN LINK REL=stylesheet TYPE=text/css HREF=style_print.css MEDIA=PRINT by simply styling the text as very small, same colour as the

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 like

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

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 Insomniograph

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

Re: OT: Using CSS to make pretty printouts

2002-01-14 Thread Richard Meredith-Hardy
this works, (in MSIE anyway) LINK REL=stylesheet TYPE=text/css HREF=style.css MEDIA=SCREEN LINK REL=stylesheet TYPE=text/css HREF=style_print.css MEDIA=PRINT 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

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/ Best

hierarchical database.....

2002-01-18 Thread Richard Meredith-Hardy
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 - [EMAIL

Re: hierarchical database.....

2002-01-18 Thread Richard Meredith-Hardy
Partner www.macromedia.com - Original Message - From: Richard Meredith-Hardy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, January 18, 2002 10:33 AM Subject: hierarchical database. I'm having a job getting my head around this one. Essentially I am trying

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
, 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: CF-Talk Subject: CFHTTP--CFFILE I wonder if anyone could

subquery datatype prob

2002-02-08 Thread Richard Meredith-Hardy
be welcome. -- Regards; Richard Meredith-Hardy - [EMAIL PROTECTED] __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER

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

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

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 basis

Re: ArcIMS and Cold Fusion

2002-09-20 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-25 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

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

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

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 +

Re: CFX_GIFGD Help

2002-10-22 Thread Richard Meredith-Hardy
with the syntax? (The help doc isn't much help) -- Mark Smeets / stranger0 / ICQ: 1062196 [EMAIL PROTECTED] http://www.prowerks.com/stranger Life is a series of small victories - Gene Simmons -- Regards; Richard Meredith-Hardy

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
=submit type=submit value=Update Record /div/td /tr /table input type=hidden name=MM_UpdateRecord value=form2 input type=hidden name=EmpID_Muster value=cfoutput#Recordset1.EmpID_Muster#/cfoutput /form pnbsp; /p -- Regards; Richard Meredith-Hardy

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 CFIF

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

=?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. pound; or #156; 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)

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 cfquery name=newAuthorBio datasource=#application.dsn#

Re: HELP!! sql wierdness ERROR message

2002-11-04 Thread Richard Meredith-Hardy
on the first failure and display the raw uadulterated string causing 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

M$ mappoint.net

2002-11-13 Thread Richard Meredith-Hardy
, 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: http

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 possible?

Scheduled events

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

Re: Scheduled events

2003-06-03 Thread Richard Meredith-Hardy
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 work on a CF script? Q3: Would this work? Thanks -- Regards; Richard Meredith-Hardy

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 input type = file

top clause in a SP

2002-12-29 Thread Richard Meredith-Hardy
? (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=subscribeforumid=4 FAQ

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

Re: Root template directory has not been specified

2002-12-30 Thread Richard Meredith-Hardy
take out the leading / as in cfinclude template=#Application.DisplayMap#/dsp_Header.cfm Larry Juncker wrote: Here is line 17 : cfinclude template=/#Application.DisplayMap#/dsp_Header.cfm and here is Application.DisplayMap in Application.cfm cfset Application.DisplayMap = display

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

trigger problem

2003-01-09 Thread Richard Meredith-Hardy
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) -- Regards; Richard Meredith-Hardy

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
than one; 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) -- Regards; Richard Meredith-Hardy

Re: registry limit for client variables

2002-09-17 Thread Richard Meredith-Hardy
- From: Richard Meredith-Hardy [mailto:[EMAIL PROTECTED]] Sent: Monday, September 16, 2002 5:50 AM To: CF-Talk Subject: Re: registry limit for client variables Jochem I agree with all you say - and I am not too bothered by the security implications at this stage - I get

decryption and licencing

2002-06-18 Thread Richard Meredith-Hardy
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

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

Don't leave stuff lying around

2002-05-22 Thread Richard Meredith-Hardy
code, and in so doing invoked the stored procedure deletion / re-creation. Moral: Don't leave stuff lying around. -- Regards; Richard Meredith-Hardy - [EMAIL PROTECTED] Mob: + 44 7771 526513

htmldoc.exe / cf_html2pdf3 reliability?

2002-05-23 Thread Richard Meredith-Hardy
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 526513

Re: htmldoc.exe / cf_html2pdf3 reliability?

2002-05-23 Thread Richard Meredith-Hardy
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 reliability? This seems to work rather well on my dev server. Are there any

Quotes in dynamic queries

2003-09-17 Thread Richard Meredith-Hardy
# /CFQUERY /CFLOOP How to deal 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

Re: Quotes in dynamic queries [solved]

2003-09-17 Thread Richard Meredith-Hardy
in dynamic queries look at using cfqueryparam. It will escape stuff automagically. I've also used HTMLEditFormat() before too. Doug -Original Message- From: Richard Meredith-Hardy [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 7:31 AM To: CF-Talk

  1   2   3   >