Re: How to force CFOUTPUT to display results horizontally

[Britta Wingenroth]

Hi, I just used this and suddenly realized that, yes! all the images are
displaying horizontally from the query output, but unfortunately, they are
not breaking at the end of the table, but extending the table way off to the
right.  Setting the table cells to the appropriate width has no effect.  Any
way of forcing it to break after, say five records have been output, and
then staring the new row?

record record record record record
record record record record record

instead of

record record record record record record record record record record

Thanks a lot,
Britta

- Original Message -
From: "Britta Wingenroth" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 04, 2001 8:24 PM
Subject: How to force CFOUTPUT to display results horizontally


> I would like to display the results of the Cfoutput tag running
> horizontally, ie.
>
> image image image image
> instead of
>
> 
> image
> image
> image
> image
> 
>
> Is there any way that I can do this?  Any help would be greatly
appreciated.
>
> Britta
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: How to force CFOUTPUT to display results horizontally

[Britta Wingenroth]

Thank you very much!  That solved my problem, and I'm on my way!  It's at
times like these that I'm so grateful for this newsgroup - such a simple
little problem, which you were able to help me with so easily, and I would
have been stuck otherwise.

Cheers!

Britta

- Original Message -
From: "BORKMAN Lee" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 04, 2001 8:58 PM
Subject: RE: How to force CFOUTPUT to display results horizontally


> Hi Britta,
>
> Just remember that EVERYTHING between the CFOUTPUT tags gets repeated for
> every row in the query.  This includes any whitespace, eg new lines.
>
> So to get the output on a single line, don't put any new lines between
your
> tags:
>
> #img#
>
> As long as #img# has no new lines, you'll be right,
>
> best of luck,
> Lee (Bjork) Borkman
> http://bjork.net ColdFusion Tags by Bjork
>
>
> -Original Message-
> From: Britta Wingenroth [mailto:[EMAIL PROTECTED]]
>
>
> I would like to display the results of the Cfoutput tag running
> horizontally, ie.
>
> image image image image
> instead of
>
> 
> image
> image
> image
> image
> 
>
> Is there any way that I can do this?  Any help would be greatly
appreciated.
>
>
> IMPORTANT NOTICE:
> This e-mail and any attachment to it is intended only to be read or used
by
> the named addressee.  It is confidential and may contain legally
privileged
> information.  No confidentiality or privilege is waived or lost by any
> mistaken transmission to you.  If you receive this e-mail in error, please
> immediately delete it from your system and notify the sender.  You must
not
> disclose, copy or use any part of this e-mail if you are not the intended
> recipient.  The RTA is not responsible for any unauthorised alterations to
> this e-mail or attachment to it.
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

How to force CFOUTPUT to display results horizontally

[Britta Wingenroth]

I would like to display the results of the Cfoutput tag running
horizontally, ie.

image image image image
instead of


image
image
image
image


Is there any way that I can do this?  Any help would be greatly appreciated.

Britta



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Thank you!

[Britta Wingenroth \(West Coast Web\)]

Thank you very much, Lee and Dick!

I didn't have my messages grouped by conversation, so I just saw your
replies.  Of course, the BETWEEN makes it work, and I've been able to fix
the code in the store to be more functional.  Thanks again!

Britta

- Original Message -----
From: "Britta Wingenroth (West Coast Web)" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 16, 2000 8:17 PM
Subject: An embarrassing SQL query question


> I've done a lot in CF but this silly little problem just stumped me at the
> moment.  If anyone would be kind enough to straighten me out on this I'd
> much appreciate it!
>
> I have a database of products.  I need to submit a value ( a pricerange)
to
> the query that will return only the items in that range.
>
> I have 
> which will be changed depending on what value is submitted by the user,
(eg.
> 51-100).
>
> The problem is that
>
> SELECT ID, ProductName,  Price, Photo
> FROM Products
> WHERE (Price <50)
>
> works, but
>
> SELECT ID, ProductName,  Price, Photo
> FROM Products
> WHERE (Price = #pricerange#)
>
> returns no records at all.
>
> Thank you for any help!
>
> britta
>
>
>
> ~~
> Structure your ColdFusion code with Fusebox. Get the official book at
https://secure.houseoffusion.com
>
> 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

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Sorry about the double post...

[Britta Wingenroth \(West Coast Web\)]

I didn't have my messages grouped by conversation so I didn't realize that
my previous message had been replied to .  thanks!

- Original Message -----
From: "Britta Wingenroth (West Coast Web)" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 20, 2000 1:19 PM
Subject: How to use a value range in an SQL select statement?


> This is a multi-part message in MIME format.
>
> --=_NextPart_000_0011_01C052F4.83798150
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> I have a database of products.  I need to submit a value ( a pricerange) =
> to
> the query that will return only the items in that range.
>
> I have 
> which will be changed depending on what value is submitted by the user, =
> (eg.
> 51-100).
>
> The problem is that
>
> SELECT ID, ProductName,  Price, Photo
> FROM Products
> WHERE (Price <50)
>
> works, but I can't get a range instead of a fixed number to work:
>
> SELECT ID, ProductName,  Price, Photo
> FROM Products
> WHERE (Price =3D #pricerange#)
>
>
> Thank you for any help!
>
> britta
>
>
>
>
>
> --=_NextPart_000_0011_01C052F4.83798150
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> 
> 
>  http-equiv=3DContent-Type>
> 
> 
> 
> 
> I have a database of products.  I =
> need to=20
> submit a value ( a pricerange) tothe query that will return only the =
> items=20
> in that range.I have <cfparam name=3D"pricerange" =
> default=3D"1 <=20
> 50">which will be changed depending on what value is submitted by =
> the=20
> user, (eg.51-100).The problem is thatSELECT ID,=20
> ProductName,  Price, PhotoFROM ProductsWHERE (Price=20
> <50)works, but I can't get a range instead of a fixed =
> number to=20
> work:SELECT ID, ProductName,  Price, PhotoFROM=20
> ProductsWHERE (Price =3D #pricerange#)
> Thank you for any=20
> help!britta
>
> --=_NextPart_000_0011_01C052F4.83798150--
>
> ~~
> Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
>
> 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

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

How to use a value range in an SQL select statement?

[Britta Wingenroth \(West Coast Web\)]

This is a multi-part message in MIME format.

--=_NextPart_000_0011_01C052F4.83798150
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I have a database of products.  I need to submit a value ( a pricerange) =
to
the query that will return only the items in that range.

I have 
which will be changed depending on what value is submitted by the user, =
(eg.
51-100).

The problem is that

SELECT ID, ProductName,  Price, Photo
FROM Products
WHERE (Price <50)

works, but I can't get a range instead of a fixed number to work:

SELECT ID, ProductName,  Price, Photo
FROM Products
WHERE (Price =3D #pricerange#)


Thank you for any help!

britta





--=_NextPart_000_0011_01C052F4.83798150
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








I have a database of products.  I =
need to=20
submit a value ( a pricerange) tothe query that will return only the =
items=20
in that range.I have which will be changed depending on what value is submitted by =
the=20
user, (eg.51-100).The problem is thatSELECT ID,=20
ProductName,  Price, PhotoFROM ProductsWHERE (Price=20
<50)works, but I can't get a range instead of a fixed =
number to=20
work:SELECT ID, ProductName,  Price, PhotoFROM=20
ProductsWHERE (Price =3D #pricerange#)
Thank you for any=20
help!britta

--=_NextPart_000_0011_01C052F4.83798150--

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

An embarrassing SQL query question

[Britta Wingenroth \(West Coast Web\)]

I've done a lot in CF but this silly little problem just stumped me at the
moment.  If anyone would be kind enough to straighten me out on this I'd
much appreciate it!

I have a database of products.  I need to submit a value ( a pricerange) to
the query that will return only the items in that range.

I have 
which will be changed depending on what value is submitted by the user, (eg.
51-100).

The problem is that

SELECT ID, ProductName,  Price, Photo
FROM Products
WHERE (Price <50)

works, but

SELECT ID, ProductName,  Price, Photo
FROM Products
WHERE (Price = #pricerange#)

returns no records at all.

Thank you for any help!

britta



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
https://secure.houseoffusion.com

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

[CF-Talk] Loop problem in Message Board

[Britta Wingenroth \(West Coast Web\)]

I want to build a message board which will list all messages, and list the
replies associated with that message if you click on that message in this
format:

*message
-
*message (click here to view notes, this sends parameter to notes query)
*all notes for this message once parameter has been sent to notes query
-
*next message
*next message

If you click on a different message, it hides the notes for the first
message and shows the notes for the new message selected.  I've got it set
up, so the parameter is being sent to the query and it is outputting the
notes for the message selected only, but it is showing them in this format:

*message
*message (this one is clicked)
*message
*message
*notes for clicked message at bottom of list instead of under the one
clicked.

I tried setting the record count of the first query to be the control of the
loop containing the message query and the notes query WHERE
messageid=notekey, but since I can't output the notes query inside the
message query, it does not work.

I've included the code of the page below.
I would  GREATLY appreciate if anyone could tell me what I'm missing on
this!

Thank you very much,
Britta




SELECT StoreID, ObjectiveID, ObjectiveTitle, ObjectiveDetails,
TargetCompletionDate, ActualCompletionDate, CompletionNotes,
Dependant, [E-MailSent],MoveToHistory, RemoveFromPalm, Initiator,
DateStamp, ObjectiveID, DateStamp, UserID
FROM RMObjectives
WHERE (MoveToHistory = 0)





SELECT ObjectiveID, RMObNoteID, DateStamp, UserID, UserType, ObjectiveType,
Note
FROM RMObjectiveNotes
WHERE (ObjectiveID = #shownotes#)





 View RM Objectives










#DateStamp#
#ObjectiveTitle#
ID:#ObjectiveID#


Initiator: #Initiator# 
#UserID# 
#DateFormat(TargetCompletionDate)# 
#DateFormat(ActualCompletionDate)# 







History#MoveToHistory#

ObjectiveDetails: #ObjectiveDetails# 
CompletionNotes: #CompletionNotes# 






#DateStamp#
#UserID#
#UserType#
#Note#









--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

looking for host: SSL, CF with PGP tag installed

[Britta Wingenroth]

Looking for a server that has a tag (such as CFX_PGP) installed so I can do
secure e-mail from an SSL form.  So far only found two, very pricey.

Anyone?


Britta Wingenroth
Web Development & Design
West Coast Web
__
[EMAIL PROTECTED]
(604) 737-4332

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Using tag... comments?

[Britta Wingenroth]

I'm building a site that will take credit card information online on SSL but
send it to the business to be processed by hand.  I need for the mail that
gets sent from the  tag to be encrypted.  Apparently PGP is
installed on my ISP, but the SysAdmins don't know how to use it.

I'm thinking of buying the cfx_pgp tag from the allaire site... has anyone
used it?  Any comments?  Is it secure just with using the free version of
PGP6 and this tag?  Are there any other products out there that would do the
same thing for $150?

Thanks for any feedback!

Sincerely,

Britta Wingenroth
Web Development & Design
West Coast Web
__
[EMAIL PROTECTED]
(604) 737-4332


Britta

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Test for Javascript versions and Javascript on

[Britta Wingenroth]

I have a page which is written with JS 1.2.  I would like to write a portal
page which will test for JS on, and JS 1.0 and 1.1, and have one conditional
CFLOCATION  for (JS 1.2 and have it turned on,) and send everyone else to
the text version of the page.  Is there a custom tag to do this, or does
anyone have a snippet of code they would be willing to share?

Thank you very much for your help!

Britta


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Test for Javascript versions and Javascript on

[Britta Wingenroth]

I have a page which is written with JS 1.2.  I would like to write a portal
page which will test for JS on, and JS 1.0 and 1.1, and have one conditional
CFLOCATION  for (JS 1.2 and have it turned on,) and send everyone else to
the text version of the page.  Is there a custom tag to do this, or does
anyone have a snippet of code they would be willing to share?

Thank you very much for your help!

Britta

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

cf-talk@houseoffusion.com

[Britta Wingenroth]

Hi!
I need to finish this site by tomorrow, and this is the last thing I've got
to write in.  I'm still pretty new to CF and I'd really appreciate any info
or advice on this.
I've got an application that looks like this:



and has various client variables that are set from within the cart, such as


This seems to work fine for a limited time, a few days.  After that, the
storage seems to expire, and calculations stored using the client variables
no longer function, causing error messages.

I've got a  table with  fields and a
 table with  fields.  All fields are empty
though.  Do I need to force the application to store the CFID and
client.variables in the table, or is this supposed to be happening by
itself?  Does the fact it is not storing information in these tables
automatically mean the server is not configured correctly, or does it mean
that I am leaving essential code out of my pages?

What is the simplest way of doing this if I need to add code?  I want the
variables to be permanent and not expire, but setting sessiontimeout and
applicationtimeout to 0 makes no difference, so I'm assuming that setting
them to one year would make no difference either.

Thank you very much for your help!

Britta

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

How do I pass a query in WDDX?

[Britta Wingenroth]

This is what I would LIKE to be able to do...





and on next page,





#products query#



What is the very easiest way of doing this??  Does anyone have any code
snippets they could send me to make this easier?  I'd really appreciate any
help on this

Thanks for any help,
Britta

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

browser detection

[Britta Wingenroth]

Anyone know of a way to write a statement like this that works?

This is the idea:  I need to write an "if" statement based on if netscape is
being used.  I would like to use the HTTP_USER_AGENT like this:




put netscape version here

put ie version here



Any help is much appreciated!
Britta

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Can I use WDDX for this?

[Britta Wingenroth]

I need to store a page full of information, including query output, tables
and other html tags, in  a WDDX packet like this:



content, querys, query output, general html



and then store it in a client variable.

1) Is this possible?
2) If so, how do I call the function of WDDX? I've never used it before. If
it is too complicated, I would appreciate a link to learn it!
3) how does one store information in a client variable, and how does one
retrieve it?

An answer to any of these questions would be much appreciated!  Thanks for
your help,

Britta



--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Passing a formfield along a multi-form page

[Britta Wingenroth]

This should be so simple  I've got a site going online on Friday, and I
can't finish the shopping cart becuase of this!  Please help!
Thanks!

I have a page of cfoutput in my form.
I snared the whole page by repeating it and enclosing it in
a textarea tag, like so:


actual page output

page output repeated




Now this is pretty ugly, even set to row1 col1, but at least it works.  The
problem is that I can call this textarea on the next page and display it,
but that's not what I want to do.  I want to hide it on the first page it
comes to and display it on the one that comes after that, so I have to pass
it invisibly.

I've tried
and invisible field


then trying to pass it inside the form


and just assuming it is getting passed and putting a simple

which outputs it in that page and does not hide it at all.

How DO you do this?

Thanks for any help!
Britta



--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Solved... thanks everyone for your help!

[Britta Wingenroth]

INSERT INTO Products2 (ProductID, Product, UnitPrice)
 SELECT ProductID, Product, UnitPrice FROM new
 WHERE new.Product  NOT IN (SELECT Product from Products2)



UPDATE Products2 p, new n
SET p.UnitPrice = n.UnitPrice
WHERE p.Product = n.Product

- Original Message -
From: "Britta Wingenroth" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 10, 2000 8:01 PM
Subject: SQL or PHP with CF for this problem?


> This is a multi-part message in MIME format.
>
> --=_NextPart_000_0107_01BFBABA.98D543E0
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> I've used plain SQL so far with CF.  To solve this problem it was =
> suggested to me to use PHP/MySql.  I'm very anxious NOT to have to learn =
> another new language just for this if I don't have to . any =
> suggestions, please? =20
>
> I have two tables in my database, "Products2" being the one to be =
> updated,
> "new" being the one that the update information is coming from.  ***I =
> have
> written the queries to express what I want them to do, but they are not
> working.***
> I need to do two things:
>
> TO ADD A NEW PRODUCT from "new" to "Products2" if not already listed in
> "Products2":
>
> INSERT INTO Products2 (ProductID, Product, UnitPrice)
> SELECT ProductID, Product, UnitPrice FROM new
> WHERE new.Product <>Products2.Product
> (but this creates huge amounts of duplicates.  I need the product just =
> to be
> added once.)
>
>
> TO UPDATE A PRODUCT from "new" to "Products2" if the product in "new" is =
> the
> same as in "Products2" but the price in "new" has been updated.
>
> Update price of existing product:
> UPDATE Products2 (UnitPrice)
> SET UnitPrice=3D(SELECT UnitPrice FROM new)
> WHERE new.Product=3DProducts2.Product
> (I want to update those records in Products2 that have a different =
> UnitPrice
> in new.  Similar problem to the above...)
>
> Any ideas??
>
> Britta
>
>
>
>
>
>
>
> --=_NextPart_000_0107_01BFBABA.98D543E0
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> 
> 
>  http-equiv=3DContent-Type>
> 
> 
> 
> 
> 
> I've used plain SQL so far with =
> CF.  To solve=20
> this problem it was suggested to me to use PHP/MySql.  I'm very =
> anxious NOT=20
> to have to learn another new language just for this if I don't have to =
> . any=20
> suggestions, please?  I have two tables in my database, =
> "Products2"=20
> being the one to be updated,"new" being the one that the update =
> information=20
> is coming from.  ***I havewritten the queries to express what I =
> want=20
> them to do, but they are notworking.***I need to do two=20
> things:TO ADD A NEW PRODUCT from "new" to "Products2" if not =
> already=20
> listed in"Products2":INSERT INTO Products2 (ProductID, =
> Product,=20
> UnitPrice)SELECT ProductID, Product, UnitPrice FROM newWHERE =
> new.Product=20
> <>Products2.Product(but this creates huge amounts of =
> duplicates. =20
> I need the product just to beadded once.)TO UPDATE A =
> PRODUCT=20
> from "new" to "Products2" if the product in "new" is thesame as in=20
> "Products2" but the price in "new" has been updated.Update price =
> of=20
> existing product:UPDATE Products2 (UnitPrice)SET =
> UnitPrice=3D(SELECT=20
> UnitPrice FROM new)WHERE new.Product=3DProducts2.Product(I want =
> to update=20
> those records in Products2 that have a different UnitPricein =
> new. =20
> Similar problem to the above...)Any=20
> ideas??Britta BODY>
>
> --=_NextPart_000_0107_01BFBABA.98D543E0--
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

SQL or PHP with CF for this problem?

[Britta Wingenroth]

This is a multi-part message in MIME format.

--=_NextPart_000_0014_01BFBAB6.4D0B3EA0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I've used plain SQL so far with CF.  To solve this problem it was =
suggested to me to use PHP/MySql.  I'm very anxious NOT to have to learn =
another new language just for this if I don't have to . any =
suggestions, please? =20

I have two tables in my database, "Products2" being the one to be =
updated,
"new" being the one that the update information is coming from.  ***I =
have
written the queries to express what I want them to do, but they are not
working.***
I need to do two things:

TO ADD A NEW PRODUCT from "new" to "Products2" if not already listed in
"Products2":

INSERT INTO Products2 (ProductID, Product, UnitPrice)
SELECT ProductID, Product, UnitPrice FROM new
WHERE new.Product <>Products2.Product
(but this creates huge amounts of duplicates.  I need the product just =
to be
added once.)


TO UPDATE A PRODUCT from "new" to "Products2" if the product in "new" is =
the
same as in "Products2" but the price in "new" has been updated.

Update price of existing product:
UPDATE Products2 (UnitPrice)
SET UnitPrice=3D(SELECT UnitPrice FROM new)
WHERE new.Product=3DProducts2.Product
(I want to update those records in Products2 that have a different =
UnitPrice
in new.  Similar problem to the above...)

Any ideas??

Britta







--=_NextPart_000_0014_01BFBAB6.4D0B3EA0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable









I've used plain SQL so far with =
CF.  To solve=20
this problem it was suggested to me to use PHP/MySql.  I'm very =
anxious NOT=20
to have to learn another new language just for this if I don't have to =
. any=20
suggestions, please?  I have two tables in my database, =
"Products2"=20
being the one to be updated,"new" being the one that the update =
information=20
is coming from.  ***I havewritten the queries to express what I =
want=20
them to do, but they are notworking.***I need to do two=20
things:TO ADD A NEW PRODUCT from "new" to "Products2" if not =
already=20
listed in"Products2":INSERT INTO Products2 (ProductID, =
Product,=20
UnitPrice)SELECT ProductID, Product, UnitPrice FROM newWHERE =
new.Product=20
<>Products2.Product(but this creates huge amounts of =
duplicates. =20
I need the product just to beadded once.)TO UPDATE A =
PRODUCT=20
from "new" to "Products2" if the product in "new" is thesame as in=20
"Products2" but the price in "new" has been updated.Update price =
of=20
existing product:UPDATE Products2 (UnitPrice)SET =
UnitPrice=3D(SELECT=20
UnitPrice FROM new)WHERE new.Product=3DProducts2.Product(I want =
to update=20
those records in Products2 that have a different UnitPricein =
new. =20
Similar problem to the above...)Any=20
ideas??Britta

--=_NextPart_000_0014_01BFBAB6.4D0B3EA0--

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

SQL or PHP with CF for this problem?

[Britta Wingenroth]

This is a multi-part message in MIME format.

--=_NextPart_000_0107_01BFBABA.98D543E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I've used plain SQL so far with CF.  To solve this problem it was =
suggested to me to use PHP/MySql.  I'm very anxious NOT to have to learn =
another new language just for this if I don't have to . any =
suggestions, please? =20

I have two tables in my database, "Products2" being the one to be =
updated,
"new" being the one that the update information is coming from.  ***I =
have
written the queries to express what I want them to do, but they are not
working.***
I need to do two things:

TO ADD A NEW PRODUCT from "new" to "Products2" if not already listed in
"Products2":

INSERT INTO Products2 (ProductID, Product, UnitPrice)
SELECT ProductID, Product, UnitPrice FROM new
WHERE new.Product <>Products2.Product
(but this creates huge amounts of duplicates.  I need the product just =
to be
added once.)


TO UPDATE A PRODUCT from "new" to "Products2" if the product in "new" is =
the
same as in "Products2" but the price in "new" has been updated.

Update price of existing product:
UPDATE Products2 (UnitPrice)
SET UnitPrice=3D(SELECT UnitPrice FROM new)
WHERE new.Product=3DProducts2.Product
(I want to update those records in Products2 that have a different =
UnitPrice
in new.  Similar problem to the above...)

Any ideas??

Britta







--=_NextPart_000_0107_01BFBABA.98D543E0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable









I've used plain SQL so far with =
CF.  To solve=20
this problem it was suggested to me to use PHP/MySql.  I'm very =
anxious NOT=20
to have to learn another new language just for this if I don't have to =
. any=20
suggestions, please?  I have two tables in my database, =
"Products2"=20
being the one to be updated,"new" being the one that the update =
information=20
is coming from.  ***I havewritten the queries to express what I =
want=20
them to do, but they are notworking.***I need to do two=20
things:TO ADD A NEW PRODUCT from "new" to "Products2" if not =
already=20
listed in"Products2":INSERT INTO Products2 (ProductID, =
Product,=20
UnitPrice)SELECT ProductID, Product, UnitPrice FROM newWHERE =
new.Product=20
<>Products2.Product(but this creates huge amounts of =
duplicates. =20
I need the product just to beadded once.)TO UPDATE A =
PRODUCT=20
from "new" to "Products2" if the product in "new" is thesame as in=20
"Products2" but the price in "new" has been updated.Update price =
of=20
existing product:UPDATE Products2 (UnitPrice)SET =
UnitPrice=3D(SELECT=20
UnitPrice FROM new)WHERE new.Product=3DProducts2.Product(I want =
to update=20
those records in Products2 that have a different UnitPricein =
new. =20
Similar problem to the above...)Any=20
ideas??Britta

--=_NextPart_000_0107_01BFBABA.98D543E0--

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Totaling results of a dynamic form as numeric output.. Java or CF?

[Britta Wingenroth]

This is a multi-part message in MIME format.

--=_NextPart_000_005E_01BFB6ED.EA2DAEB0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Do I need to use java for this of can CF handle it?  I've only been =
working with CF for a few weeks, so if anyone can help me with this, I'd =
really appreciate it!
=20
I've got a dynamically generated form outputting query results, of which =
the customer will choose one. =20
=20

   =20
   
   motherboard for $1500 system @ $300
   
  =20
  
  
  #Product# @ #UnitPrice#
  


Then I need to multiply that number by "mothnum" which is the quantity =
of products.

Choose your Motherboard.

 0
 1
 2
 3
 4
 
 
=20
Any easy way of selecting the amount from the product selected, =
multiplying it by the quantity and then adding all those products =
together?   I don't even know where to start.





--=_NextPart_000_005E_01BFB6ED.EA2DAEB0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable









Do I need to use java for this of can =
CF handle=20
it?  I've only been working with CF for a few weeks, so if anyone =
can help=20
me with this, I'd really appreciate it!
 
I've got a dynamically generated form =
outputting=20
query results, of which the customer will choose one.  =

 
=
      motherboard for $1500 system @=20
$300   &n=
bsp;    #Product# @=20
#UnitPrice#  
 
Then I need =
to multiply=20
that number by "mothnum" which is the quantity of =
products.
 

Choose your=20
Motherboard. 0 1 2 3 4  
 
Any easy way of selecting the amount from the product selected, =
multiplying=20
it by the quantity and then adding all those products =
together?   I=20
don't even know where to start.
 
 
 
 

--=_NextPart_000_005E_01BFB6ED.EA2DAEB0--

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: passing variable with Javascript code.. got the answer.

[Britta Wingenroth \(Design Department\)]

I figured it out

- Original Message -
From: "Britta Wingenroth (Design Department)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 25, 2000 10:31 AM
Subject: passing variable with Javascript code


> This is a multi-part message in MIME format.
>
> --=_NextPart_000_001F_01BFAEA1.784356F0
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> I'm having trouble passing a parameter on with a Java code new window =
> function.  I know this is a really basic question but I'm just learning =
> Java... any help would be really appreciated.
>
>  I've got this in the head of the page:
>
> 
> function productwindow()
> {product=3Dwindow.open("products/1detailtemplate.cfm","Product_Detail","l=
> ocation,menubar,height=3D500,width=3D500");
> }
> 
>
> and this inside my query:
>
> 
> #Product#
>
> which works fine, but of course I need to pass the variable =
> ?Code=3D#Code# along with the search string to the 1detailtemplate.cfm =
> page for it to work.=20
>
> Thank you very much!
>
> Britta
>
> --=_NextPart_000_001F_01BFAEA1.784356F0
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> 
> 
>  http-equiv=3DContent-Type>
> 
> 
> 
> 
> I'm having trouble passing a parameter =
> on with a=20
> Java code new window function.  I know this is a really basic =
> question but=20
> I'm just learning Java... any help would be really =
> appreciated.
>  
>  I've got this in the head of =
> the=20
> page:
>  
> <script =
> language=3D"JavaScript">function=20
> productwindow()
>  size=3D2>{product=3Dwindow.open("products/1detailtemplate.cfm","Product_D=
> etail","location,menubar,height=3D500,width=3D500");}</script&=
> gt;
>  
> and this inside my =
> query:
>  
> <a=20
> href=3D"javascript:productwindow()">#Product#</a> V>
>  
> which works fine, but of course I need =
> to pass the=20
> variable ?Code=3D#Code# along with the search string to the =
> 1detailtemplate.cfm=20
> page for it to work. 
>  
> Thank you very much!
>  
> Britta
>
> --=_NextPart_000_001F_01BFAEA1.784356F0--
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Syntax error (missing operator) What am I missing here???

[Britta Wingenroth \(Design Department\)]

This is a multi-part message in MIME format.

--=_NextPart_000_0005_01BFAFA6.45CCE0F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

If you can see the problem, a solution would be greatly appreciated!  =
I'm new at this.  This is the error message:

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

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing =
operator) in query expression ''Laptop' SET ProductID=3D'123' SET =
Product=3D'testt' SET UnitPrice=3D'$50.00' SET Manufacturer=3D'sdfe' SET =
DescShort=3D'df''.=20



The error occurred while processing an element with a general identifier =
of (CFQUERY),=20

This is my code, with the variables passed from a form:



UPDATE Products2=20
 SET ProdType=3D'#ProdType#'
 SET ProductID=3D'#ProductID#'
 SET Product=3D'#Product#'
 SET UnitPrice=3D'#UnitPrice#'
 SET Manufacturer=3D'#Manufacturer#'
 SET DescShort=3D'#DescShort#'
 WHERE Code=3D#Code#
 

Thanks a lot,=20

Britta


--=_NextPart_000_0005_01BFAFA6.45CCE0F0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








If you can see the problem, a solution =
would be=20
greatly appreciated!  I'm new at this.  This is the error=20
message:
 
ODBC Error Code =3D 37000 (Syntax error =
or access=20
violation) 

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing =
operator) in=20
query expression ''Laptop' SET ProductID=3D'123' SET Product=3D'testt' =
SET=20
UnitPrice=3D'$50.00' SET Manufacturer=3D'sdfe' SET DescShort=3D'df''.=20


The error occurred while processing an element with a general =
identifier of=20
(CFQUERY), 
This is my code, with the variables passed from a form:

UPDATE Products2  SET ProdType=3D'#ProdType#' SET=20
ProductID=3D'#ProductID#' SET =
Product=3D'#Product#' SET=20
UnitPrice=3D'#UnitPrice#' SET =
Manufacturer=3D'#Manufacturer#' SET=20
DescShort=3D'#DescShort#' WHERE =
Code=3D#Code# 
Thanks a lot, 
Britta

--=_NextPart_000_0005_01BFAFA6.45CCE0F0--

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: maintaining decimal place

[Britta Wingenroth \(Design Department\)]

That was exactly what I needed...

Thanks a lot for your help!
Britta

- Original Message -
From: "Fred Sanders" <[EMAIL PROTECTED]>
To: "Britta Wingenroth (Design Department)" <[EMAIL PROTECTED]>
Sent: Tuesday, April 25, 2000 9:31 AM
Subject: Re: maintaining decimal place


> Sorry didn't read far enough down to see your example.
>
> #decimalformat(unitprice)#
>
> or since you want it to be a dollar amount how about
> #DollarFormat(unitprice)#  then you can take the $ out.
>
> - Original Message -
> From: "Britta Wingenroth (Design Department)" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Tuesday, April 25, 2000 10:51 AM
> Subject: Re: maintaining decimal place
>
>
> > Thanks Fred!
> >
> > It now displays 14.0 instead of 14., and if I add .95 it displays
> 14.95,
> > so this is effective to be able to do calculations.  Any suggestions
about
> a
> > fix for the missing 0 in display?  It's only cosmetic I know that would
> make
> > it perfect!
> >
> > I've tried doing this  to adjust the display:
> >
> > 
> > AND UnitPrice IS LIKE '%.0'
> > $#UnitPrice#0
> > 
$#UnitPrice#
> >
> > The problem is that it prints out a line of
> > AND UnitPrice IS LIKE '%.0'
> > for every product in the search.
> >
> > Thanks again for your help!
> > Britta
> >
> > - Original Message -
> > From: "Fred Sanders" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Tuesday, April 25, 2000 7:33 AM
> > Subject: Re: maintaining decimal place
> >
> >
> > > Set the Data Type to "Number",Field Size to "Double", Format to
"Fixed"
> > and
> > > Decimal Places to "2".
> > > That should do it for you two.
> > >
> > > Fred
> > >
> > > - Original Message -
> > > From: "Britta Wingenroth (Design Department)"
<[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>
> > > Sent: Tuesday, April 25, 2000 1:55 AM
> > > Subject: Re: maintaining decimal place
> > >
> > >
> > > > I'm looking for the answer to the same question.  I'm using Access
and
> > as
> > > > long as I have my values set as currency, once the query runs $14.00
> > turns
> > > > into14..  If anyone could help, we'd both appreciate not loosing
> our
> > > > minds!
> > > >
> > > > Britta
> > > >
> > > > - Original Message -
> > > > From: "Jay Wigginton" <[EMAIL PROTECTED]>
> > > > To: <[EMAIL PROTECTED]>
> > > > Sent: Monday, April 17, 2000 10:10 AM
> > > > Subject: maintaining decimal place
> > > >
> > > >
> > > > > I am having trouble for some reason with having data entered via a
> > form
> > > > into
> > > > > an Access database  and keeping the decimal places entered in
> place...
> > > > > person enters 2.5 the database rounds it to 2...  if I set the
> > database
> > > to
> > > > > number, type double... it maintains the decimal places but then CF
> > > > displays
> > > > > all the numbers entered with a decimal place and a zero added...
> 2.5
> > > > > entered displays as 2.5 181 entered displays as 181.0I
have
> > > never
> > > > > had this problem before that I can remember   Am I losing my
> mind
> > > here
> > > > > and just not doing something right?
> > > > >
> > > > > thanks
> > > > > Jay
> > > > >
> > > >
> > >
> >
>
> --
> > > > 
> > > > > Archives: http://www.eGroups.com/list/cf-talk
> > > > > To Unsubscribe visit
> > > >
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> > or
> > > > send a message to [EMAIL PROTECTED] with
'unsubscribe'
> > in
> > > > the body.
> > > > >
> > > >
> > >
> >
>
> --
> > > 
> > > > Archives: http://www.eGroups.com/list/cf-talk
> > > > To Unsubscribe visit
> > >
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or
> > > send a message to [EMAIL PROTECTED] with 'unsubscribe'
> in
> > > the body.
> > >
> >
>
> --
> > 
> > > Archives: http://www.eGroups.com/list/cf-talk
> > > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
> > send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
> > the body.
> > >
> >
>
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

passing variable with Javascript code

[Britta Wingenroth \(Design Department\)]

This is a multi-part message in MIME format.

--=_NextPart_000_001F_01BFAEA1.784356F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I'm having trouble passing a parameter on with a Java code new window =
function.  I know this is a really basic question but I'm just learning =
Java... any help would be really appreciated.

 I've got this in the head of the page:


function productwindow()
{product=3Dwindow.open("products/1detailtemplate.cfm","Product_Detail","l=
ocation,menubar,height=3D500,width=3D500");
}


and this inside my query:


#Product#

which works fine, but of course I need to pass the variable =
?Code=3D#Code# along with the search string to the 1detailtemplate.cfm =
page for it to work.=20

Thank you very much!

Britta

--=_NextPart_000_001F_01BFAEA1.784356F0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








I'm having trouble passing a parameter =
on with a=20
Java code new window function.  I know this is a really basic =
question but=20
I'm just learning Java... any help would be really =
appreciated.
 
 I've got this in the head of =
the=20
page: