Access SQL question

2003-03-17 Thread SRetsky
Hi: thanks, but it did not work. I tried to make changes to it for Access 2000 (tried ltrim for reverse, could not find function for charindex (tried locate, instr)) and could not get it to work. Any other trys? thanks Sandy Subject: Access SQL question From: "Mahmut Basaran" <[EMAIL PROT

Access SQL question

2003-03-16 Thread SRetsky
Hi all: I have an Access 2000 database with an email field in it. I would like to have an SQL query that gives me a count of the ISPs in the email field. For example: take the following records: 1. [EMAIL PROTECTED] 2. [EMAIL PROTECTED] 3. [EMAIL PROTECTED] 4. [EMAIL PROTECTED] 5. [EMAIL PROTECT

RE: setup HTTPS on local PC

2001-06-14 Thread SRetsky
Duane: Where can I get an SSL key for my local PC? from a company like Verisign? thanks Sandy <[EMAIL PROTECTED]> To get the https protocal working locally you have to install an ssl key on your machine Duane Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe:

RE: setup HTTPS on local PC

2001-06-13 Thread SRetsky
Hi Duane: Where can I get an SSL key for my local PC? from a company like Verisign? thanks Sandy <[EMAIL PROTECTED]> To get the https protocal working locally you have to install an ssl key on your machine Duane Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscrib

OT: setup HTTPS on local PC

2001-06-10 Thread SRetsky
--part1_dd.15d06787.28551ce9_boundary Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit Hi: I have https working fine on my web site, but I can't get it to run on my local PC where I do development and testing. When I try it now on my PC (https://testsite1/test1.cfm)

directory setup

2001-02-07 Thread SRetsky
(this email was sent to the list twice last week, but I never saw it appear. I'm on the digest) Hi Everyone: I'm building a web site where a client logs into an account and enters transactions. Once a transaction is entered by a client, the client always has access to that transaction. The

directory setup

2001-02-02 Thread SRetsky
Hi Everyone: I'm building a web site where a client logs into an account and enters transactions. Once a transaction is entered by a client, the client always has access to that transaction. The client can attach (upload) files to a transaction. I want a client to only see files attached to

directory setup

2001-02-01 Thread SRetsky
Hi Everyone: I'm building a web site where a client logs into an account and enters transactions. Once a transaction is entered by a client, the client always has access to that transaction. The client can attach (upload) files to a transaction. I want a client to only see files attached to

OT: Access SQL Date question

2001-01-15 Thread SRetsky
Hi everyone: I have an Access database. I have a date field (dateadded) w date & time in a table (activity). i want an SQL to create a table to count entries by dateadded (just the date part). something like: select count(*) as ctcount, ???(dateadded) from activity group by dateadded order b

OT: frames and back buttons

2000-04-05 Thread SRetsky
Hi everyone: I remember this came up a long time ago. I'm reviewing a site in the morning that has frames and the back button does not work very well. Has anyone successfully implemented a frame site where the browser back button was completely functional? Is there any documentation on this or