Re: sql query

2000-09-14 Thread lxy
- Original Message - From: "Dick Applebaum" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 14, 2000 3:58 PM Subject: Re: sql query > > Where ID IN (#ID_1#,#ID_2#) > > > At 3:27 PM +1000 9/14/00, avex wrote: > >hey everyone > > > >i have always used the followi

Comparing values in 2 queries

2000-09-14 Thread Roger Lim
Hi, Wanna ask for help here. Let's say that I have 2 queries which have a similar field column name. I wish to do a comparision and it's a AND critieria. For example, Field_a Field_b 1 1 2 2 3 4 5 I wish to compare field_a with fie

RE: Comparing values in 2 queries

2000-09-14 Thread Anthony Geoghegan
Hi Roger, I suggest you turn field_b into a comma delimited list using valuelist. Then cfloop through each record of field_a using a listfind to check for it's presence in the list you created from field_b. Just use a flag to indicate a failed check. |Wanna ask for help here. Let's say that I h

Services halted

2000-09-14 Thread Aidan Whitehall
Environment - Windows NT4, SP5 on Dell PC-based hardware, ColdFusion 4.0.1 Professional, non-clustered environment. Has anyone come across the situation where web-services and SMTP services are randomly stopped, possibly by SiteMinder? The network administrator is trying to identify what's causi

Re:

2000-09-14 Thread JustinMacCarthy
There are loads. list-serv Majordomo in fact http://www.landfield.com/faqs/mail/list-admin/software-faq/ Have a look here ~JustinMacCarthy - Original Message - From: "William J Wheatley" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, September

Re: Cryotic Keys again

2000-09-14 Thread JustinMacCarthy
What you need to do is create two numbers which when used together give you a unique / secure value. So when then user subscribesto your site get the regid and format like 1 (9 digits) (use numberformat) and also create a random value of length 21 (for example) and store to with your r

RE: Sub entities

2000-09-14 Thread DeVoil, Nick
> I have jsut been talking to some developers here and tried to explain what > sub entities are and how they are used within a relational database. Does > anyone have any examples of sub entities being used in real life and how > they were built? In particular how you define the exclusivity of t

Re: Cryotic Keys again

2000-09-14 Thread Rob Keniger
on 14/9/2000 7:53 PM, JustinMacCarthy at [EMAIL PROTECTED] wrote: > What you need to do is create two numbers which when used together give you > a unique / secure value. Surely that is what CreateUUID() does? Or have I missed something? Rob Keniger

RE: Services halted

2000-09-14 Thread Simon Halcrow
There's a bug in the SMTP.dll file in CF 4.0 - upgrade to 4.5.1 to cure it. I've been told there is a patch on the Allaire site to upgrade the DLL if that's a better option for you. Sponsors of the 1st Northern Information Security Conference http://www.nisc.org.uk Sapphire Technologies Ltd. S

Re: Cryotic Keys again

2000-09-14 Thread JustinMacCarthy
UUID does create a globaly unique value (BTW CreateUUID in CF is formatted incorrectly) How ever it does not create a unique PAIR of values. Also UUID functions tend to give sequential values For example , for I run CreateUUID twice in a row... 1BBF0354-8A59-11D4-955E0050DA7875E0 1BBF0355-8A59

Re: Alternatives to Access?

2000-09-14 Thread Bud
On 9/14/00, avex penned: >Just a few questions >I am using SQL on a shared hosting environmentand they say that under no >circumstances can we have access to the Enterprise manager...no matter how >locked down it is. >Is this a common practice? >Do people have access to this with hosters o

Re: Cryotic Keys again

2000-09-14 Thread Rob Keniger
on 14/9/2000 8:26 PM, JustinMacCarthy at [EMAIL PROTECTED] wrote: > It is the combination of 2 random values that gives a secure key... Thanks for the clarification and explanation, that makes perfect sense. Rob Keniger [EMAIL PROTECTED] __

Re: Comparing values in 2 queries

2000-09-14 Thread Bud
On 9/14/00, Roger Lim penned: >Hi, > >Wanna ask for help here. Let's say that I have 2 queries which have a >similar field column name. I wish to do a comparision and it's a AND >critieria. > >For example, > >Field_a Field_b >1 1 >2 2 >3 4 >

Re: Zip Code Search in CF?

2000-09-14 Thread Joel Richards
You can purchase a yearly subscription from jcsm.com and that entitles you to a years worth of monthly updates. Joel At 08:23 PM 9/13/00, you wrote: >I want to own the DB so I don't have to rely on another site. > >Thanks, > >Neil > >- Original Message - >From: "Steve Pierce" <[EMAIL PRO

Email - Reply-to:

2000-09-14 Thread Randy Adkins
Does anyone know a way to add the header reply-to: to a cfmail message? I tried it in the first line fo the body and does not work. I want to send an email from one account but have it replied to at another account. Any ideas?? ---

Re: Email - Reply-to:

2000-09-14 Thread JustinMacCarthy
CFMAILPARAM CFMAILPARAM can either attach a file or add a header to a message. If you use CFMAILPARAM, it is nested within a CFMAIL tag. You can use more than one CFMAILPARAM tags within a CFMAIL tag in order to attach one or more files and headers. See also CFMAIL. Syntax or

Populating more than one Select

2000-09-14 Thread W Luke
Hi, One one of my pages I have a Select which is dynamically populated using some simple SQL. What I now need to do is dynamically populate another Select, based on the selection of the first Select Box. I don't want to load the page twice. Is this possible? I hope I've made my question clear.

RE: Populating more than one Select

2000-09-14 Thread mherbene
You would want http://devex.allaire.com/developer/gallery/info.cfm?ID=CA347197-2830-11D4-AA 9700508B94F380&method=Full -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 14, 2000 8:08 AM To: [EMAIL PROTECTED] Subject: Populating more than one Select Hi,

RE: Email - Reply-to:

2000-09-14 Thread Randy Adkins
I take it that CFMAILPARAM is in CF 4.5? I found nothing in 4.01 -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 14, 2000 8:05 AM To: [EMAIL PROTECTED] Subject: Re: Email - Reply-to: CFMAILPARAM CFMAILPARAM can either attach a file or add a

Re: Email - Reply-to:

2000-09-14 Thread JustinMacCarthy
Sorry, yes should have said that !!! Other options a) If you install iMS post server you can add any headers you want B) look at the cfx_mail tag http://devex.allaire.com/developer/gallery/info.cfm?ID=CA347392-2830-11D4-AA 9700508B94F380&method=Full ~Justin - Original Message - From

Re: Zip Code Search in CF?

2000-09-14 Thread Sima Lee
Hi, There is one created by Jeef Beer called "CF-ziprad". You can download it from Allaire site. It works very well . Sima - Original Message - From: John McKown <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Sent: Wednesday, September 13, 2000 5:45 PM Subject: Zip Code S

Re: Populating more than one Select

2000-09-14 Thread W Luke
Thanks. I've tried it out - unfortunately it's populating the same in the 2nd box every time. Have you set this up before and/or would you mind me pasting my code here? Cheers, Will - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 14, 200

RE: Populating more than one Select

2000-09-14 Thread Stephen Moretti
> > Thanks. I've tried it out - unfortunately it's populating the same in the > 2nd box every time. Have you set this up before and/or would you mind me > pasting my code here? > I've successfully used the 2 related selects tag before. Sounds like you're not populating it with the correct que

RE: transferring SQL server DB to an ISP

2000-09-14 Thread Mike Amburn
> You can back it up to file on the source > machine, then send that file off to the target machine, where the > administrator of that machine could then restore it from the > file. i have not had any luck using this method. it was really simple on SQL6, however SQL7 seems to require that the ba

Re: Multiple s

2000-09-14 Thread Sima Lee
Hi, Roger, What do you want to achieve? Do you want the inner loop repeat the out loop's output ? Then how many times? This will give you the times EQ to the second query's recordcount. Sima - Original Message - From: Roger Lim <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday,

Re: Populating more than one Select

2000-09-14 Thread W Luke
OK. I have a "Main Categoies" table (categories) and a "Sub Categories" table (sub_categories). 'categories' has columns of ID and cat_name and 'sub_categories' has columns of sub_name, cat_id, sub_id - cat_id is in place to link to the ID in 'categories'. I'm unsure of the query needed, and

Javascript Compatability Issue

2000-09-14 Thread Curtis C. Layton
Hello Everyone, I'm having a DHTML compatablity issue w/Netscape. I was hoping you could help; here's the problem: This is an ordering system, the layers work with IE, but in Netscape I can only get 11 Container layers to show, the others return "object undefined". The Plan features and Plan Tex

Re: Populating more than one Select

2000-09-14 Thread Sima Lee
Hi, I remember I had the same problem before, by change the SQL statement to "Select distinct." the problem was gone. I don't know if your problem is the same, but give it a try won't hurt. Hope it will help. Sima - Original Message - From: W Luke <[EMAIL PROTECTED]> To: <[EMAIL PR

Re: Populating more than one Select

2000-09-14 Thread W Luke
I tried that, but no luck :( Thanks anyway Will - Original Message - From: "Sima Lee" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 14, 2000 2:32 PM Subject: Re: Populating more than one Select > Hi, > > I remember I had the same problem before, by change the SQ

Re: Stored Procedure Help Again

2000-09-14 Thread Jerry Tolentino
You don't have to perform another query. The last query that is performed on a Stored Proc is the one that gets returned at the end. In your example the query you performed gets returned at the end even if its not the last statement. Try it and see. SELECT FirstName, LastName FROM Members WHERE

RE: Stored Procedure Help Again

2000-09-14 Thread Andy Ewings
OR...declare a variable @rowcount and set it = rowcount like so... SET @FirstName = @FirstName + '%' SELECT FirstName, LastName FROM Members WHERE FirstName LIKE @FirstName AND LastName = @LastName SELECT @rowcount = @@rowcount -- If not listed return 1 IF @rowcount = 0 BEGIN RETURN 1

RE: Javascript Compatability Issue

2000-09-14 Thread DeVoil, Nick
> I'm having a DHTML compatablity issue w/Netscape. Curt 3 things: 1. As far I can see you're setting the visibility property of the objects to "visible" or "hidden" in both IE & Nav, but in Nav I think you say "show" and "hide" 2. Could you snip the code a bit to make it easier for us? 3.

Re: Javascript Compatability Issue

2000-09-14 Thread Curtis C. Layton
Here's a snipped version. Thanks for the help i'll try the JS email also. -Curt >2. Could you snip the code a bit to make it easier for us? Snipped to Functions, and Divs > > function clearLayers(PartialLayerName)

RE: Scenario

2000-09-14 Thread Correa, Orlando (ITSC)
You might want to take a look at the http://alive.allaire.com stuff... It may give you some ideas on how you could use realplayer in this scenario. Orlando Correa IHS Web Team Web Applications Developer, DBA http://my.ihs.gov -Original Message- From: Tim Bahlke [mailto:[EMAIL PROTEC

RE: Scenario

2000-09-14 Thread David E. Crawford
This is a multi-part message in MIME format. --=_NextPart_000_0111_01C01E55.B0577930 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit RE: ScenarioCheck out www.presentplus.com. They specialize in this kind of thing. It isn't CF, but works. It is a com

Password Protected Directories...

2000-09-14 Thread [EMAIL PROTECTED]
Hi! I am using NT 4.0 with IIS 4.0 (Service Pack 6a). I have made a site on my server and I want to protect a particular directory with a user name and password (I have all the administrator rights). Therefore, while browsing a site no visitor can access this directory without supplying correc

RE: Services halted

2000-09-14 Thread Aidan Whitehall
> There's a bug in the SMTP.dll file in CF 4.0 - upgrade to > 4.5.1 to cure it. > > I've been told there is a patch on the Allaire site to > upgrade the DLL if that's a better option for you. 4.5.1 isn't an option for the moment, so I'll see if I can track it down the dll. Thanks -- Aidan

DateTimeDiff

2000-09-14 Thread Aidan Whitehall
Is there DateDiff function that allows you to compare DateTime objects, not just Date Objects? I need to flag a record yellow if it's an hour overdue, orange if it's two hours overdue and red for anything more than that. Thanks -- Aidan Whitehall <[EMAIL PROTECTED]> Netshopper UK Ltd Advanced

Re: Password Protected Directories...

2000-09-14 Thread Paul Underwood (massmail)
Hi >I am using NT 4.0 with IIS 4.0 (Service Pack 6a). I have made a site on my >server and I want to protect a particular directory with a user name and >password (I have all the administrator rights). Therefore, while browsing >a site no visitor can access this directory without supplying cor

RE: DateTimeDiff

2000-09-14 Thread mherbene
DateDiff should work -you can specify intervals down to seconds. -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 14, 2000 10:45 AM To: CF-Talk (E-mail) Subject: DateTimeDiff Is there DateDiff function that allows you to compare DateTime obje

RE: URGENT: SUM() QUESTION

2000-09-14 Thread Venu Pillai
try this to see if it consolidates your result to grant total. Your original query sums up 1 pic,sic, student for that membername and returns those rows. select sum(sum(pic) + sum(sic) + sum(student)) as grandtotal from aeps.dbo.flighttimes where membernumber=117 venu -Original Message-

Re: DateTimeDiff

2000-09-14 Thread JustinMacCarthy
Yes, it's DateDiff , use "h" for the datepart. DateDiff(datepart, date1, date2) datepart One of the following strings: a.. -- Year b.. q -- Quarter c.. m -- Month d.. y -- Day of year e.. d -- Day f.. w -- Weekday g.. ww -- Week h.. h -- Hour i.. n -- Minute j.. s -- S

RE: CFLDAP & SSL

2000-09-14 Thread Reed Powell
Steve: Are you using NT or U* for your LDAP server? What you describe is what I used to do, which worked when the LDAP server was on an NT machine. However, it only works because of a bug in NT that allowed the authentication to work over a non-SSL connection (ie, the password was being passed a

RE: Services halted

2000-09-14 Thread Aidan Whitehall
> There's a bug in the SMTP.dll file in CF 4.0 - upgrade to > 4.5.1 to cure it. > > I've been told there is a patch on the Allaire site to > upgrade the DLL if > that's a better option for you. Simon... just to confirm - when you say there is a patch, do you mean upgrade from 4.0 to 4.0.1? O

registering Excel COM object

2000-09-14 Thread Pete
Hello all, I hope that someone can help with a quick question: I'm trying to use cfobject to access an excel document, but I need to register the object on my machine. Does anyone know how to do this, step by step? I'm a little off on this subject and would like to learn how to do it. Thank y

RE: Populating more than one Select

2000-09-14 Thread Walker, Rick R
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C01E5B.7A98C1A4 Content-Type: text/plain; charset="iso-8859-1" When I go to the link http://devex.allaire.com/developer/gallery/

RE: transferring SQL server DB to an ISP

2000-09-14 Thread Dan O'Keefe
|i have not had any luck using this method. it was really simple on SQL6, |however SQL7 seems to require that the backup file being restored must |have come from the same machine it's being restored to. i've even tried |to create a temp backup file, replace it with a new backup file that |includes

Re: Populating more than one Select

2000-09-14 Thread Howie Hamlin
That's because the full link got split across two line. Put the following two lines together in your browser URL: http://devex.allaire.com/developer/gallery/info.cfm?ID=CA347197-2830-11D4-AA 9700508B94F380&method=Full HTH, Howie - Original Message - From: "Walker, Rick R" <[EMAIL PRO

RE: Generate Stored Procedure for Prepared Statement

2000-09-14 Thread DeVoil, Nick
> What does "Generate Stored Procedure for Prepared Statement" do in the > SQL Server driver section of the ODBC management of the CF Administrator? Ken This is an ODBC feature which applies to the execution of dynamic queries. WHen you access SQL Server via a low-level database library you hav

Re: Populating more than one Select

2000-09-14 Thread W Luke
U want to go here: http://devex.allaire.com/developer/gallery/info.cfm?ID=CA347197-2830-11D4-AA 9700508B94F380&method=Full > Will - Original Message - From: "Walker, Rick R" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 14, 2000 3:52 PM Subject: RE: Populating mor

RE: registering Excel COM object

2000-09-14 Thread Dan O'Keefe
Pete, You did not mention which OS, but I am not sure it matters. I know for NT & 2K from the command line it is: regsvr "program files\office\excel\excel.dll" (quotes are necessary in this case due to the space) Obviously path is whatever it is on your machine to the dll as well as t

RE: transferring SQL server DB to an ISP

2000-09-14 Thread Sean Brown
|i have not had any luck using this method. it was really simple on SQL6, |however SQL7 seems to require that the backup file being restored must |have come from the same machine it's being restored to. i've even tried |to create a temp backup file, replace it with a new backup file that |includes

Verity query for a many-to-many relationship

2000-09-14 Thread Park, Simon
I'm using a query to populate a Verity index the records of Table A which has a many-to-many relationship with Table B. I want to be able to search by a the data in a column of B. The query I'm currently using is this: SELECT A.a_id, A.a_text, B.b_text FROM

Re: Populating more than one Select

2000-09-14 Thread Bud
On 9/14/00, W Luke penned: > > SELECT ID, cat_id, cat_name, sub_name FROM categories, sub_categories > ORDER by cat_name > Try: SELECT ID, cat_id, cat_name, sub_name FROM categories c, sub_categories s WHERE c.cat_id = s.cat_id ORDER by cat_name > > QUERY="findcats" > NAME1="Cat

Re: Alternatives to Access?

2000-09-14 Thread Eron Cohen
Hi, While our ISP (edgewebhosting.com in Maryland) does not allow us to use the enterprise manager, we are able to use the MS Access 2000 front end for SQL Server to access our data and to change tables...its a fantastic improvement over using an MS Access .mdb database. For instance, because we

RE: registering Excel COM object

2000-09-14 Thread David E. Crawford
This is a multi-part message in MIME format. --=_NextPart_000_014C_01C01E5E.87786F70 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit RE: registering Excel COM objectIf Excel is properly installed on the server, the COM object will already be registered.

RE: Querystring problem

2000-09-14 Thread Jon Gage
That worked, thanks a lot! Cheers, Jon > -Original Message- > From: Justin Kidman [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 13, 2000 1:31 PM > To: '[EMAIL PROTECTED]' > Subject: RE: Querystring problem > > > Should be CGI.Query_String, but that value you will always exist.

RE: Zip Code Search in CF?

2000-09-14 Thread Steve Pierce
Neil H. Wrote: >> I want to own the DB so I don't have to rely on another site. You get the data to install on your own computer. You do not depend on another site for searches, data exchange or lookup. You can even use this on a computer not connected to the Internet. (Gee are there such things

RE: transferring SQL server DB to an ISP

2000-09-14 Thread paul smith
--=_142334776==_.ALT Content-Type: text/plain; charset="us-ascii"; format=flowed BOL has the following: "The detached files remain and can be reattached using sp_attach_db or sp_attach_single_file_db. The files can also be moved to another server and attached." So does thi

RE: Alternatives to Access?

2000-09-14 Thread Steve Pierce
I believe Shanje.com allows you to use Enterprise manager. You can even upsize from Access to SQL over the internet, it is pretty cool. - Steve -Original Message- From: avex [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 14, 2000 1:32 AM To: [EMAIL PROTECTED] Subject: Re: Alterna

RE: Populating more than one Select

2000-09-14 Thread Dempsey, Timothy F.
Will, I believe that if you add a "where clause" to your SQL SELECT statement you may get what you want. This where clause will make sure that your DBMS associates the records in the table sub-categories with the appropriate ones in the table categories. Here's an example of what I mean: SE

CF 4.5

2000-09-14 Thread Randy Adkins
Does anyone have a link to the white paper of CF 4.5 and what features are provided that CF 4.01 does not have or what improvements were made? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubsc

WDDX problems (URGENT)

2000-09-14 Thread Paul Johnston
HELP! I have just built a really nice site on my production server, using WDDX, passing loads of variables in WDDX and storing it in the database. However, transferring it over has meant that for some reason, the wddx string is getting chopped off, so that it is incomplete, and so CF is throwing

dynamic variable label creation

2000-09-14 Thread Stas Newdel
Hello, I am creating a form on the fly, and on the action page I am trying to create session variables like this: so if three form vars were passed: priority_rush, priority_standard, priority_economy, I want to create three session variables

RE: Syntax Error in Forums

2000-09-14 Thread Steve Pierce
I am getting the following error on a new installation of Forums 2.06. I have tested this with MDAC 2.1 SP1 and MDAC 2.5 Sp1 and get the same problem. This is the error when I try to edit or add a user in the system. Any suggestions. ODBC Error Code = 37000 (Syntax error or access violation) [Mi

Validating Phone Numbers

2000-09-14 Thread Chuck Hergenroeder
Does any one know of a custom tag that will validate US and International Phone Numbers? If not do you know how I could accomplish this? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscrib

Vertical alignment of data table

2000-09-14 Thread Walker, Rick R
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_001_01C01E76.252E8E9A Content-Type: text/plain; charset="iso-8859-1" I'm having a problem coming up with a way that will display recor

Date in SQL

2000-09-14 Thread W Luke
Hi, I have a Date/Time column in a Table (called expiry_date), with dates in it such as 30/09/2000 I need to run some SQL on it as shown below - but it's not returning any results. What is the correct method of searching for dates in SQL? SELECT body, expiry_date FROM advert_details WHERE date

hexadecimal values in a cookie

2000-09-14 Thread jamesa {James Alexander}
cf 4.5 IIS 4.0 I'm trying to pass a url as a cookie called DOC to another webserver in my domain. That webserver performs an authentication routine and should then redirect back to my page (based on the value of DOC). However, the value of the cookie that is set reads as: DOC=https%3A%2F%2Fwww%

Photo Database App

2000-09-14 Thread Kent A. Orso
Does anyone out in CF-Land know of a photo database app written in CF? What I am looking for is a database app that would allow you to bring up a page with multiple thumbnails of photos with possibly a small description. The text and photos (thumbnails and originals) would be indexed int he databa

RE: cflocking.. -- ATTENTION -- MY CASE STUDY

2000-09-14 Thread Mike Amburn
i'd disagree... if you look back over all the emails in all of the threads, you should see that more people only lock writes versus locking both. that consensus by the majority is what i was commenting too. -mike > -Original Message- > From: Peter Theobald [mailto:[EMAIL PROTECTED]] > Se

Re: latest on cf and PDF?

2000-09-14 Thread Stephen M Aylor
have you looked at www.pdflib.com? or www.fastio.com? Look on www.pdfzone.com or www.planetpdf.com amd or www.acrobuddies.com web board forum. Seems like everyday I turn around there is a new pdf generation tool showing up. Sorry to respond sooo late (story of my life I guess) SteveA > is t

Re: Alternatives to Access?

2000-09-14 Thread paul smith
How? pcAnywhere? best, paul At 08:12 AM 9/14/00 -0700, you wrote: >While our ISP (edgewebhosting.com in Maryland) does >not allow us to use the enterprise manager, we are >able to use the MS Access 2000 front end for SQL >Server to access our data and to change tables... --

RE: sql query

2000-09-14 Thread Anthony Geoghegan
Hi Chad, SELECT Storename, ID, City FROM review Where ID IN ('#ID1#, #ID2#') Regards, Anthony Geoghegan. Lead Developer, IFTN http://www.wow.ie mailto:[EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-t

Newbie: Refreshing screen after update

2000-09-14 Thread Olson, Kelly
I have a form that allows one to update company informaion. Upon submitting the data it reloads the same page and updates changed information. ( no big deal so far ) There is also a HTML link back to the main menu. (CLICK - this appears to work fine.) The problem is if I select the menu item tha

SQLDA Error

2000-09-14 Thread FWA
This is a multi-part message in MIME format. --=_NextPart_000_0013_01C01E69.76F8F380 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am running a and I am getting an error from Progress with = this descripiton: SQLDA structure not allocat

Background images

2000-09-14 Thread Gieseman, Athelene
I'm having trouble getting background images to work properly on CF pages. Is there something in particular I should be doing to make this work? All of the other formatting in the BODY tag is working fine. But the image doesn't show. It works fine on non-CF pages. Athelene [EMAIL PROTECTED] --

Re: DateTimeDiff

2000-09-14 Thread Mark Adams
Something like this should work for you. Hello your #chktime# hour(s) late Good Luck! -Mark :o) - Original Message - From: Aidan Whitehall <[EMAIL PROTECTED]> To: CF-Talk (E-mail) <[EMAIL PROTECTED]> Sent: Thursday, September 14, 2000 7:44 AM Subject: DateTimeDiff > Is

Getting a background image to stick

2000-09-14 Thread Gieseman, Athelene
I've been trying to use a background image on some CF pages. The colors, fonts, and all other format options in the body tag seem to work. But the image doesn't display. Can anyone tell me what I might be doing wrong? Also, I need an address to reach a list admin. Seems I'm getting all of m

Re: dynamic variable label creation

2000-09-14 Thread Charles A. Lee
At 10:55 AM 9/14/00 , you wrote: >... creating a form on the fly, >create session variables like this: > > >...[snip] > >... Dynamic variables must be a common problem. I tried coding this as a variable within a variable and it didn't work. Member #memberindex# Name: #Member###memberindex###Fi

Re: MS Access getting the FieldID from a newly inserted record

2000-09-14 Thread [EMAIL PROTECTED]
- Original Message - From: "Eric Dawson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 12, 2000 12:20 PM Subject: MS Access getting the FieldID from a newly inserted record I am using access 2000 for an intranet site, and would like to know how to get the record

FW: Comparing values in 2 queries

2000-09-14 Thread Chapman, Katrina
Sorry made a mistake and sent before I was done last time That should have read. SELECT field_a FROM table WHERE field_a NOT IN (SELECT field_b FROM table) This is bad = #field_a# The only prob with this is when either field has thousands of entries. --K

RE: Comparing values in 2 queries

2000-09-14 Thread Chapman, Katrina
You're right this can be done with a simple query SELECT field_a FROM table WHERE field_a NOT IN (SELECT field_b FROM table) This is bad = #field_a# > -Original Message- > From: Bud [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 14, 2000 3:57 AM > To: [EMAIL PROTECTED] > Subje

Mail Processing and CF Server

2000-09-14 Thread AustralianAccommodation.com Pty. Ltd.
I have a question does cf have the mail facility so that email aliases can be set up for each member of my website so that emails sent to these members are sent to the email alias eg [EMAIL PROTECTED] via my websites and then auto forwarded to the website members actual email address let me expl

RE: hexadecimal values in a cookie

2000-09-14 Thread Cameron Childress
URLDecode(urlEncodedString) -Cameron Cameron Childress ElliptIQ Inc. p.770.460.7277.232 f.770.460.0963 > -Original Message- > From: jamesa {James Alexander} [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 14, 2000 12:11 PM > To: Cftalk (E-mail) > Subject: hex

Re: Populating more than one Select

2000-09-14 Thread W Luke
Thanks for this. I tried it but it returned a "Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1" error. I've checked all the fields - all are correct - what else could this error mean? Thanks, Will - Original Message - From: "Bud" <[EMAIL PROTECTED]> To: <[EMAIL

500 - Server Error

2000-09-14 Thread Karl Simanonok
While developing offline I have been using CF 4.5.1 with MSIE 5.0 and O'Reilly's Website version 1.1. I don't use Studio, but instead TextPad. No problems for a very long time. Suddenly two days ago (no new software, hardware, or configuration changes) MSIE consistently returns a "500 - Server

RE: CF 4.5

2000-09-14 Thread Cameron Childress
One of these should do the trick: ColdFusion 4.5 Feature Comparison Matrix: http://www.allaire.com/Products/ColdFusion/features/CF45ServerFeatureMatrix. doc CFML 4.5 Language Reference Chapters one and two, New Tags in ColdFusion 4.5 and New Functions in ColdFusion 4.5, respectively: http://www.

RE: DateTimeDiff

2000-09-14 Thread Aidan Whitehall
> Yes, it's DateDiff , use "h" for the datepart. > > DateDiff(datepart, date1, date2) > [snip] > i.. n -- Minute > j.. s -- Second Great - thank you. -- Aidan Whitehall <[EMAIL PROTECTED]> Netshopper UK Ltd Advanced Web Solutions & Services http://www.netshopperuk.com/ Telephone +44 (0

RE: Decimal places ??

2000-09-14 Thread Aidan Whitehall
> The only thing I've found is to use enough '9's to make sure > you cover the > length. Unfortunately, (unless someone else knows) you can't > do infinity > before the decimal points. > #NumberFormat(yournumber,"99.99")# You can also try DecimalFormat (possibly

Re: Mail Processing and CF Server

2000-09-14 Thread [EMAIL PROTECTED]
I know Imail from Ipswitch runs with an ODBC mail database, and suspect that many others are as well. That makes it very easy to create and forward email programmatically. What are you using for a mail server? -- Archiv

RE: hexadecimal values in a cookie

2000-09-14 Thread Cameron Childress
If you URLDecode() the cookie *after* reading it out of the browser it should. Is that what you are doing? IE: -Cameron Cameron Childress ElliptIQ Inc. p.770.460.7277.232 f.770.460.0963 > -Original Message- > From: jamesa {James Alexander} [mailto:[EMAIL PROTECTE

Re: Populating more than one Select

2000-09-14 Thread W Luke
Found solution to previous problem WHERE c.cat_id = s.cat_id It should be c.ID as there is no such field as cat_id in categories. However; this too produces an error: [Microsoft][ODBC Microsoft Access Driver] Type mismatch in expression. What on earth does that mean? Will - Original Messa

OT: MSSQL7 indexing

2000-09-14 Thread Adrian Cesana
Can anyone point me to some good articles on MSSQL7 indexing, more specifically Cluster Index's. I have a DB that is getting quite large and is getting slower and slower. I realize much of it may be related to our CF application but I want to be sure my index's are productive. Thanks,Adrian --

RE: hexadecimal values in a cookie

2000-09-14 Thread jamesa {James Alexander}
The other server where the authentication routine runs is not a CF server. And I can't do anything about the way it reads the cookie. Cookies set via cgi on other unix servers in the domain work properly, but the cookies that I set with cold fusion don't. > -Original Message- > From: Cam

VeriSign Custom Tag

2000-09-14 Thread Double Down
Does anyone know of a custom tag for using VeriSign's credit card processing and batching process? TIA DDINC -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffu

Triggers and exceptions

2000-09-14 Thread Francisco Montes; Spain on Line
This is a multi-part message in MIME format. --=_NextPart_000_00AA_01C01E86.E4833970 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all, A tough one... for me at least. :-) We have got a table in SQL Server 7. In that table we have two

RE: WDDX problems (URGENT)

2000-09-14 Thread David E. Crawford
This is a multi-part message in MIME format. --=_NextPart_000_0027_01C01E87.3414F1E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit WDDX problems (URGENT)When do these truncations occur? Do you really have WDDX packets 64K in size? We need a bit more

Mass emailing (but not spamming :)

2000-09-14 Thread Dana Larose
Hey everyone, One of my clients has a database of about 2500 clients, each of whom is subscribed to recieve a report that is generated once a month. The want to move towards sending a PDF via email, instead of the heavy faxing. Before I give them a quote on this thing, I would like to know if

ColdFusion training through WestLake

2000-09-14 Thread Claremont, Timothy S
I am signed up for ColdFusion training through a company called "WestLake Internet Training" (http://www.westlake.com) next week in Boston. Anyone heard anything good or bad concerning this trainer? I will be glad to post feedback on their training when I return. Tim

  1   2   >