from:"Albrechtas, Adam"

RE: Returning only one record HELP PLEASE!!!!

2002-03-26 Thread Albrechtas, Adam

Get rid of the group parameter of your cfoutput

-Original Message-
From: LANCASTER, STEVEN M. (JSC-OL) (BAR)
[mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, March 26, 2002 1:02 PM
To: CF-Talk
Subject: RE: Returning only one record HELP PLEASE

I am not allowed to post data. but what I put out is very close to what I
have..

I have multiple records in both tables and query2 is only outputting one
record.

Select column1, column2
>From Table1
Where this = that

Select column12, column22
>From Table1

#query1.column1# &nbps; #query2.column22# 

Steven Lancaster
Barrios Technology
NASA/JSC
281-244-2444 (voice)
[EMAIL PROTECTED] 

-Original Message-
From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 11:54 AM
To: CF-Talk
Subject: RE: Returning only one record HELP PLEASE

What are you trying to accomplish?

The GROUP attribute will only work with the QUERY specified in the top-level
CFOUTPUT tag.  If you have grouped data, the you could join in the second
table instead of querying it separately.

Please post some sample data so that I can try to help you a little more.

-- 
SCOTT VAN VLIET 
SENIOR ANALYST 
SBC SERVICES, INC 
Tel: 858.886.3878 
Fax: 858.653.6763 
Email: [EMAIL PROTECTED]  

-Original Message-
From: LANCASTER, STEVEN M. (JSC-OL) (BAR)
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 9:49 AM
To: CF-Talk
Subject: RE: Returning only one record HELP PLEASE

with that also work with 2 queries?

Steven Lancaster
Barrios Technology
NASA/JSC
281-244-2444 (voice)
[EMAIL PROTECTED] 

-Original Message-
From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 11:40 AM
To: CF-Talk
Subject: RE: Returning only one record HELP PLEASE

I don't get what you are trying to do.  The GROUP attribute is to group data
for nested output from one query.

EXAMPLE:

(Your Data)

ID  NAMECOLOR
-
1   Quiksilver T-Shirt  Blue
1   Quiksilver T-Shirt  Red
1   Quiksilver T-Shirt  Green
1   Quiksilver T-Shirt  Gray
2   Volcom T-Shirt  Blue
2   Volcom T-Shirt  Black
2   Volcom T-Shirt  White

(Your Code)

SELECT ID, NAME, COLOR
FROM PRODUCT
ORDER BY NAME

Product Name:   
#NAME#
Available Colors:

#COLOR#

(Your Result)

Product Name:
Quiksilver T-Shirt

Available Colors:
Blue
Red
Green
Gray

Product Name:
Volcom T-Shirt

Available Colors:
Blue
Black
White

I use this function often when I have a record which has many records in a
joined table, so that I can just use one query to grab all of the necessary
data for the output.

Hope this helps!

--
SCOTT VAN VLIET 
SENIOR ANALYST 
SBC SERVICES, INC 
Tel: 858.886.3878 
Fax: 858.653.6763 
Email: [EMAIL PROTECTED]

-Original Message-
From: LANCASTER, STEVEN M. (JSC-OL) (BAR)
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 9:24 AM
To: CF-Talk
Subject: Returning only one record HELP PLEASE

I have 2 queries and I need to know what to do to fix code that looks like
this.
As you will see I am only getting one record from my second query. In the
cfouput tags I have to specify a query and a group because I have nested
tags there is a reason for this. I just need to know how to make it work
this way.. any suggestions?

Select column1, column2
>From Table1
Where this = that

Select column12, column22
>From Table1

#query1.column1# &nbps; #query2.column22# 

Steven Lancaster
Barrios Technology
NASA/JSC
281-244-2444 (voice)
[EMAIL PROTECTED] 

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
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

RE: Testing Software

2002-03-25 Thread Albrechtas, Adam


http://www.emulators.com/softmac.htm
http://mes.emuunlim.com/macemu/basilisk2/b2.htm


Adam Albrechtas
Developer
Equisure Financial Network Inc.
1.705.476.5010 x 2555
[EMAIL PROTECTED]


-Original Message-
From: Smith, Daron [PA] [mailto:[EMAIL PROTECTED]] 
Sent: Monday, March 25, 2002 9:21 AM
To: CF-Talk
Subject: Testing Software


Does anyone know of any software like vmware that will allow for Mac
emulation.  From what I understand vmware does not, but does anyone know of
another that does?

Thanks,

Daron J. Smith
Web Developer
PSEA

[EMAIL PROTECTED]
717-255-7141 
1-800-944-PSEA (7732) x 7141
Please note new email address (old one with 'mail' will soon expire)

 
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
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
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

RE: NT Authentication

2002-03-21 Thread Albrechtas, Adam


http://support.microsoft.com/default.aspx?scid=%2Fsupport%2Fexchange%2Fconte
nt%2Fwhitepapers%2Fowa%5Ftshoot%2Easp

>From the "Password Authentication Methods" section:



If Exchange and IIS are on separate computers, only Basic (Clear Text) and
Anonymous can be used. Windows NT Challenge/Response (also called NTLM)
authentication cannot be used if a browser other than Internet Explorer will
be used for Outlook Web Access. If you are going to use the Windows NT
Challenge/Response method for authentication, then any resources your
clients need to access must reside on the local IIS/Exchange server. This
will include the mailboxes, any Public Folders, Free/Busy data,
organizational forms, and so forth.



-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, March 21, 2002 10:57 AM
To: CF-Talk
Subject: RE: NT Authentication


Also make sure they are using IE if you're doing nt authentication.
Sometimes you also have to put the domain of the computer first
domain\username HTH

Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 10:53 AM
To: CF-Talk
Subject: RE: NT Authentication


> If their own isp then they are no longer on your network 
> so I believe they wont authenticate via nt authentication.. 
> They need to connect via basic authentication...

NT Authentication works fine over the public internet, by default.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444



__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
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

RE: NT Authentication

2002-03-21 Thread Albrechtas, Adam

I believe there is a known bug with Outlook Web Access which requires that
it use Basic Authentication only.

Adam.

-Original Message-
From: Bosky, Dave [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, March 21, 2002 10:40 AM
To: CF-Talk
Subject: NT Authentication

We are using NT authentication on our intranet but dialup users cannot use
Outlook Web Access anymore, it stopped working.
Any ideas what might causing this?

Thanks,
Dave

__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
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

RE: JS back?

2002-03-20 Thread Albrechtas, Adam


You should be able to accomplish this by placing the following in your
 block (replacing what you have there now:


  alert(Your file is too big!);
  history.back();   


-Original Message-
From: Greg [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, March 20, 2002 11:06 AM
To: CF-Talk
Subject: JS back?


I'm testing for file size after posting a form. Is there a way to use
javascript:history.back() to send me back to the form instead of having
to pass all the form values back in the url of cflocation? (Also don't
want to do the wddx thing because I have to use
enctype="multipart/formdata" to submit the input type="file", and the
only way I know to serialize the form data is to loop over the
form.fieldnames and it in a structure. And with
enctype="multipart/form-data" form.fieldnames plays out as the VALUES
instead of the actual fieldnames.) I tried this:






But it's sloppy. Any javascripters know if I could have an alert box to
display the message. Then after you click OK it could do the
javascript:history.back()?


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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

RE: HTML / CF issue

2002-03-20 Thread Albrechtas, Adam

Have you tried making the body of the table (ie the  between the left
and right border) at width=100%?

Adam.

-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, March 20, 2002 6:59 AM
To: CF-Talk
Subject: HTML / CF issue

Hi everyone.
This should be an easy fix but I have not run into this in a long time. I
have a table in which I put a border around it using a top row with a height
of 1 pixel and a bottom row of a 1 pixel and two side columns with a width
of  pixel.. Is there a way to get this to work in netscape 4+? It seems that
no matter what kind of content that fills the main cells, it pulls the
"border" wider than 1 pixel. It works fine in IE of course. Would it help to
put a layer inside the table cell?

Thanks,

Michael T. Tangorre

==
Alfred University
Webteam Manager 
AIM: CrazyFlash4
Phone: 607-426-9277
==

__
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@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: creating triggers in cfquery...

2002-03-19 Thread Albrechtas, Adam

You might try removing the quotes from around the trigger name and table
name in your SQL statement.

Adam.

-Original Message-
From: Tyler Silcox [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, March 19, 2002 10:29 AM
To: CF-Talk
Subject: creating triggers in cfquery...

Do we have to do anything special to create triggers in cfqueries?  I'm
getting a rather blatant error:

ODBC Error Code = 37000 (Syntax error or access violation) 

[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the
keyword 'TRIGGER'. 

SQL = "CREATE TRIGGER "Groups_AdminsInsert" on "Groups_Admins" FOR INSERT AS
BEGIN declare @rowsAffected int, @nullRows int, @validRows int, @errorNumber
int, @errorMsg varchar(255) select @rowsAffected = @@rowcount if
update("Admin_id") begin select...blah blah blah

Tyler Silcox
email | [EMAIL PROTECTED]

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
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

RE: Restart CF from command line?

2002-03-15 Thread Albrechtas, Adam


You can start and stop services by using the "net stop" and "net start"
commands.  To get a list of names of services currently running type in "net
start" at a command line.  Find your ColdFusion services in the list.  You
can start or stop the services by using

net stop "Name of service"
net start "Name of service"

The services may have dependencies ie you have to start or stop services in
a particular order, but if you are able to use the command line first to
experiment the utilities will warn you about this.

a.

-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED]] 
Sent: Friday, March 15, 2002 9:08 AM
To: CF-Talk
Subject: Restart CF from command line?


I'd like to be able to restart the CF service from a template. Does
anyone have a .bat file that I could use with , or some
such solution?

Thanks,
Jamie

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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

RE: Debug output won't display!

2002-03-15 Thread Albrechtas, Adam

Try adding "mode=debug" to the query string of the page you are calling.

-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]] 
Sent: Friday, March 15, 2002 8:27 AM
To: CF-Talk
Subject: Debug output won't display!

I'm trying to get page timings on some problems I'm trying to debug, but I
can't get them to display.  I've set my IP address in CF Administrator's
debugging IP's screen, I've got debugging options turned on, etc.  I checked
the archive and couldn't find anything.  The page is using cfcache but the
debug output still doesn't show after I've commented it out.  Any clues?
I'm using CF5 Ent on Win2K Server

Thanks

Pete

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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

RE: CFFILE and network shares

2002-03-13 Thread Albrechtas, Adam

Is the share static?  Why not map a drive to it and then use the "copy"
action of CFFILE?

Adam

-Original Message-
From: Bosky, Dave [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, March 13, 2002 8:29 AM
To: CF-Talk
Subject: CFFILE and network shares

Is there anyway to use cffile to upload files to a network share instead of
a destination directory on the webserver?
If not are there any custom tags built to accomplish this?

Thanks.
Dave

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
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

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 second part of your problem.

-Original Message-
From: Tyler Clendenin [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, February 27, 2002 3:23 PM
To: CF-Talk
Subject: Re: Date Math


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 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 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
> http://www.gslsolutions.com/
>
>
> 

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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

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 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
http://www.gslsolutions.com/

__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
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

RE: Returning only one record HELP PLEASE!!!!

RE: Testing Software

RE: NT Authentication

RE: NT Authentication

RE: JS back?

RE: HTML / CF issue

RE: creating triggers in cfquery...

RE: Restart CF from command line?

RE: Debug output won't display!

RE: CFFILE and network shares

RE: Date Math

RE: Date Math

12 matches

Site Navigation

Mail list logo

Footer information