Re: Windows NT error number 232 occurred

2002-05-02 Thread Simon Halcrow
Hi Joe. We get this all the time - we even get it on CF 4.5. If you type: net helpmsg 232 from a command prompt (on NT), it tells you the error means: The pipe is being closed. I assume this means that the thread(s) that exist have had nothing to do for a while and are now

CFMAIL on NT

2001-02-09 Thread Simon Halcrow
Technologies Ltd. Secure in the Knowledge Simon Halcrow Web Developer E [EMAIL PROTECTED] T +44 (0)1642 702100 F +44 (0)1642 702119 W www.sapphire.net --- Any opinions expressed in this message are those of the individual

RE: transfer excel data to sql server db thru programmatically (u rgent!)

2001-01-26 Thread Simon Halcrow
Simon Halcrow Web Developer E [EMAIL PROTECTED] T +44 (0)1642 702100 F +44 (0)1642 702119 W www.sapphire.net -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Friday, January 26, 2001 9:04 AM To: CF-Talk Subject: RE: transfer

Btrieve ODBC

2001-01-15 Thread Simon Halcrow
Hi Might not be the correct place to ask this but... grit_teeth Anyone know if there is a 32-bit ODBC driver available for Btrieve dbs? /grit_teeth Si. Sapphire Technologies Ltd. Secure in the Knowledge Simon Halcrow Web Developer E [EMAIL PROTECTED] T +44 (0)1642 702100

RE: Big companies using CF

2000-12-05 Thread Simon Halcrow
Crayola (www.crayola.com) and the University Of Teesside (www.tees.ac.uk) Sapphire Technologies Ltd. Secure in the Knowledge Simon Halcrow Web Developer E [EMAIL PROTECTED] T +44 (0)1642 702100 F +44 (0)1642 702119 W www.sapphire.net -Original Message

RE: access query crashing server...

2000-11-02 Thread Simon Halcrow
strings via Access - use SQL and its okay. I've not found any solution to it yet though ? Si. Sapphire Technologies Ltd. Secure in the Knowledge Simon Halcrow Web Developer E [EMAIL PROTECTED] T +44 (0)1642 702100 F +44 (0)1642 702119 W www.sapphire.net

OT: SQL INSERTs across multiple related tables

2000-10-24 Thread Simon Halcrow
into the Users table, second to pick up the User_ID (autonumber), third to insert details (along with the User_ID foreign key) into the NINumber table)? Any help greatly appreciated. Sapphire Technologies Ltd. Secure in the Knowledge Simon Halcrow Web Developer E [EMAIL PROTECTED] T

RE: SQL INSERTs across multiple related tables

2000-10-24 Thread Simon Halcrow
error in INSERT INTO statement. Surely, there's an easier way?! Thanks. Sapphire Technologies Ltd. Secure in the Knowledge Simon Halcrow Web Developer E [EMAIL PROTECTED] T +44 (0)1642 702100 F +44 (0)1642 702119 W www.sapphire.net

RE: SQL INSERTs across multiple related tables

2000-10-24 Thread Simon Halcrow
Thanks Shane, I have resorted to using 3 separate queries (cannot get any of the other types of INSERTs to work - anything with a JOIN in it gets spat back at me)... Should be using SQL Server I suppose! Sapphire Technologies Ltd. Secure in the Knowledge Simon Halcrow Web Developer E

RE: SQL Server equivalent of Access memo

2000-10-24 Thread Simon Halcrow
Datatype text can hold a couple of GB's...the next step down is varchar(n)... No doubt someone will correct me (I'm a newbie to SQL Server too...) Si. Sapphire Technologies Ltd. Secure in the Knowledge Simon Halcrow Web Developer E [EMAIL PROTECTED] T +44 (0)1642 702100

RE: SQL INSERTs across multiple related tables

2000-10-24 Thread Simon Halcrow
looking for an easier Access solution... Regards. Sapphire Technologies Ltd. Secure in the Knowledge Simon Halcrow Web Developer E [EMAIL PROTECTED] T +44 (0)1642 702100 F +44 (0)1642 702119 W www.sapphire.net -Original Message- From: Anthony Geoghegan [SMTP

RE: CFTalk sending multiple copies

2000-10-19 Thread Simon Halcrow
Nope. Just get the one ([EMAIL PROTECTED]) Si. Sapphire Technologies Ltd. Secure in the Knowledge Simon Halcrow Web Developer E [EMAIL PROTECTED] T +44 (0)1642 702100 F +44 (0)1642 702119 W www.sapphire.net -Original Message- From: Peter Theobald

RE: OT:MS Access and outer join - not supported?

2000-10-13 Thread Simon Halcrow
Try putting the Models table into the JOIN relationship - I've a sneaky feeling that you can't select data from JOIN'd tables, then specify an additional table which isn't involved in the join. Sapphire Technologies Ltd. Secure in the Knowledge Simon Halcrow Web Developer E [EMAIL

RE: Multiple file filters for CFDIRECTORY

2000-10-13 Thread Simon Halcrow
Chances are that the DateLastModified is also taking into account the TIME too - are all the files time and datestamped the same? (i.e. 10/10/00 12:00)? Sapphire Technologies Ltd. Secure in the Knowledge Simon Halcrow Web Developer E [EMAIL PROTECTED] T +44 (0)1642 702100

RE: Off Topic: Dual Hard drives

2000-10-10 Thread Simon Halcrow
run like a dream. Must admit though, if I could get ALL my hardware/drivers/software working in Win2k, I'd ditch 98...if only Sapphire Technologies Ltd. Secure in the Knowledge Simon Halcrow Web Developer E [EMAIL PROTECTED] T +44 (0)1642 702100 F +44 (0)1642

RE: image resize

2000-10-03 Thread Simon Halcrow
Where can I get hold of ImageResize (and/or the DLL) file? Sapphire Technologies Ltd. Secure in the Knowledge Simon Halcrow Web Developer E [EMAIL PROTECTED] T +44 (0)1642 702100 F +44 (0)1642 702119 -Original Message- From: Aidan Whitehall [SMTP:[EMAIL

RE: [CF-Talk] good examples and code of a simple drop down list populated from query?

2000-09-19 Thread Simon Halcrow
uld be displayed in the drop-down. The VALUE field is the field that is passed on to the other page (in the ACTION part of the CFFORM). The VALUE field (if left out) will default to the DISPLAY field. Si. Sponsors of the 1st Northern Information Security Conference http://www.nisc.org.uk Sap

[CF-Talk] Embedding image data on to a CF page

2000-09-19 Thread Simon Halcrow
://www.nisc.org.uk Sapphire Technologies Ltd. Secure in the Knowledge Simon Halcrow Web Developer E [EMAIL PROTECTED] T +44 (0)1642 702100 F +44 (0)1642 702119 --- Any opinions expressed in this message are those of the individual

RE: Setting NULL Value

2000-09-15 Thread Simon Halcrow
in the Knowledge Simon Halcrow Web Developer E [EMAIL PROTECTED] T +44 (0)1642 702100 F +44 (0)1642 702119 -Original Message- From: Percy E Perez [SMTP:[EMAIL PROTECTED]] Sent: 15 September 2000 13:14 To: [EMAIL PROTECTED] Subject: Setting NULL Value

RE: Services halted

2000-09-14 Thread Simon Halcrow
. Secure in the Knowledge Simon Halcrow Web Developer E [EMAIL PROTECTED] T +44 (0)1642 702100 F +44 (0)1642 702119 -Original Message- From: Aidan Whitehall [SMTP:[EMAIL PROTECTED]] Sent: 14 September 2000 10:36 To: CF-Talk (E-mail) Subject: Services

RE: I GIVE UP!

2000-09-13 Thread Simon Halcrow
in the Knowledge Simon Halcrow Web Developer E [EMAIL PROTECTED] T +44 (0)1642 702100 F +44 (0)1642 702119 -Original Message- From: Geno [SMTP:[EMAIL PROTECTED]] Sent: 13 September 2000 06:39 To: [EMAIL PROTECTED] Subject: I GIVE UP! I want

RE: I GIVE UP!

2000-09-13 Thread Simon Halcrow
Sorry - got it the wrong way round. Use NOT... SELECT tblUsers.Us_UserID FROM tblUsers WHERE (((tblUsers.Us_UserID) NOT Like '*1*')); Sponsors of the 1st Northern Information Security Conference http://www.nisc.org.uk Sapphire Technologies Ltd. Secure in the Knowledge Simon Halcrow Web

RE: CF4.5.1, Win2K and CFMAIL

2000-09-06 Thread Simon Halcrow
? Thanks. Sponsors of the 1st Northern Information Security Conference http://www.nisc.org.uk Sapphire Technologies Ltd. Secure in the Knowledge Simon Halcrow Web Developer E [EMAIL PROTECTED] T +44 (0)1642 702100 F +44 (0)1642 702119 -Original Message- From