RE: Bulk restoring databases

2002-02-27 Thread Ian Tait
You could script it... From tsql help: This example restores a full database and transaction log and moves the restored database into the C:\Program Files\Microsoft SQL Server\MSSQL\Data directory. RESTORE DATABASE MyNwind FROM MyNwind_1 WITH NORECOVERY, MOVE 'MyNwind' TO

Re: CF Mail and SMTP Auth

2002-02-27 Thread Jochem van Dieten
Jim McAtee wrote: Can CF Server be configured to use SMTP authorization to relay mail through a remote server that requires SMTP Auth? No. But after a glance through RFC 2554 it looks feasible to make sure that the MTA accepts authentication of the From:email AUTH=password type and just

Re: ORDER BY in a query of queryies (built with QueryNew)

2002-02-27 Thread Zac Spitzer
cfoutput query=getorders cfinclude template=cart_items.cfm cfloop query=cartquery cfset NewRow = QueryAddRow(products) cfset Temp = QuerySetCell(products, qty, #cartquery.qty#) cfset Temp = QuerySetCell(products, owner,

Query angst!

2002-02-27 Thread Crispin Ryan
Help! I've got three tables - resources (resource_id, description, total_available) resources allocated: (allocation_id, resource_id, event_id) and events with event_id and event_date My output for each event has to show: All resource names, and the total number of each resource booked on that

CFTempOnlyForSetVariableNeverUseThisNameInYourCFMLCode error

2002-02-27 Thread Earl, George
We received the following error from CF 5.0 this morning: Error Occurred While Processing Request Error Diagnostic Information An error has occurred while processing the expression:

'Edit with CF Studio' with right-click in Windows Explorer

2002-02-27 Thread Earl, George
After upgrading to Studio 5.0 I lost the 'Edit with CF Studio' option when I right-click on a cfm or html file in Windows Explorer. How can I get this back or is this a new feature of Studio 5.0? Thanks! George __ Why Share?

Re: CFTempOnlyForSetVariableNeverUseThisNameInYourCFMLCode error

2002-02-27 Thread Dave Carabetta
We received the following error from CF 5.0 this morning: Error Occurred While Processing Request Error Diagnostic Information An error has occurred while processing the expression:

Re: too much cookie?

2002-02-27 Thread savan . thongvanh
depends on how much else you're sending back and forth but more than li kely not. (speaking AS a dialup user :) ) [EMAIL PROTECTED] on 02/26/2002 05:52:48 PM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: too much cookie? I'm wondering if using a

Re: CFPOP and html stripping

2002-02-27 Thread Tyler Silcox
You can grab the HTML part of the multi-part message from your attachments directory that you specify with the AttachmentsPath attribute of cfpop. CF saves your HTML part of the message with a unique filename, without a file extension. So you'll have to parse out the real attachments first, and

OT: Non-Wrapping strings in IE5

2002-02-27 Thread Carlisle, Eric
This is pretty odd. I noticed that strings of certain characters just won't warp in IE5. ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! -- Put this in a fixed width table. It won't wrap when it's supposed to.

CFREPORT :: (CRPE32.DLL) could not be located

2002-02-27 Thread Paul Ihrig
ok? where do i get this dll? i thought cfreport was standard in 5? first time messing with it. do i actually need crystal on my local machine to test some one else's report? thanks -paul Error occurred while processing CFREPORT The Crystal Reports Engine (CRPE32.DLL) could not be located on

RE: CFREPORT :: (CRPE32.DLL) could not be located

2002-02-27 Thread Hays, Duncan
I'm pretty sure you need Crystal installed to produce the report. I know that it WASN'T included with 4.5 and isn't in 5. If it's running non-locally you might be able to set the full path to the Crystal server or you could call it directly http://./myreport.rpt;. If called directly it

RE: CFREPORT :: (CRPE32.DLL) could not be located

2002-02-27 Thread Paul Ihrig
i thought there was a scaled down version on cf server 4.5 ent we have reports around here some where but i thought 5 would have it built in! ok... can i install it from 4.5? -paul -Original Message- From: James Maltby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002

Access - MS SQL script?

2002-02-27 Thread Louis Klepner
Hello Fellow CF'ers, I was wondering if anyone knew of a script that would analyze a Access Database and replicate the structure in SQL? Something which loops through the tables, checks data types, and creates a MS SQL version of the database- Thanks, Lou Klepner

RE: CFREPORT :: (CRPE32.DLL) could not be located

2002-02-27 Thread Hays, Duncan
I don't think CF4.5 has anything other than the tag. We got a demo of Crystal Reports 8.0 which let you install the web reporting functionality on the web server. Then we ended up buying Crystal Enterprise 8.0 and CR 8.5. Enterprise 8.0 is a whole app to administer your reports which we don't

Re: Access - MS SQL script?

2002-02-27 Thread Stephen Moretti
Hello Fellow CF'ers, I was wondering if anyone knew of a script that would analyze a Access Database and replicate the structure in SQL? Something which loops through the tables, checks data types, and creates a MS SQL version of the database- You can just open up SQL Server Enterprise

RE: Access - MS SQL script?

2002-02-27 Thread David Schmidt
Just make sure that your data is imported properly, particularly where autonumbers must become identity fields. It can also cause duplicating d ata every once in a while. -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 7:06 AM To:

RE: Access - MS SQL script?

2002-02-27 Thread Louis Klepner
Thanks for the advice, and I wish it were that easy for me... but I'm i n a shared hosting environment and don't have access to the SQL Server Mana ger. Could I do this on my development machine, then somehow export a script which would replicate the database on the actual server? Or am I stuck

RE: Access - MS SQL script?

2002-02-27 Thread Declan Maher
use the upsizing wizard in Access after you grt username and pass from the person in charge of sql server. -Original Message- From: Louis Klepner [mailto:[EMAIL PROTECTED]] Sent: 27 February 2002 15:44 To: CF-Talk Subject: RE: Access - MS SQL script? Thanks for the advice, and I wish

RE: Template running more than once?

2002-02-27 Thread Shawn Grover
It is an action page for a form, but the submit button is NOT being double-clicked. I guess I can add this code to see if the browser somehow thinks a double click is being done, but I don't think that is the issue. Thanks though. Shawn Grover -Original Message- From: Chad Gray

OT JS again

2002-02-27 Thread savan . thongvanh
sorry for all the js stuff today. have a function to write a select box of states. is it faster, in general, to write text to a page with a function or return a string and write the string? Thanksabunch, Savan __ Get Your Own

Form field values on post

2002-02-27 Thread Hays, Duncan
I'm trying to post a form and then, on the page I'm posting to, loop through all the form fields and get the values. I've been shown form.formfields and that great for the names but how to I get the values out. I can't come up with the syntax. *I'll use JavaScript prior to the submit if I have

RE: Form field values on post

2002-02-27 Thread David Schmidt
on the action page... cfloop list=#form.fieldnames# index=fieldname cfset thisvariablename = Form. #fieldname# cfoutput#fieldname# = #evaluate(#thisvariablename#)/cfoutput /cfloop -Original Message- From: Hays, Duncan [mailto:[EMAIL PROTECTED]] Sent: Wednesday,

RE: Form field values on post

2002-02-27 Thread Hays, Duncan
Thank you Thank you Thank you -Original Message- From: David Schmidt [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 11:28 AM To: CF-Talk Subject: RE: Form field values on post on the action page... cfloop list=#form.fieldnames# index=fieldname cfset

RE: Form field values on post

2002-02-27 Thread David Schmidt
Whoops! on the action page... cfloop list=#form.fieldnames# index=fieldname cfset thisvariablename = Form. #fieldname# cfset myvalue = evaluate(#thisvariablename#) cfoutput#fieldname# = #myvalue#/cfoutput /cfloop -Original Message- From: Hays, Duncan

Re: Form field values on post

2002-02-27 Thread Stephen Moretti
I'm trying to post a form and then, on the page I'm posting to, loop through all the form fields and get the values. I've been shown form.formfields and that great for the names but how to I get the values out. I can't come up with the syntax. form.yourformvariable or if you're looping

RE: CFREPORT :: (CRPE32.DLL) could not be located

2002-02-27 Thread Paul Ihrig
do i need a full version on the server to run cfreport? http://store.crystaldecisions.net/dr/v2/ec_MAIN.Entry16?SP=10024PN=29xid=1 5248V1=30010453V2=30010453V3=1V5=11028983V4=10S1=S2=S3=S4=S5=DSP= 0CUR=840PGRP=0CACHE_ID=36273 what version!?? thank you -paul

Re: Form field values on post

2002-02-27 Thread Alex
javascript is slow on NT? Are you sure about this? On Wed, 27 Feb 2002, Hays, Duncan wrote: I'm trying to post a form and then, on the page I'm posting to, loop thro ugh all the form fields and get the values. I've been shown form.formfields a nd that great for the names but how to I get

Problem w/ CFFILE...

2002-02-27 Thread Kelly Matthews
I haven't run across this error before. On my form I have this: td valign=bottom align=rightfont size=2bLogo:/b/font/td td valign=bottominput type=file name=LogoFileName value= size=30 maxlength=64/td Which allows for me to upload a file. I basically click Browse and find the image. The action

RE: Template running more than once?

2002-02-27 Thread Chad Gray
I have never been able to get IE for Windows to submit two pages on a double click, but Netscape for Linux, and Irix will allow a double submit. I can replicate the double submit consistently on Linux, and Irix. My action page was not suppose to run if it had already run (based on looking at

Locked

2002-02-27 Thread kelly
Been getting this error on a certain site. Normally it is due to have the table in design mode. But this isn't the case this time. Can anyone shed some light as to why else this happens? Thanks! ODBC Error Code = S1000 (General error)PP [Microsoft][ODBC Microsoft Access Driver] Could not

RE: Problem w/ CFFILE...

2002-02-27 Thread Elizabeth Walter
Kelly, Try adding this atribute to your form tag: enctype=multipart/form-data -Elizabeth -Original Message- From: Kelly Matthews [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 11:40 AM To: CF-Talk Subject: Problem w/ CFFILE... I haven't run across this error before.

Re: Locked

2002-02-27 Thread Howie Hamlin
It could also happen if someone opens the database in exclusive mode. HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the

Re: Locked

2002-02-27 Thread Bryan Stevenson
This can also mean that the database is corrupted. Try opening the DB and compacting and repairing it. Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] -

RE: 'Edit with CF Studio' with right-click in Windows Explorer

2002-02-27 Thread Dave Watts
After upgrading to Studio 5.0 I lost the 'Edit with CF Studio' option when I right-click on a cfm or html file in Windows Explorer. How can I get this back or is this a new feature of Studio 5.0? Thanks! By default, you should have this option. In any case, though, it's easy to add it in.

RE: which is the best way to do auto retrieval of Address...

2002-02-27 Thread Steve Oliver
Yes you could do that, in the onchange paramater of the select box have it popup a new window. Do the query in that new window, then user the following javascript. script opener.formname.streetname = 'qry.StreetName'; opener.formname.city = 'qry.City'; /script If the form isn't named, and you

RE: local variable dump?

2002-02-27 Thread David Schmidt
Ah, if wishes could come true... Unfortunately, I don't believe you can loop through the variables or client scopes. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant

RE: local variable dump?

2002-02-27 Thread Pascal Peters
The local (variables.) scope is not a structure, so you cannot retreive them automatically. You can see them using the debugger in CFStudio. -Original Message- From: Tyler Silcox [mailto:[EMAIL PROTECTED]] Sent: woensdag 27 februari 2002 18:06 To: CF-Talk Subject: QQ: local variable

RE: OT JS again

2002-02-27 Thread Steve Oliver
There's a tag called cf_state on the dev exchange that does all of the work for you, you just declare the name of the field. cf_state name=state _ steve oliver senior internet developer atnet solutions, inc. http://www.atnetsolutions.com -Original Message-

Re: local variable dump?

2002-02-27 Thread Stephen Moretti
Ah, if wishes could come true... Unfortunately, I don't believe you can loop through the variables or client scopes. Client variables you can. Use GetClientVariablesList() if CFDump doesn't work. Server variables are the other scope that you cannot CFDUMP. Regards Stephen

Re: which is the best way to do auto retrieval of Address...

2002-02-27 Thread Jon Hall
http://www.ashleyit.com/rs/main.htm jon - Original Message - From: han peng [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 1:13 AM Subject: which is the best way to do auto retrieval of Address... hi... i need to do a address input fields.. where

RE: local variable dump?

2002-02-27 Thread David Schmidt
Yes. I knew about the GetClientVariablesList. But that is not quite the same code as a standard loop over the structure. -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 9:53 AM To: CF-Talk Subject: Re: local variable dump? Ah,

structure of arrays

2002-02-27 Thread Cantrell, Adam
Could somebody set me straight? First, I have a structure of arrays. I am trying to populate the arrays while looping through the structure keys. I'm getting all lost in the syntax and was hoping someone might be able to spot what I need to do. cfset

cfjava.cab forced install

2002-02-27 Thread Mark A. Kruger - CFG
I have a friend with the following problem on a CF 4.5.2 server: I have a site that requires the CFJAVA.CAB to be installed and run. There is a form on the entry page and it is marked enablecab=Yes. However, it doesn't force the CAB to install. However, I can send the user to another page that

cfmail subject line

2002-02-27 Thread Robert Orlini
Hello, Can I include a variable field in the subject= line when using cfmail? Here is a sample: CFMAIL from=#FORM.email# To=[EMAIL PROTECTED] Subject=Thank you for using our information - #FORM.Institution# The #FORM.Institution# does not display the institution in the subject line when the

RE: structure of arrays

2002-02-27 Thread Raymond Camden
Try: cfset variables.mystruct[#query.dynamicKeyName#][#incrementValue(arrayLen(va riables.mystruct[query.dynamicKeyName]))#][1] = valuee Note - no need for quotes or evaluate. === Raymond Camden, Principal Spectra Compliance

RE: CFPOP and html stripping

2002-02-27 Thread Mark A. Kruger - CFG
Tyler, hehe - ok then, on to the great adventure w. -Original Message- From: Tyler Silcox [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 6:33 AM To: CF-Talk Subject: Re: CFPOP and html stripping You can grab the HTML part of the multi-part message from your attachments

OT-possible IIS problem

2002-02-27 Thread Bruce, Rodney (SIGNAL)
Hello all We are trying to stand up a new web server with CF5/IIS5/WIN2K During the process of locking the server permissions/users down. We deleted the IWAM_servername and set up another account with the permissions we thought were needed. WE reviewed all the mapped directories/sites in IIS

RE: cfmail subject line

2002-02-27 Thread Robert Orlini
It should work, but it doesn't. Am I missing anything? Thanks for the quick reply. Robert O. -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 1:53 PM To: CF-Talk Subject: Re: cfmail subject line Yes, that should work. Regards,

RE: cfmail subject line

2002-02-27 Thread Carlisle, Eric
cfoutput the variable to the screen... make certain that it's defined and how you want it... The cfmail subject line should accept vars with no problem. -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 1:55 PM To: CF-Talk Subject: RE:

Logs - Page cannot be displayed Error

2002-02-27 Thread Mark M. Kecko
I'm having a problem with my web server, when traffic gets high the server goes down. When I say goes down I mean IIS stops functioning, it looks like it anyway. When I go to the site I get a Page cannot be displayed error almost like DNS isn't working right. The weird thing is though, when I

OT: Closing a window from JS without prompt?

2002-02-27 Thread Shawn Grover
I'm looking for ideas on how to close a Parent window from Javascript without getting the confirmation prompt. We don't have an issue with any child windows, but we open an interface to our app then want to close the original window without the prompt. Any tips? Thanks in advance. Shawn Grover

Re: cfmail subject line

2002-02-27 Thread Marius Milosav
try this: cfset subject =Thank you for using our information - FORM.Institution CFMAIL from=#FORM.email# To=[EMAIL PROTECTED] Subject=#subject# Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Company (VICO) Application Demo

Re: local variable dump?

2002-02-27 Thread Jon Hall
The only problem is that in order to do this, since client variables are stored in a database or the registry. For every single page request CF would have to do a database query or read the registry and build that structure. That's a big performance hit. Perhaps if they made it an optional thing

Re: OT: Closing a window from JS without prompt?

2002-02-27 Thread Critz
oi Shawn!! don't think it's possible without that prompt. -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion - Wednesday, February 27, 2002, 2:04:05 PM, you wrote: SG I'm looking for ideas on how to

RE: OT: Closing a window from JS without prompt?

2002-02-27 Thread Carlisle, Eric
oi Critz, I think the only ones that can be closed without a prompt are the ones that are spawned by JS. EC -Original Message- From: Critz [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 2:00 PM To: CF-Talk Subject: Re: OT: Closing a window from JS without

RE: Closing a window from JS without prompt?

2002-02-27 Thread Matthew R. Small
You can't do it. In the security model of Javascript the only windows that can be closed are the child windows. At least, that's what I've been taught. - Matt Small -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 2:04 PM To: CF-Talk

RE: Closing a window from JS without prompt?

2002-02-27 Thread Justin Waldrip
I have an app that opens up a window full screen and then I need to close the parent window that is behind it. So what I did was added the object code below to the head and then refresh the parent window with the onload function that initiates and closes the parent window. Works like a champ for

RE: OT-possible IIS problem

2002-02-27 Thread Scott Van Vliet
Are you running Active Directory? If so, the security settings for those folders for the web *might* have been initially set for public read-only access under that IWAM_server account (even if you have already changed the security settings under the web site properties) - which would cause an

ODBC and stored procs

2002-02-27 Thread Marlon Moyer
What are the limitations of using ODBC with stored procs? I was trying to change over a datasource from OLEdb to ODBC and now I keep getting an error that says:

RE: Closing a window from JS without prompt?

2002-02-27 Thread Scott Van Vliet
Does this work in NN 4.7? -Original Message- From: Justin Waldrip [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 11:18 AM To: CF-Talk Subject: RE: Closing a window from JS without prompt? I have an app that opens up a window full screen and then I need to close the

Re: Closing a window from JS without prompt?

2002-02-27 Thread Macarie Neculai
Hi! As far as I know you cannot close a parent window from a child, but I think you can try something like this: 1. call setTimeout(closeFunction, 2000) 2. open the child window from the parent 3. in closeFunction you close your parent window and I think you get no confirmation promt.

RE: Closing a window from JS without prompt?

2002-02-27 Thread savan . thongvanh
that snippet didn't work in either NS or IE for me IE didn't even load the page and NS bombed because it said that closes was not defined i just pasted that snippet into a page. is there something else that needs to be done? Justin Waldrip [EMAIL PROTECTED] on 02/27/2002 01:17:54 PM

RE: Closing a window from JS without prompt?

2002-02-27 Thread Justin Waldrip
Not sure I don't use NN. -Original Message- From: Scott Van Vliet [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 1:25 PM To: CF-Talk Subject: RE: Closing a window from JS without prompt? Does this work in NN 4.7? -Original Message- From: Justin Waldrip

Re: Closing a window from JS without prompt?

2002-02-27 Thread savan . thongvanh
i would use a javascript function to open the window and subsequently c lose itself. If there are any URLs in the history of a window it cannot c lose, with javascript, without a prompt (up to IE 5.5 and NS 4.7). I'm not sure about version 6s. Savan Macarie Neculai [EMAIL PROTECTED] on

RE: Closing a window from JS without prompt?

2002-02-27 Thread Justin Waldrip
Sorry I forgot to name the form. I just tried this and it works on IE. html head titleUntitled/title !--- // Must have this in the head // --- object id=closes type=application/x-oleobject classid=clsid:adb880a6-d8ff-11cf-9377-00aa003b7a11 param

RE: structure of arrays

2002-02-27 Thread Cantrell, Adam
perfect, thank you so much. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 12:48 PM To: CF-Talk Subject: RE: structure of arrays Try: cfset variables.mystruct[#query.dynamicKeyName#][#incrementValue(a rrayLen(va

thanks

2002-02-27 Thread Robert Orlini
Thanks everyone for the quick replies and assistance on the variable name included subject= line on CFmail. I deleted the - (dash) and it works... __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB

RE:SOLUTION - Closing a window from JS without prompt?

2002-02-27 Thread Shawn Grover
We managed to do it, but by tricking the calling window. Here's a code snippet that might be useful for some of you out there: mainwin = window.open('#NewURL#', 'mainwin', ''); !--- Close original window, this trick works under IE5.5+ only --- mainwin.opener = mainwin; window.opener = mainwin;

OT: SQL Server Login failed

2002-02-27 Thread Chris Montgomery
This is my first foray into working with CF and SQL Server. With the ISP's help, I've been able to connect to the remote site's SQL Server and copy the database to my local development box. I can read the tables, etc., locally, but I am now having trouble setting this up as a datasource in the

Re: OT-possible IIS problem

2002-02-27 Thread Jochem van Dieten
Bruce, Rodney (SIGNAL) wrote: But we are still getting the error that the old account is trying to long on and for obvious reasons is being denied access. We re-reviewed everything again and can find what is trying to log on using this account. The error acures with any site we try to

Crossed Session Variables - many users with same User

2002-02-27 Thread Paul Sizemore
On an Intranet, my users are getting crossed session variables. I would appreciate any ideas as to what I can do about this. I've got a lot of users that are logging on to our NT domain with the same log in (but different static IP addresses) - requirements changed during development. This is

Date Math

2002-02-27 Thread Tyler Clendenin
I have two dates, we shall call them start and finish and i want to find the timespan between the two dates and then add that timespan to another timespan. does anyone know what i can do, is there a way to subtract two dates ex. finish - start. thanks ahead of time Tyler Clendenin

RE: Date Math

2002-02-27 Thread Albrechtas, Adam
Try the DateDiff() function. -Original Message- From: Tyler Clendenin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 3:17 PM To: CF-Talk Subject: Date Math I have two dates, we shall call them start and finish and i want to find the timespan between the two dates and

Re: Logs - Page cannot be displayed Error

2002-02-27 Thread chris.alvarado
look through the server log in CF. -chris.alvarado [application developer] 4|Guys Interactive, Inc. http://www.4guys.com - Original Message - From: Mark M. Kecko [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 1:09

RE: SQL Server Login failed

2002-02-27 Thread Christopher Olive
go to your Client network Utility (under your SQL Server program group). add the name of the database, and select TCP/IP as your connection library. christopher olive, cto, vp of web development, vp security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original

Re: Date Math

2002-02-27 Thread Tyler Clendenin
How do i use that? - Original Message - From: Albrechtas, Adam [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 3:06 PM Subject: RE: Date Math Try the DateDiff() function. -Original Message- From: Tyler Clendenin [mailto:[EMAIL

Re: Date Math

2002-02-27 Thread Tyler Clendenin
oh and they are not just dates they are datetimes - Original Message - From: Tyler Clendenin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 3:17 PM Subject: Date Math I have two dates, we shall call them start and finish and i want to find the

ThreeSelectsRelated?

2002-02-27 Thread C . Hatton Humphrey
HELP!!! I'm trying to find this tag (Three Selects Related) and I'm not able to find it! Does anyone have a link to a place I can download it from? Hatton __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM

About to call Macromedia Tech Support on this one...

2002-02-27 Thread Evan Lavidor
The following is an error we see in our webserver.log quite a bit: ERROR,TID=3580,02/27/02,10:23:38,Error attempting to write location redirection to web server (Windows NT error number -2147467259 occurred) I'm personally convinced that this is related to some other problems we're having, but

RE: Date Math

2002-02-27 Thread Albrechtas, Adam
The usage of ColdFusion function can be found in your online documentation (if you have it installed) or you can download pdf versions here. http://www.macromedia.com/support/coldfusion/documentation.html I believe you will want the CFML Reference. Also, look up the DateAdd() function for the

RE: Logs - Page cannot be displayed Error

2002-02-27 Thread Rick Eidson
We had that problem with a scheduled task quering a Filemaker db. Rick -Original Message- From: Mark M. Kecko [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 1:10 PM To: CF-Talk Subject: Logs - Page cannot be displayed Error I'm having a problem with my web server, when

RE: OT-possible IIS problem

2002-02-27 Thread Dave Watts
If you have some tool to make a dump of the entire metabase, now is the time to use it (does anyone know if the IIS4 tools work?). I expect it is some obscure setting somewhere. I think that either Metabase Editor will work with both IIS 4 and 5. Dave Watts, CTO, Fig Leaf Software

RE: About to call Macromedia Tech Support on this one...

2002-02-27 Thread James Ang
Looks like this happens on CFLOCATION calls. IIS threw an error to CF Server saying that it can't send the redirection headers. Perhaps the browser's TCP connection to IIS was broken before the CFLOCATION could execute. This should happen intermittently, and would depend on heavy load (server

Re:ThreeSelectsRelated?

2002-02-27 Thread C . Hatton Humphrey
Of course, the minute I post a request for help the world starts treating me nicely... I found it and have downloaded it. Thanks! Hatton C. Hatton Humphrey [EMAIL PROTECTED] wrote on 2/27/2002 3:20:41 PM: HELP!!! I'm trying to find this tag (Three Selects Related) and I'm not able to

Developer version of CF Server 4.5?

2002-02-27 Thread ksuh
Anybody know where I can download a developer version of CF Server 4.5? Can't seem to find one on MM's site. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month ·

RE: Developer version of CF Server 4.5?

2002-02-27 Thread Shawn Grover
download the Enterprise evaluation version when the 30 days times out, it becomes the developer version. Shawn Grover -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 1:48 PM To: CF-Talk Subject: Developer version of CF

Re: RE: Developer version of CF Server 4.5?

2002-02-27 Thread ksuh
I would, but there are no versions of CF Server 4.5 on MM's site. - Original Message - From: Shawn Grover [EMAIL PROTECTED] Date: Wednesday, February 27, 2002 1:54 pm Subject: RE: Developer version of CF Server 4.5? download the Enterprise evaluation version when the 30 days

Re: RE: Developer version of CF Server 4.5?

2002-02-27 Thread Douglas Brown
Why 4.5??? Why not 5.0 Success is a journey, not a destination!! Doug Brown - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 1:02 PM Subject: Re: RE: Developer version of CF Server 4.5? I would, but there are no

Re: RE: Developer version of CF Server 4.5?

2002-02-27 Thread ksuh
I'm working in a 4.5 environment. It's a bit easier to code if I don't accidently use 5.0 stuff (as I've worked in a 5.0 environment as we ll, so my tendency is to use 5.0 code wherever possible). - Original Message - From: Douglas Brown [EMAIL PROTECTED] Date: Wednesday, February

RE: RE: Developer version of CF Server 4.5?

2002-02-27 Thread Shawn Grover
DOH!!! I obviously didn't read that close enough - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 1:02 PM Subject: Re: RE: Developer version of CF Server 4.5? I would, but there are no versions of CF Server 4.5 on MM's

Re: RE: Developer version of CF Server 4.5?

2002-02-27 Thread Douglas Brown
ah ic I do not believe that 4.5 ever had a developer edition. I could be wrong though. Doug Brown - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 1:06 PM Subject: Re: RE: Developer version of CF Server 4.5?

RE: Developer version of CF Server 4.5?

2002-02-27 Thread Ken Wilson
Got a copy of the Studio v4.5 CD around there anywhere? It should be on there. Ken -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 3:48 PM To: CF-Talk Subject: Developer version of CF Server 4.5? Anybody know where I can

RE: RE: Developer version of CF Server 4.5?

2002-02-27 Thread Jesse Noller
It didn't, it did have cf express tho -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 4:34 PM To: CF-Talk Subject: Re: RE: Developer version of CF Server 4.5? ah ic I do not believe that 4.5 ever had a

Re: RE: Developer version of CF Server 4.5?

2002-02-27 Thread ksuh
I got one at home. I'm just being impatient and want it today :P - Original Message - From: Ken Wilson [EMAIL PROTECTED] Date: Wednesday, February 27, 2002 2:13 pm Subject: RE: Developer version of CF Server 4.5? Got a copy of the Studio v4.5 CD around there anywhere? It should be

Re: Developer version of CF Server 4.5?

2002-02-27 Thread Jochem van Dieten
[EMAIL PROTECTED] wrote: Anybody know where I can download a developer version of CF Server 4.5? Can't seem to find one on MM's site. You can download an evaluation version of CF 4.5 but it is just a 30 days version. Or you can download the Express Edition, which will work unlimited, but

RE: SQL indexing

2002-02-27 Thread Steven Monaghan
The answer is a definite maybe. I'm Oracle familiar, not SQL Server, but if the data is skewed in any of those columns(90%=0 10%=1) then you may get some benefit when selecting the smaller value. Also, Oracle has special indexes for columns with low cardinality called bitmap indexes. These

Inserting a delimited list into a database

2002-02-27 Thread Jake Munson
I have a form that returns a comma delimited list of numbers from some checkboxes that each have the same name. I want to be able to insert a new record in a database for each checkbox that was checked in my form. I figured that if I used a list loop based on my checkbox list, that I could have

RE: Inserting a delimited list into a database

2002-02-27 Thread Costas Piliotis
Here's the function to parse a comma-delimited string: CREATE FUNCTION dbo.fnc_ParseDelimited ( @delimitedList VarChar(8000) ) RETURNS @tblSample TABLE (CounterID Int, FieldValue Varchar(100)) BEGIN Declare@CounterID VarChar(4) Declare

RE: Inserting a delimited list into a database

2002-02-27 Thread Costas Piliotis
Oh yeah... In sql server... Just pass the comma-delimited list to sql server and use this to parse it. Way less calls to the database... -Original Message- From: Costas Piliotis Sent: Wednesday, February 27, 2002 1:49 PM To: '[EMAIL PROTECTED]' Subject: RE: Inserting a delimited list

  1   2   >