creating a file download pick list?

I'm trying to set up a very simple web page with links to a
long list of documents for download. Rather than having users
download each document individually, I would like to allow them to
pick the files they need (by checkbox, ctrl-click, whatever) and
then bulk-download them.



First of all, is this possible with a very simple site, or do
I need a database of some sort?

Second, if it is possible, what's the best/easiest way to do
it?



Any hints much appreciated... Thanks!

highlight

videoDisplay.volume RESETS when a new...

If you set the volume for the videoDisplay to a certain
value, then load a new .flv into the videoDisplay, the volume
property is reset.



This is obviously not:



a) expected behaviour

b) at all consistent with how previous video components have
worked in Flash/Flex



So I am to assume it's some sort of bug?



If it is, does anyone have a work around?



Am I missing some new overly complicated AS3 standard way of
controling volume in Flex 2?



As usual, the documentation is completely useless. :(videoDisplay.volume RESETS when a new...
*bump*



Is there no solution to this?



Or is everyone merely omitting sound controls from their
video projects until the issue is patched?videoDisplay.volume RESETS when a new...
your not the only one......I'm running into the same problem
but its not a priority project yet so I haven't looked into it
yet......
*bump*



Well, it's good to know at least I'm not alone in my efforts
to solve this problem.
Wow ... it's amazing to see absolutely *NO* Adobe reponse to
this ... so no workaround ... no fix ... no acknowledgement of bug
...



I'm having a ton of issues with this ...
I've also tried a variety of things, but can't ever correct
the volume!



I've bound it to a vSlider, and that does work while the
video is playing, however if I load a new video it resets to .75
again. If I then attempt to even set the volume in code it fails
... :-(



Anyone else with ideas?
Ok ... after an hour plus ... I think that I have a
work-around that really sucks ... but it works!



I have added a listener for the ''state_change'' event on the
video display. When the event fires I check to see if it's a state
of ''playing'', and if so then I set the volume to ''0'', and then I
set it back to the value that I want ... the vSlider.value.



This seems to be working for me!
I've found other oddities with the videoDisplay when using
RTMP streaming from FMS - the streams won't clear no matter what I
do. I think that they need to work on the component a little
more.
Has anyone noticed a problem when streaming from a FMS, the
audio doubling up? Kind of like 2 displays are playing out of
sync?? It's driving me nuts, would having multiple states cause
something like this? All i could figure out was to set the source
to '' '' then stop(); and run a seperate function to reset the source
to what i want, the play()....

highlight

How do I stop these email notifications?

I keep receiving these ''Flash Support subscription update.''
emails, which I had subscribed to about a year or two ago, but I
don't want it any more and I can't find the option to cancel it. Am
I missing something or is there no option?How do I stop these email notifications?
Go to the Flash forum, click on the Profile link just below
the forum name, then click on Personal Options and make sure you
don't have any forums listed under Category Subscriptions.



You might have to ctl/cmd-click to remove a single
subscription.

TextField not displayed [AS 3.0]

Hi I downloaded and installed The Flash 9 authoring tool to
learn AS 3.0.

I tried the following sample in attachment. I have taken this
sample from livedocs AS 3.0 flash.text.TextField help file.



I Created the as file and saved the files as
TextField_alwaysShowSelection.as

Then i created fla file and saved in the same folder as
TextField_alwaysShowSelection.fla

In flash file i created the instance


var
tf:TextField_alwaysShowSelection = new
TextField_alwaysShowSelection();



No errors nothing but textfield didnot show up.

I tried putting up trace after


label1.alwaysShowSelection =
true;




trace(label1.text + '' - '' +
label1.x + '' - '' + label1.y)



It shows the correct values i tried visible property and a
lot of other things like using border property the values return
are correct but textfield is not displayed..



Can anyone help me solving this...TextField not displayed [AS 3.0]
%26gt;%26gt;In flash file i created the instance

%26gt;%26gt;var tf:TextField_alwaysShowSelection = new
TextField_alwaysShowSelection();



The code you posted is to be set as the document class. There
are two ways to do this:

-in the fla in the Property Inspector -%26gt; option 'Document
Class' -%26gt; TextField_alwaysShowSelection

-in the fla File -%26gt; Publish Settings -%26gt; tab Flash -%26gt;
ActionScript 3.0 option Settings -%26gt; Document Class -%26gt;
TextField_alwaysShowSelection

TextField not displayed [AS 3.0]
Oh...

Thanks for the reply..

I will try it..

Also is this mentioned somewhere..in the docs/help??
Yes, that's mentioned in the doc's.

The thing with your posted code is that when you set the
Document class you are in fact extending the _root (which wasn't
possible in AS2) and consequently the code 'knows' what you mean
with addChild() - add the TextField to the display list of the
_root.

If you want to create an instance of the
TextField_alwaysShowSelection class on the timeline you (like in
AS2) have to provide a target movieclip (or rather 'display
object') where the TextField has to be displayed.

var tf:TextField_alwaysShowSelection = new
TextField_alwaysShowSelection(this);

and the class as attached. But, you should always init an app
with a Document Class.


Thanks for the explanation.

Flash remoting and virtual hosts

Ok, this is a couple of days along... We've been able to
figure out that our flash remote object is not connecting because
it can't see the flashservices/gateway



If I go to the server
http://111.222.333.444/flashservices/gateway
I got a 404 file not found. From what I've been reading, this is a
bad thing. Anyone have any insight on why I'm not getting the ''good
blank screen''?

How do modify the highlight color of a...

HI! I want to know what is the easiest way to modify the
highlight color or

a button to RED. ( I want the helo-green or orange theme).



I know how to change the theme or by using the
setStyle(''themeColor'',

''haloOrange''); BUT there is no RED. so what is the easiest
root to modify

all button instances.?



PaulD





How do modify the highlight color of a...
Paul,



%26gt; I know how to change the theme or by using the
setStyle(''themeColor'',

%26gt; ''haloOrange''); BUT there is no RED. so what is the
easiest root to

%26gt; modify all button instances.?



Instead of named themes (like haloOrange), just specify a
hexadecimal

color as the second parameter. setStyle(''themeColor'',
0xFF0000); -- You'll

have to experiment whether that second parameter needs to be
in quotes or

not.





David Stiller

Adobe Community Expert

Dev blog,
http://www.quip.net/blog/

''Luck is the residue of good design.''





How do modify the highlight color of a...
David Stiller wrote:

%26gt; Paul,

%26gt;

%26gt;%26gt; I know how to change the theme or by using the
setStyle(''themeColor'',

%26gt;%26gt; ''haloOrange''); BUT there is no RED. so what is the
easiest root to

%26gt;%26gt; modify all button instances.?

%26gt;

%26gt; Instead of named themes (like haloOrange), just specify
a hexadecimal

%26gt; color as the second parameter. setStyle(''themeColor'',
0xFF0000); --

%26gt; You'll have to experiment whether that second parameter
needs to be in

%26gt; quotes or not.

%26gt;

%26gt;

%26gt; David Stiller

%26gt; Adobe Community Expert

%26gt; Dev blog,
http://www.quip.net/blog/

%26gt; ''Luck is the residue of good design.''



HI! Thanks it worked. below is the whole script to modify an
instance to

RED -- or any color.



import mx.styles.CSSStyleDeclaration;

var new_style:Object = new CSSStyleDeclaration();

_global.styles.myStyle = new_style;

new_style.setStyle(''color'', 0x666699);

setStyle(''styleName'', ''myStyle'');



// my_button.setStyle(''styleName'', ''myStyle''); --- Use this
to only modify

this instance.

_global.styles.myStyle.setStyle(''themeColor'', 0xC83F3F);



Hope this helps someone else. :)



Paul D

input with restricted and limited chars

hello,

I use the ShowMe Logon and want to entend the

functionallity:



1. To create an input field with max. 25 chars.

2. But I'll allow only inputs A-Z chars. No numbers

and so on ..

3. Wrong inputs have to be ignored! ( No warning message
after complete

inputs)

And that is my problem!

I tried some functions (keypress, etc.) but it don't work
correctly.

Any idea how to do it?





input with restricted and limited chars
You can set the char limit in the ''Text Field'' dialog. Open
the dialog using

the ''Text field'' button on the interaction properties.

To only allow A-Z you need to set up an interaction that
accepts anything

and then test the EntryText yourself. You can test to see if
they entered

all letters with this...

if
Strip(''abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ'',
EntryText)

= '''' then

-- entered all letters

end if

It won't put up a warning message unless you put it up.



Mike

====================

Mike Baker

Adobe Community Expert

mike-baker@cox.net





''Otto (No Spam )'' %26lt;Otto@myhost.de%26gt; wrote in message

news:erjpsm$fc7$00$1@news.t-online.com...

%26gt; hello,

%26gt; I use the ShowMe Logon and want to entend the

%26gt; functionallity:

%26gt;

%26gt; 1. To create an input field with max. 25 chars.

%26gt; 2. But I'll allow only inputs A-Z chars. No numbers

%26gt; and so on ..

%26gt; 3. Wrong inputs have to be ignored! ( No warning message
after complete

%26gt; inputs)

%26gt; And that is my problem!

%26gt; I tried some functions (keypress, etc.) but it don't
work correctly.

%26gt; Any idea how to do it?

%26gt;

%26gt;





input with restricted and limited chars
Hello,

I tried it, but it doesn't work correctly .. The user input
procedure ends

after

wrong char input or clear the input field ... But I'll try it
aigin. Hope I

can

find the mistake ..

Many thanks !



%26gt; To only allow A-Z you need to set up an interaction that
accepts anything

%26gt; and then test the EntryText yourself. You can test to
see if they entered

%26gt; all letters with this...

%26gt; if
Strip(''abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ'',

%26gt; EntryText)

%26gt; = '''' then

%26gt; -- entered all letters

%26gt; end if

%26gt; It won't put up a warning message unless you put it up.

list box problem

Can anyone help me



I have a contact form swf file with 2 text boxes %26amp; 3 list
boxes where the user selects their DOB. This movie works fine in
isolation until it is loaded into another movie then the list boxes
stop working;



They refuse to open and cannot be tabbed to.



Any ideas?

highlight

Flash applet (scrollview.swf)...

Hi, thanks for taking the time to read this. I have a serious
problem with a flash applet that is front and center (actually a
little to the right) on our home page. I am paid to update the
website for our church, and have been using flash 8 successfully
until now. We've never had any problems uploading and we've been
using this same flash file for a long time now (2 years?) and I've
never experienced this problem.



Anyway, if you go to
www.livepraylove.com you
will see that on the right side of the page, the flash file is
completely not loading. It's as if it isn't even on the server.
However, when I log into my ftp server, I see it there. I even
downloaded it off the server, and ran everything offline and it
worked fine in all browsers on my pc. It just isn't working online.



Is there something wrong with the code in my index.html page?
Or could I have saved the flash file in a way that is causing this
problem? Any advice would be greatly appreciated, since the longer
this goes on, the more trouble I'm going to be in.



Thanks!Flash applet (scrollview.swf)...
Shutez,



%26gt; Anyway, if you go to
http://www.livepraylove.com
you will

%26gt; see that on the right side of the page, the flash file
is completely

%26gt; not loading.



Heh ... actually, since it isn't loading, I ... I don't see
it. ;)



%26gt; It's as if it isn't even on the server.



It may simply not be in the place on the server that your
HTML says it

is.



Here's your HTML:



// inside your %26lt;object%26gt; tag:

%26lt;param name=''movie'' value=''scrollview.swf'' /%26gt;



... since no path is provided, scrollview.swf must be in the
same folder as

this very HTML document, yet ...




http://www.livepraylove.com/index.htmlscrollview.swf



... doesn't lead to a SWF file.



So either the SWF is a) not on the server, b) on the server,
but in a

different location, or c) possible your host hasn't set up
the server to

recognize the SWF file type.





David Stiller

Adobe Community Expert

Dev blog,
http://www.quip.net/blog/

''Luck is the residue of good design.''





Flash applet (scrollview.swf)...
never mind - I fixed the problem! It was a corrupted index
file. What was baffling about it, was that it would play fine
remotely, but when I went to upload, it had numerous problems. I'll
repost if I run into the problem again. Thanks!



Tim

USELESS SITE USELESS CUTOMER SUPPORT

OUR COMPANY ORDERED ACROBAT PROFESSIONAL .GOT THE CD AND NO
INFORMATION REGARDING THE LICENSE. SO TODAY I CALLED CUSTOMER
SUPPORT AND WAITED FOR ONE HOUR AND FINALLY GOT ONE IDIOT AND HE
SAID HE TRANSFERRING TO ANOTHER IDIOT AND I WAITED FOR ONE HALF
HOURS HEARING MUSIC .NEVER BUY ANY PRODUCTS FROM THIS COMANY. I
NEED HELP SETTING UP ACROBAT PROFESSIONAL . IS THERE ANYONE IN THIS
COMAPANY TO GET ME THE LICENSE. WORST EXP IN MY LIFEUSELESS SITE USELESS CUTOMER SUPPORT
I wouldsuggest to start by posting your question in a
readable and understandable way. All caps are difficult to read on
screen, and in the Internet they are considered the equivalent of
shouting, so many of those who could help you simply don't read
messages in all caps.



I normally read messages in all caps if they are not more
that three or four lines long. Whis is as far as I could go with
your message because it's not only in all caps, but also one very
long string of words without adequate spacings that would somewhat
ease its reading.



Finally, you are not addressing Adobe here, just fellow
users. See the Important Note at the bottom of the page.USELESS SITE USELESS CUTOMER SUPPORT
correc friend,

adobe is idiot,




see the pc crap from

adobe

adiobe idiot

simple calculations on an asp page

I am not sure the best way of doing this, and would
appreciate any advice or links to tutorials etc.



I have a search page and a results pages where a user can see
the results of their search.



I want to be able to multiply 2 of the values in each row of
the results table to give a total column.



Can this be done on the page or would it need to be done
outside asp.



Any advice would be appreciated.



simple calculations on an asp page
You can do this, replace:



%26lt;%=(Recordset.Fields.Item(''YOURFIELD'').Value)%%26gt;



with this:



%26lt;%=(Recordset.Fields.Item(''YOURFIELD'').Value) * 2%%26gt;



OR in the Recordset, replace''



SELECT YOURFIELD

FROM YOURTABLE



With



SELECT (YOURFIELD * 2) AS multiply

FROM YOURTABLE



Let us know if that works for you.





''Chris Morgan'' %26lt;webforumsuser@macromedia.com%26gt; wrote in
message

news:erf585$j3t$1@forums.macromedia.com...

%26gt;I am not sure the best way of doing this, and would
appreciate any advice

%26gt;or

%26gt; links to tutorials etc.

%26gt;

%26gt; I have a search page and a results pages where a user
can see the results

%26gt; of

%26gt; their search.

%26gt;

%26gt; I want to be able to multiply 2 of the values in each
row of the results

%26gt; table

%26gt; to give a total column.

%26gt;

%26gt; Can this be done on the page or would it need to be done
outside asp.

%26gt;

%26gt; Any advice would be appreciated.

%26gt;

%26gt;

%26gt;





simple calculations on an asp page
Thanks for the help, and sorry for the delay.



It works great for getting the simple totals.



Now I need to find a way of totaling all of these results.



The background is that it is adding up the working hours on a
project between two searchable dates - I would really like to have
a page where it shows the number of hours each day (done above),
and the total hours at the bottom of the list.



Any suggestions would be greatly appreciated.



Thanks
Can you explain the field/table structure and exactly what
you want.





''Chris Morgan'' %26lt;webforumsuser@macromedia.com%26gt; wrote in
message

news:es4cqn$9ra$1@forums.macromedia.com...

%26gt; Thanks for the help, and sorry for the delay.

%26gt;

%26gt; It works great for getting the simple totals.

%26gt;

%26gt; Now I need to find a way of totaling all of these
results.

%26gt;

%26gt; The background is that it is adding up the working hours
on a project

%26gt; between

%26gt; two searchable dates - I would really like to have a
page where it shows

%26gt; the

%26gt; number of hours each day (done above), and the total
hours at the bottom

%26gt; of the

%26gt; list.

%26gt;

%26gt; Any suggestions would be greatly appreciated.

%26gt;

%26gt; Thanks

%26gt;






Ideally I would like a simple tool to check the amount of
time an employee spends at work, that can add up the working hours
per day (done), and then create a total number of hours based on a
search criteria - so If I want to find our how many hours ''John''
has worked between the 1st and 20th of the month, or between the
10th and 25th it can auto total.



I have the search pages all working and now the daily hours,
all I need is the SUM all of the hours on the results page.



There is an Access Database behind the asp page (I have the
calculations working in Access using a SUM calculation
=Sum([Working minutes]*60, but am not sure how to create the
variable in DW.



The fields are start hour, start_mins, end_hour, end_minutes,
work_date, employee_name.



Hope this helps - the support is appreciated.

Changing Playback Settings

This would seem like a very basic question. How do you change
the settings for playback so that a (short) video you are viewing
online will loop back to the beginning and start playing again
automatically. I have installed the FlashUpdater9r28 on my Mac OS X
10.3.9, and it runs fine, but I cannot find a way to alter the
settings for this feature.



It would seem like there should be a way to change it such
that you don't have to constantly click on the play button over and
over and over . . .



''ctrl-click'' allows me to change some settings, but not this
one. Any thoughts?

IE stops responding

I have a list in a webpage showing a lot of links to swfs
showing in popup windows.



If I click the first, second and third link (random picks)
everything is allright. After each lesson (that's what it is) i
close the popup window). But at the fourth or sometimes fifth click
everything stops responding. The whole session denies any contact
with the Internet. The web page has to be closed and opened again
for things to function again.



I'm using PHP to make the swf show in the popup window:



Code:



$player = ''%26lt;object id=\''player$md5\''
classid=\''clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\'' codebase=\''
http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0, 29,0\''
width=\''$width\'' height=\''$height\''%26gt;\n'';

$player.= '' %26lt;param name=\''movie\'' value=\''$path\''%26gt;\n'';

$player.= '' %26lt;param name=\''quality\''
value=\''high\''%26gt;\n'';

$player.= '' %26lt;embed src=\''$path\'' quality=\''high\''
pluginspage=\''
http://www.macromedia.com/go/getflashplayer\''
type=\''application/x-shockwave-flash\'' width=\''$width\''
height=\''$height\''%26gt;%26lt;/embed%26gt;\n'';

$player.= ''%26lt;/object%26gt;\n'';



Please help!



Ronny,

Norway

Signature with Signature pad

Our engineering firm needs Engineers to be able to sign pdf
documents over their seal using a signature pad, is this possible?
Most of the signature functions im finding are secure digital
signatures that don't allow an actual epad signature.Signature with Signature pad
I am having the same problem. Have you solved it? Have you
gotten any replies?Signature with Signature pad
This forum is not PDF-related. It is for Connect (formerly
Breeze).

highlight

Security Sandbox Violation

Hi Everyone,



I am getting what looks like a cross-domain restriction
error. However, the domains only differ in their C-Name. Does this
seem right / wrong / confusing? The swf is being served by Tomcat
(port 8700) on serverA and the code that references the swf is
generated on ServerB. Both have a common domain name
(ourCompanyDomain.com). Below is the error message... Thanks a TON
for any insight you have!!



SecurityError: Error #2060: Security sandbox violation:
ExternalInterface caller
http://serverA.ourCompanyDomain.com:8700/flex/aMiM/bin/aMiM.swf
cannot access
http://serverB.ourCompanyDomain.com/?%26amp;method=AMiM.complex.

at
flash.external::ExternalInterface$/flash.external:ExternalInterface::_initJS()

at flash.external::ExternalInterface$/addCallback()

at bridge::FABridge/initializeCallbacks()

at bridge::FABridge$iinit()

at aMiM/::_FABridge1_i()

at aMiM$iinit()

at mx.managers::SystemManager/create()

at mx.managers::SystemManager/::initializeTopLevelWindow()

at mx.managers::SystemManager/::frameEndHandler()

creating a user page

how do i create a page that user can use to create their own
personal profile once they registered ?

Is it possible to have a page designed just for that and
everytime i get a new visitors that registers, that page will be
their profile page ?



I dont know if i am explaining myself enough, hope someone
knows what i am talking about and can help me out.



Thank you so muchcreating a user page
does anyone know about this ?creating a user page
Sounds like you need to create a database and store the
information

there. So it would be an insert form (in dw8). Of course once
you get

a data, how are you going to use it.




i am going to use it for user's to register and once they
logged in they can create a personal photo gallery with some
personal information. I also want to install a instant messenger
with it so that registered users can im eachother.

thanks
any suggestions?



txs
What language are your using? What datasbase are you using?
What is your experience level?
i am using PHP and HTML, MySQL with php supported DB, and i
am a website designer but it is the first time i am building
something like this.

I am reading MySQL and PHP for dynamic websites and i also
have read the PHP for the world wide web '' which was more for
begginers basic''
Since you are using dw you need to do more reading about the
things

that dw offers. Dreamweaver, the Missing Manual and
Dreamweaver 8

Unleashed both have good intro sections on databases. There
are also

some web site that have tutorials.



DW offers many helping hands. Behaviors for records,
deleting, editing

records. Until you do more research/study there is not much
to help

y0u with.



--




i understand what you are saying. I am now on that process. I
am actually learning with the help of Larry Ullman book , how to
create my own database. I know it takes awhile to learn, that's why
i need all the help i can get. i surely appreciate your help and
advice.




If I may, LuisDesigns, to add something to this information
here.



I think the books I have are going to be of a big help and
very useful, reliable tool *and* resource for you to use.



I recommend that you purchase two books, whose wrote by David
Powers, and the title and publishers are as follows below:



a) Foundation PHP for Dreamweaver 8, by David Powers,
published by An Apress Company (also friends of ed), and



b) PHP Solutions: Dynamic Web Design Made Easy, by David
Powers. Same publisher.



Additionally, I also find two other books very helpful for
me. I don't know if those other two are be of an interest for you.
But it is worth to mention it for you, and you can be the judge by
looking at those books perhaps at Barnes Noble or Border bookstores
in your hometown.



Additionally, I wanted to make a quick note, I really like
the first two books that I have mentioned as above as opposed to
the last two below. Because these two books (Foundation PHP for
Dreamweaver 8 and PHP Solutions by David Powers) are very clearly,
conise and well-through and well referenced, as well as thoroughly
documentated by the author. I commend him for that wonderful books
he wrote. I think you'd be immensely impressed with the quality of
information with Powers' books, you'll agree with me eventually.



I also think that you are experencing some kind of brain
frozen or stuck, and don't know where to get started. Let me assure
you that David Powers' books are going to be of a big help and a
wonderful guideline and steps as in 1, 2 and 3. If you decide to
purchase his books, be sure to visit the websites as directed by
the author, because there is some updated additional information
along with the books after the books released.



c) Learning PHP %26amp; MySQL by Michele E. Davis %26amp; Jon A.
Phillips, published by O'Reilly Media Inc, first edition (June
2006),



d) PHP and MySQL for Dynamic Web Sites, by Larry Ullman
published by Peachpit Press. (This covers PHP3/PHP4 and MySQL3/4).



One other thing, it is important to make a note that you need
to make sure that you have exact same versions of PHP and MySQL
versions on your local machine AND remote servers. If differs, you
could run into problems per se.



Hope that helps, no?

quote:

---

Originally posted by:
Newsgroup User

Since you are using dw you need to do more reading about the
things

that dw offers. Dreamweaver, the Missing Manual and
Dreamweaver 8

Unleashed both have good intro sections on databases. There
are also

some web site that have tutorials.



DW offers many helping hands. Behaviors for records,
deleting, editing

records. Until you do more research/study there is not much
to help

y0u with.



--

---

LuisDesigns,



I realized that I have failed to mention one other thing. I
didn't see what version of Dreamweaver you are working with? And
what system architecture you are working with also?
Thanks so much for that.

I am now with the book PHP AND MySQL for dynamic web site by
Larry Ullman 2nd Edition, it is my second book. The php and mysql
version are compatible with the ones on my server.

I am usind DW 8 .

i am noticing that the book i am on now is actually helping
me on creating a user database, maybe ''hopefully'' with this will be
enough. If not i will most definately follow your advice and get
the Foundation PHP for Dreamweaver 8 book, by David Powers.



Thanks so much.

Any advices to more are worth gold.
i forgot to mention, actually the 2nd edition of the book i
am on now, covers PHP 5 and mysql 4.1.

txs again
Hi LuisDesigns,



As for David Powers' 2nd book, PHP Solutions, is kind of
additional information that covers in depth discussion all about
PHP-related topics -- like as in easiest way to masters your skills
in PHP in time.



In that 2nd book, it also discuss pretty throughly about
secure PHP sites with lot of great examples. I think you'll find
that book very useful and perhaps that you might want to build and
expand your personal library with some great books. David Powers'
books happen to be one of well written books.



If you wish to send me a private message, and we can
communicate through private message off the forums, it can be done.
It is up to you.



Also, learning and working with PHP, it can be a bit of
challenging, but you'll do just fine in time. Perhaps that you
might want to buy yourself some fresh wholebeans of coffee and brew
it fresh at home, and get it going. Because you'll need some coffee
drink, do bit of reading and do bit of coding hands on and do bit
of testing all.
PRIVATE MESSAGE ME, OR IF U HAVE MESSENGER SEND IT TO MY PV,
That will be great.

i have been learning this all by myself for the last 2
months. I learned flash and i got pretty good at it, hehe.

need help reporting quiz results

I have done a test quiz and can't get the results to be
emailed using IE7, Captivate 1.01, Outlook 03.



I tested it in Opera and it did compose the email but with a
subject similar to this: ''Results 21/2/07'' and it had a blank body.



All I would simply like to do is have the results emailed or
posted into a database for review. I dont really care about the
method, as long as it is automatic. I know nothing about SCORM or
LMS's, so am wondering if it could be achieved simply by building a
basic site (PHP/MySQL)? If I did which output would I choose?
Otherwise I guess i could use an open source product. I really only
need something basic to just login and view results.



thanksneed help reporting quiz results
Ditto...

look around the board...

this isn't an isolated issue.



I can't get it to work either and I've tried on several
systems in serveral different configurations...and the manual isn't
helping.need help reporting quiz results
Look in the Adobe Captivate Developer Center for the article
by Tim Mushen titled ''Storing captivate test scores in a
database.....''



I replaced the cold fusion coding with sql and it worked
fine.

Cannot download Flash Player

When I try to download the Adobe Flash player, after clicking
instal, nothing happens.

Can anyone help?

ThanksCannot download Flash Player
Happens to me as well,but when I click install the video
loads and says that I have sucessfully downloaded the program(but
no window shows up for me to install).So I go to a site that needs
flash player.When it loads it links me to adobe and tells me to
download flash player. =\Cannot download Flash Player
I have a similar problem after I click download it goes to a
screen with 2 Xed out boxes. This happens on 2 different computer
running vista after uninstalling flash or reseting IE settings.
never gives me the option to download just goes to the verify
screen and never pops up the activex control install.

quote:

---

Originally posted by:
Raymondlk

Happens to me as well,but when I click install the video
loads and says that I have sucessfully downloaded the program(but
no window shows up for me to install).So I go to a site that needs
flash player.When it loads it links me to adobe and tells me to
download flash player. =\

---

I am having the same problems. I have tried reloading,
uninstalling and reinstalling, everything I can think of. Anyone
have any suggestions?

Web Service?

It would be cool if someone made a page that spat out a
random swatch. That way I would build my CSS page to grab a swatch
randomly and use the color and keep refershing til I saw one I
liked once I got a page all CSS'd out.



Another cool idea is a search tool where you could say '' I
have these two colors, show me swatches that match''.Web Service?
Hi,

Thanks for the post! Are you a web designer? How are you
using kuler?

SamiWeb Service?
I'm a visually-challenged web developer I mainly do the
programming and functionality stuff. Occasionaly a project arises
where I need to try to make something look good and it always kills
me. I use kuler to try and find good color combos that other less
challenged people may have thought of.
Hi, that's great! I'll pass your ideas along to the team.

Sami

newbie in 3d, please help

Hi.



I'm experianced director programmer but totally new to 3D
features

Now I have to use it in my project and I need a small example
or or good

tutorial



I have a lot of parallelepiped-Objects on the screen, they
are stored like

boxes in the warehouse - N rows x M columns build one
''layer'', there can

be a couple of layers stored on each other



each parallelepiped is single sprite, that have to responce
to

useractions(mouseover, mouseclick etc)



What I need is to move camera arount and look on this
structure of

parallelepipeds from all sides.



I would very appreciate, if someone can point me to some
example, which

shows this. It would be enough when there are 2 different
objects on the

stage and the user can move the point of view to the left or
to the right

so, that we can make complete circle around of this 2
separate

objects(sprites)



Any help will be appreciated



Orest









newbie in 3d, please help
You say ''each parallelepiped is single sprite''. Do you mean a
2D sprite, or a 3D model?



Here is a demonstration of two objects that react to mouse
over and click-and-drag, and where you can use the arrow keys to
rotate the camera around the objects:
http://nonlinear.openspark.com/tips/3D/dragmodel/.
If you replace the 3D member with your own, and adapt the ''Turn
Model'' behavior, you should be able to use the same framework with
your layers of objects.newbie in 3d, please help
Hi openspark



Thank you very much for an answer



that example is not really the same what I need (or probably
i don't suppose

that this is the right way)



I have one 3D-Castmember with single parallelepided in it

From this castmember I want to create 2 or more sprites on
the stage, each

of them becames different texture on top side(surface)



The question is: can I have single camera and rotate around
of all these

sprites to see the construction from different sides?



Or do i have to create copies of parallelepideds in on single
3D member and

rotate a camera there?



I know this question can be stupid, but I'm totally new to it
and need to

find the right way to mamage the situation



I would very appreciate any answer



''openspark'' %26lt;webforumsuser@macromedia.com%26gt; wrote in
message

news:erj6da$4qq$1@forums.macromedia.com...

%26gt; You say ''each parallelepiped is single sprite''. Do you
mean a 2D sprite,

or a

%26gt; 3D model?

%26gt;

%26gt; Here is a demonstration of two objects that react to
mouse over and

%26gt; click-and-drag, and where you can use the arrow keys to
rotate the camera

%26gt; around the objects:
http://nonlinear.openspark.com/tips/3D/dragmodel/.
If

you

%26gt; replace the 3D member with your own, and adapt the ''Turn
Model'' behavior,

you

%26gt; should be able to use the same framework with your
layers of objects.

%26gt;






Here's a tutorial on how to create several cameras in a
single member, and use a different camera for each of four sprites
created from that member:
http://director-online.com/buildArticle.php?id=1140.
Is this more like what you are looking for?
No



in the example, you've quoted, there are 4 cameras for the
same 3D object



I need ONE common camera for many sprites, that represent the
same 3D

cartmember - as example - you know the game called mahjongg.
I will have one

tile as 3D cartmember with single parallelepiped in it.

From this castmember I will create some layout with many
tiles (each tile

has to be a single sprite in score).

For this layout I need one camera which can be moved around
of the layout ,

so the user can see each detail of the layout from the each
side of horizon



''openspark'' %26lt;webforumsuser@macromedia.com%26gt; wrote in
message

news:erk8ho$dsm$1@forums.macromedia.com...

%26gt; Here's a tutorial on how to create several cameras in a
single member, and

use

%26gt; a different camera for each of four sprites created from
that member:

%26gt;
http://director-online.com/buildArticle.php?id=1140.
Is this more like

what

%26gt; you are looking for?

%26gt;






If you have one camera and many 3D sprites with the same
member, all the sprites will look the same (except perhaps for
size). Is this what you want?



Are you sure that you want many sprites with the same member,
rather than several 3D models in the same 3D member? Perhaps if you
post a mock-up or a storyboard of what you are trying to achieve I
will understand better.
as example - you know the game called mahjongg. I will have
one

tile as 3D cartmember with single parallelepiped in it.

From this castmember I will create some layout with many
tiles (each tile

has to be a single sprite in score and will get a specific
texture).

For this layout I need one camera which can be moved around
of the layout ,

so the user can see each detail of the layout from the each
side of horizon



Another example

there is a 3Dmember, contaning a tree

I want put 2 trees on the screen and move one camera around
them (so the

user will have an impression he runs i a circle around of
this trees)



''openspark'' %26lt;webforumsuser@macromedia.com%26gt; wrote in
message

news:erl5nb$hjh$1@forums.macromedia.com...

%26gt; If you have one camera and many 3D sprites with the same
member, all the

%26gt; sprites will look the same (except perhaps for size). Is
this what you

want?

%26gt;

%26gt; Are you sure that you want many sprites with the same
member, rather than

%26gt; several 3D models in the same 3D member? Perhaps if you
post a mock-up or

a

%26gt; storyboard of what you are trying to achieve I will
understand better.

%26gt;

highlight

Looking for a flash developer to give...

Question about exe's

I dont create a lot of exe files, but I need to make a cd for
a

client, I wanted to know that if I call swf's into the exe
will it

still play fine on a machine without flash. Any help is
appreciated.



Thanks

Randy

Question about exe's
That is the point of the exe. It bundles the Flash player
into itself so that even if the end-user doesn't have Flash
installed or has a different version of the player it will work.



Remember that all references to external resources, swf, flv,
mp3, jpg, etc. will be relative to the exe/projector. So if you
have a projector that loads a swf and the swf loads a jpg, the path
for loading the jpg will start from the projector NOT the swf.



There are also some cross domain issues that may come into
play if you are trying to load content from the web with a CD. I
think they can be worked around, but I don't know much about it.



Finally, remember that some things work differently when
playing locally vs. over the internet. The biggest one I know is
that preloaders don't work, but you still can't count on everything
loading instantaneously.Question about exe's
Thanks Rothrock

Question about exe's

I dont create a lot of exe files, but I need to make a cd for
a

client, I wanted to know that if I call swf's into the exe
will it

still play fine on a machine without flash. Any help is
appreciated.



Thanks

Randy

Question about exe's

I dont create a lot of exe files, but I need to make a cd for
a

client, I wanted to know that if I call swf's into the exe
will it

still play fine on a machine without flash. Any help is
appreciated.



Thanks

Randy

Need help with themes and..

Hi, I just finished the Lynda's Dreamweaver tutorials, but
their are 2 things it didn't tell me I'd like to know



First, Some websites have multiple themes that upon selecting
one changes the whole appearance of the website, but keeps the
content the same. I would like to know how to do this



Also I'd like to know how to make it so my site could keep
creating/flipping pages every new day kind of how a site like
www.fark.com does it. So I don't
have to create a new page everday and push back the old ones! :) Im
assuming theirs a very automated way to do this.



Any help with this is greatly appreciated :) thx
Need help with themes and..
%26gt;%26gt;Some websites have multiple themes



Done by switching CSS. Here is the ultimate example:


http://www.csszengarden.com/



--



Walt





''Mahsage'' %26lt;webforumsuser@macromedia.com%26gt; wrote in
message

news:ergilh$r6h$1@forums.macromedia.com...

%26gt; Hi, I just finished the Lynda's Dreamweaver tutorials,
but their are 2

%26gt; things

%26gt; it didn't tell me I'd like to know

%26gt;

%26gt; First, Some websites have multiple themes that upon
selecting one changes

%26gt; the

%26gt; whole appearance of the website, but keeps the content
the same. I would

%26gt; like

%26gt; to know how to do this

%26gt;

%26gt; Also I'd like to know how to make it so my site could
keep

%26gt; creating/flipping

%26gt; pages every new day kind of how a site like www.fark.com
does it. So I

%26gt; don't

%26gt; have to create a new page everday and push back the old
ones! :) Im

%26gt; assuming

%26gt; theirs a very automated way to do this.

%26gt;

%26gt; Any help with this is greatly appreciated :) thx


%26gt;





Need help with themes and..
Alright that page helps big time....



Part 2



Also I'd like to know how to make it so my site could keep
creating/flipping pages every new day kind of how a site like
www.fark.com does it. So I don't have to create a new page everday
and push back the old ones! :) Im assuming theirs a very automated
way to do this.




I don't understand your second question.



--



Walt





''Mahsage'' %26lt;webforumsuser@macromedia.com%26gt; wrote in
message

news:erglvm$15j$1@forums.macromedia.com...

%26gt; Alright the FAQ on that page pretty much answered that,
but how about part

%26gt; 2 of

%26gt; the question.....

%26gt;

%26gt; Part 2

%26gt;

%26gt; Also I'd like to know how to make it so my site could
keep

%26gt; creating/flipping

%26gt; pages every new day kind of how a site like www.fark.com
does it. So I

%26gt; don't

%26gt; have to create a new page everday and push back the old
ones! :) Im

%26gt; assuming

%26gt; theirs a very automated way to do this.

%26gt;

%26gt;

%26gt;






Erm...I'll try to word it better



Some sites like the one I pointed out to you
www.fark.com have a system were
every single day the news from the previous day gets pushed down or
to the NEXT page.



I am assuming that people who run sites like this don't go
and create new pages to put their old stuff on everyday so I want
to know how they automate that.





Basically lets say theirs 10 days worth of news on my site
ok? I want the 2 most recent days to be on the front page and ever
day that came before to be constantly be pushed back. so after a
year or do I would have something like around 180 back pages of
news. With massive numbers like that I am assuming their is a
method these places are using and they aren't going through ever
pack page everyday and renumbering them and such....
Heres another way to explain it



Day 4, their are 4 pages of news on the site



Day 4 and 3 would be on page 1 day 2 and 1 would be on page 2



Now skip to day six



Day 6 and 5 page 1 / Day 4 and 3 page 2 / Day 2 and 1 Page
3
So.....
On Wed, 21 Feb 2007 06:23:46 +0000 (UTC), ''Mahsage''

%26lt;webforumsuser@macromedia.com%26gt; wrote:



%26gt;Erm...I'll try to word it better

%26gt;

%26gt; Some sites like the one I pointed out to youwww.fark.com
have a system were

%26gt;every single day the news from the previous day gets
pushed down or to the NEXT

%26gt;page.

%26gt;

%26gt; I am assuming that people who run sites like this don't
go and create new

%26gt;pages to put their old stuff on everyday so I want to
know how they automate

%26gt;that.

%26gt;

%26gt;

%26gt; Basically lets say theirs 10 days worth of news on my
site ok? I want the 2

%26gt;most recent days to be on the front page and ever day
that came before to be

%26gt;constantly be pushed back. so after a year or do I would
have something like

%26gt;around 180 back pages of news. With massive numbers like
that I am assuming

%26gt;their is a method these places are using and they aren't
going through ever

%26gt;pack page everyday and renumbering them and such....





On www.fark.com I see three days worth, not two.



Put all of the content into a database. How you do that is up
to you:

would you be responsible for all of the content? If not,
would you be

monitoring (approving) submissions?



Sort by descending date, so the most recent gets displayed
first.

Allow however many days worth you want per page.



It's actually rather easy to do this, and there are lots of
free

modules available. I've lost the beginning of the thread:
what server

side language would you be using?



Win

--

Win Day, Wild Rose Websites


http://www.wildrosewebsites.com

winday@NOSPAMwildrosewebsites.com

Skype winifredday


Win gave you the correct approach: a dynamic, database driven
site. IOW not

simple or easy if you are new to web design.



BTW the industry term for the capability you seek is CMS
(Content Management

System). Google that for a starting point.



--



Walt





''Mahsage'' %26lt;webforumsuser@macromedia.com%26gt; wrote in
message

news:ergomf$3se$1@forums.macromedia.com...

%26gt; Heres another way to explain it

%26gt;

%26gt; Day 4, their are 4 pages of news on the site

%26gt;

%26gt; Day 4 and 3 would be on page 1 day 2 and 1 would be on
page 2

%26gt;

%26gt; Now skip to day six

%26gt;

%26gt; Day 6 and 5 page 1 / Day 4 and 3 page 2 / Day 2 and 1
Page 3

%26gt;

Resizing components with left, right,...

Hello,



I'm creating a TabNavigator component by mxml

%26lt;mx:TabNavigator id=''modelTabNavigator'' top=''30''
width=''100%'' bottom=''200'' enabled=''false''%26gt;



Now i would like to resize it's height by adjusting the
bottom property.



modelTabNavigator.bottom = 0;



does not work because ''bottom'' isn't known.

(I got width %26amp; height properties but thats not exactly
what i need to change in this case)



There must be a way to change this?!



Cheers!

Resizing components with left, right,...
The top, bottom, left, and right are actually styles, not
properties (don't ask me why). Change them like this:



modelTabNavigator.setStyle(''bottom'',0);Resizing components with left, right,...
Great, thank you Peter.

I knew it would be something simple.



When i think about CSS and stuff, top, bottom etc really are
used there as style properties. like %26lt;div width=''100%''
style=''bottom:0px''%26gt;%26lt;/div%26gt; ... So it makes pretty much
sense.
Ah, that does make sense. As much contact as I have with the
Flex engineering folks, I've never thought to ask them why they
made these styles. Thanks!
Thats all fine and dandy but it now causes a new problem. I
came across this solution after pulling all my hair out but it
still won't do what I want it to.



Setting a sequence that changes the bottom style will not
animate the change. it just jumps as there is no duration value
available to the setstyleaction tag.



I've tried animating a resize but after the resize is
complete, the bottom value resets it back to original. I tried
following that up with a setstyleaction but even that won't work.



There has to be some kind of workaround for this situation.
Any ideas?



TIA.

highlight

Flex back-ups

I'm new to Flex but not new to Flash. When I develop projects
in Flash I keep a dev folder and at the start of each work day I
make a duplicate of the current work folder to ensure I always have
a back-up if something goes wrong that day.



I've started to explore the Flex Builder GUI and can see that
you designate a project folder for each project. How should I
implement back-up versions of my project to achieve the above? Some
kind of CVS I'm guessing but any guidance would be appreciated -
haven't had much luck with google searches for Flex with CVS.



NickFlex back-ups
Any help?

Datagrid Itemrenderer scrolling problem

Hi,



I have a datagrid bound to an ArrayCollection. For one column
I have a custom item renderer - which is a textbox.

It works OK except when you scroll the rows and values get
jumbled up randomly.



I'd be grateful if anyone has any ideas.



Thanks,

danDatagrid Itemrenderer scrolling problem
itemRenderers are re-used. Only a handful of itemRenderers
are created. If you have 100 records in your data, but the DataGrid
is showing only 10 rows, then only 10 itemRenderers are created. As
you scroll the itemRenderers are shuffled about and re-used. For
example, if you scroll up 1 row, the itemRenderer for the 1st row
is moved to the bottom and the itemRenderers for rows 2-10 are
moved up. That's so they don't have to be redrawn. The 1st row
itemRenderer is then reset - its data property is given the value
for the 11th row.



If you itemRenderer is just a text box, then you should be
able to do:



%26lt;mx:Text text=''{data.
field}'' ... /%26gt; and have the text box populated with
whatever is in the field property for the row.

Datagrid Itemrenderer scrolling problem
Peter,



Many thanks for the response. Unfortunately I cannot get this
to work properly and I don't think I can be alone.

Looking at the example in the Flex developer guide (see
below) the problem is the same here as well - when I put enough
rows in the array to require scrolling, the values entered in the
custom item renderer are randomly jumbled when I scroll.



This is causing me a major problem at the moment!




Flex
item renderer example
I struggled with this problem for a while as well, but
re-read Peter's reply and it's exactly what happens - there is not
a renderer per row in the dataprovider, but a renderer for each
visible row (or thereabouts).



This means they get reused, so you can keep any state in the
renderer objects across a renderer use. I suggest you

stick a static var in the renderer, increase it in the
constructor and then put debug statements in the constructor and
each of the methods that you overwrote to see which instance is
used, in which order the methods are called and what's

going on. Based on your description there is state hanging
around in the renderer that make the renderer on re-use look like
some other row (the one it was used for before).



R.
Thanks very muh R.

I understand what is happning however I don't see how this
can't be a bug. I simply cannot get it to work - be it with the
Flex developer examples or my own rendererers. Can you try the
example I highlighted form the Flex developer guide with enough
array entries to scroll? It seems to me that there is a fundamental
problem here.




Flex
item renderer developer example
OK I finally got it to work - so thanks for pointing me in
the right direction.



Effectively you need to override the get data method and
return a data object that you have kept in line with changes, e.g.:

var retObj:Object;



in set data(value:Object):

retObj = value



then when the text input text is changed set the relevant
property of retObj



and override the get data :

override public function get data():Object{

return retData;

}

quote:

---

Originally posted by:
rkschulz

I struggled with this problem for a while as well, but
re-read Peter's reply and it's exactly what happens - there is not
a renderer per row in the dataprovider, but a renderer for each
visible row (or thereabouts).



This means they get reused, so you can keep any state in the
renderer objects across a renderer use. I suggest you

stick a static var in the renderer, increase it in the
constructor and then put debug statements in the constructor and
each of the methods that you overwrote to see which instance is
used, in which order the methods are called and what's

going on. Based on your description there is state hanging
around in the renderer that make the renderer on re-use look like
some other row (the one it was used for before).



R.

---

Could you provide an example, please? I hardly understand
what you are writing about :-) Sorry.




Hi Keytree,



Many thanks for the explanation.



However i still can't get it to work.



Please find the codes below and please check and advise if
i've missed something.



thx and regards



Benoit



%26lt;?xml version=''1.0'' encoding=''utf-8''?%26gt;

%26lt;mx:VBox xmlns:mx=''
http://www.adobe.com/2006/mxml''
horizontalAlign=''center''%26gt;

%26lt;mx:Script%26gt;

%26lt;![CDATA[



import mx.controls.Alert;



// Define a property for returning the new value to the
cell.

public var result:String='''';



[Bindable]

private var dp: Array = [

{label:''None'',data:1},

{label:''Amt'', data:2},

{label:''%'', data:3}

];



public var retObj:Object;

public static var test:Number=0;



// Override the set method for the data property.

override public function set data(value:Object):void

{

test++;

retObj=value;

//Alert.show(new String(test));

super.data = value;





if (value != null)

{

var currentValue:String = value.size;

var len:int = dp.length;

for (var i:int = 0; i %26lt; len; i++)

{

if (dp
.data == currentValue)

{

editor.selectedIndex = i;

break;

}

}

}





}



override public function get data():Object

{

return retObj;

}



public function onChange():void

{

//what need to be set here??

}

]]%26gt;

%26lt;/mx:Script%26gt;

%26lt;mx:ComboBox id=''editor'' dataProvider=''{dp}'' width=''130''
change=''onChange()''/%26gt;

%26lt;/mx:VBox%26gt;

quote:

---

Originally posted by:
rkschulz

I struggled with this problem for a while as well, but
re-read Peter's reply and it's exactly what happens - there is not
a renderer per row in the dataprovider, but a renderer for each
visible row (or thereabouts).



This means they get reused, so you can keep any state in the
renderer objects across a renderer use. I suggest you

stick a static var in the renderer, increase it in the
constructor and then put debug statements in the constructor and
each of the methods that you overwrote to see which instance is
used, in which order the methods are called and what's

going on. Based on your description there is state hanging
around in the renderer that make the renderer on re-use look like
some other row (the one it was used for before).



R.

---

Do you think you could provide a simple example (e.g. a
TextRenderer) which includes your ''static var'' solution? I don't
exactly understand where to put it and how...
Hi R,

While searching on the net i have found this link:
http://www.meutzner.com/blog/index.cfm/2006/6/22/ComoboBox-RendererEditor-for-20 .



It explains clearly how to use item renderers and provide a
very nice example.



Hope this helps you out.



regards



Benoit

Urgent help with Index page needed

Can anyone help? I use Dreamweaver 8 to modify and update my
work's website and I've come across a very strange problem that I
haven't seen before. I amended a news page, entitled 'news.html'
and uploaded it as normal last week. I also put a few new pictures
on the index page and did the same. It was fine at that point,
however having looked at the page four days later, the news page
now shows as the home page when you visit the site. It isn't
calling itself the index page as the browser still shows as the
page as 'news.html'.



But the strange thing is, when you first go to the site or
click the homepage from an internal page, you get a very quick
glimpse of the original index page before the news page replaces
it. Almost overwrites it.



VERY confused. Have tried re uploading the index page and am
running out of solutions. Any help most welcome.Urgent help with Index page needed
On Wed, 21 Feb 2007 11:54:52 +0000 (UTC), ''Rach JH''

%26lt;webforumsuser@macromedia.com%26gt; wrote:



%26gt;Can anyone help? I use Dreamweaver 8 to modify and update
my work's website and

%26gt;I've come across a very strange problem that I haven't
seen before. I amended a

%26gt;news page, entitled 'news.html' and uploaded it as normal
last week. I also put

%26gt;a few new pictures on the index page and did the same. It
was fine at that

%26gt;point, however having looked at the page four days later,
the news page now

%26gt;shows as the home page when you visit the site. It isn't
calling itself the

%26gt;index page as the browser still shows as the page as
'news.html'.

%26gt;

%26gt; But the strange thing is, when you first go to the site
or click the homepage

%26gt;from an internal page, you get a very quick glimpse of
the original index page

%26gt;before the news page replaces it. Almost overwrites it.

%26gt;

%26gt; VERY confused. Have tried re uploading the index page
and am running out of

%26gt;solutions. Any help most welcome.



URL?



Win

--

Win Day, Wild Rose Websites


http://www.wildrosewebsites.com

winday@NOSPAMwildrosewebsites.com

Skype winifredday

Urgent help with Index page needed
url is www.bofa.co.uk



Thanks!
Rach JH wrote:

%26gt; url is www.bofa.co.uk



Have you asked the original designers? The page still has
their signature at

the bottom...



--

Pete.






happens both in IE, FF. You need to search /replace in the
code for news.html.

If you change one, then test. Then that one is garbled.

It wont just ''link'' to anything, just coming across
news.html. MB even your flashfile is garbled.



Lets hear what happens.
happens both in IE, FF. You need to search /replace in the
code for news.html.

If you change one, then test. Then that one is garbled.

It wont just ''link'' to anything, just coming across
news.html. MB even your flashfile is garbled.



Sorry, my technical language is quite basic. I know the site
is a mess. I only took it on recently and have had to try to work
with what I've got, I'm just struggling to understand why it would
suddenly do this. Any chance you could explain what you mean? Sorry
to be a pain, but although I use Dreamweaver, I'm not a code
person! Many thanks for the help so far.
love to see the code for the index.html page.....



interesting problem...



greg



Rach JH wrote:

%26gt; happens both in IE, FF. You need to search /replace in
the code for news.html.

%26gt; If you change one, then test. Then that one is garbled.

%26gt; It wont just ''link'' to anything, just coming across
news.html. MB even your

%26gt; flashfile is garbled.

%26gt;

%26gt; Sorry, my technical language is quite basic. I know the
site is a mess. I only

%26gt; took it on recently and have had to try to work with
what I've got, I'm just

%26gt; struggling to understand why it would suddenly do this.
Any chance you could

%26gt; explain what you mean? Sorry to be a pain, but although
I use Dreamweaver, I'm

%26gt; not a code person! Many thanks for the help so far.

%26gt;


Any ideas?



Getting desperate now and need to get this sorted out. What
do I need to look for in the code on news.html page?
If others are like me, we are not quite sure what your
questions are. Wanna

review?



--

Murray --- ICQ 71997575

Adobe Community Expert

(If you *MUST* email me, don't LAUGH when you do so!)

==================


http://www.dreamweavermx-templates.com
- Template Triage!


http://www.projectseven.com/go
- DW FAQs, Tutorials %26amp; Resources


http://www.dwfaq.com - DW FAQs,
Tutorials %26amp; Resources


http://www.macromedia.com/support/search/
- Macromedia (MM) Technotes

==================





''Rach JH'' %26lt;webforumsuser@macromedia.com%26gt; wrote in
message

news:erhsve$hg5$1@forums.macromedia.com...

%26gt; Any ideas?

%26gt;

%26gt; Getting desperate now and need to get this sorted out.
What do I need to

%26gt; look for in the code on news.html page?






the problem is your ''Bofa move.swf'' file. It automatically
redirects to the news page. You can test it yourself in the
browser:




http://www.bofa.co.uk/Bofa
move.swf



as you can see it will redirect you imediately to the news
page.



Either fix the code in the swf or just remove it and replace
it with an image.
Thankyou thankyou thankyou!



Sorted the problem straight away.



That'll teach me to play with Flash!
great job, envision. I could not get around to d/l the .swf



:-)



weird problem :-D funny ..

Spry Updates?

Hello guys,



I was wondering how close you are to releasing Spry 1.5? I'm
just curious (as I'm sure everyone else is) since I'm looking to
setup a project using nested XML data for one table and need nested
XML support for this. The tricks I used to do this slows down my
page loads and the demos aren't working for a one table design that
I need.



I have one table with multiple tools sets per row that need
to have be link/href'ed separately or I would have them listed
comma/space sep. under one %26lt;td%26gt;%26lt;/td%26gt;.



If your close I'll wait but if not, maybe I'll have to try
something else.



Thanks, Matt M













Spry Updates?
Hey widgeter,



I'm anxiously waiting for 1.5 as well. I ran into the same
situation, and ended up taking an alternative route:

See
My
Topic for details. It didn't slow down my page loads as far as
I can tell, because it's querying the other datasource after
pageload.



On second thought, I see that your problem is more complex
than mine; you want the nested fields in each row, while I only
wanted them in the detail region when a row is selected... hmm.



good luck,

MaquellySpry Updates?
Ahh, I think many of us are and can understand why they don't
want to commit to anything. I just figured if they needed someone
to give it a test, (all built except for nested area), I would be
willing to give feedback. %26lt;vbg%26gt;



Yes, my nested XML needs to be on the same row AND each
nested data item be a dynamic link to another page. I tried looping
based on amount of nested elements

...

%26lt;tools%26gt;

%26lt;tool1%26gt;%26lt;/tool1%26gt;

%26lt;tool2%26gt;%26lt;/tool2%26gt;

...etc

%26lt;/tools%26gt;

%26lt;toolcounter%26gt;2%26lt;/toolcounter%26gt;



...then did a loop within spry when not ''undefined'' print but
this caused a slowdown when dealing with 200+ rows of data.

for ($i; $i%26lt;{toolcounter}; $i++) {

%26lt;a href=''/path/{tool$i}...''%26gt;{tool$i}%26lt;/a%26gt;......



You get the jist. Anyway, we're all anxiously waiting BUT
guys...keep up the great work as we appreciate what is already
done... Dojo, Rico, etc... may have alot of features but they are
not well documented or buggy. Spry (whats been released) works....
and NICELY documented...



Matt M






Hi Matt,



Unfortunately we can't commit to a date for Spry 1.5 just
yet. We are thinking about putting out the nested data support for
''preview'', soon, as well as some other enhancements to Spry.



I'm actually looking for real-world XML use cases, to run
through what I have implemented so far, so if you or anyone else
has nested XML samples/schemas they are trying to use with Spry and
are having trouble with it, I would *love* to see them.



In particular, I would like a sample XML/schema and the
output format/markup you are trying to produce. For example lots of
folks have nested data and are trying to convert that nested data
into a nice formatted list of lists.



If for some reason, you or anyone else is hesitant about
posting the URL to the XML etc on the forum, you can Private
Message me.



Thanks!



--== Kin ==--
Hey Matt,



I got your sample XML. I can't reply to you though ... You
have to set your forum preferences so that you can receive private
messages ... otherwise folks like me get denied whenever we try to
reply.



A screen shot, or even a sample of the markup you want to
generate would be great, so that I get an idea of if you are trying
to integrate the 2 nested data structures within the same region or
table.



--== Kin ==--
Ahh, sorry about that Kin. I fixed the preferences. Yes, I
will send you some code and a screenshot of what I'm looking to
duplicate.



Thanks, Matt

XML/LoadVars help

Hi. I need some help trying to load indivual strings of text
from an external file.

example:

I have a movie that navigates from frame to frame. on each
frame I'd like a line of text to load into the movie. When the user
navigates to the next frame the text loaded vanishes and is
replaced by another line of text. This can be done with separate
txt files, right but I was wondering if and how it could be done
using one external text file.

Thanks for any help.XML/LoadVars help
If you are using LoadVars you have all your variable data
pairs separated with the %26amp;. Ex:

%26amp;var1=Text%26amp;var2=Text for var2%26amp;var3=Text for var3



There can be no line returns in the file so you might need to
use word wrap when creating the static file.



Your LoadVars return object will then have each of the
variables and you can consume them as needed.

ex:

trace(myReturn_lv.var1)

trace(myReturn_lv.var2)XML/LoadVars help
Thanks I'll give it a shot.



G

currency converter

im am currently making a program in director as some kind
system that shows data and information on courties within europe. i
want to put a currency convertor in my system. i want it to go from
pounds to all the currencies in europe (or at least the main ones)
and then from the other currencies back to pounds. can any please
advice me how i would do this??? thansk very muchcurrency converter
Hi



Sounds like simple math/Lingo.



Set the float in your startMovie script



the floatPrecision = (? how many decimal places you want to
calc to)



Then do a calculation script.



on mouseDown



P = integer(member(''pounds').text)

D = float(P * (?D rate change))

E = float(P * (?E rate change))

...so on



member(''dollars'').text = string(D)

member(''euros'').text =string(E)

...so on



end



Try that!



Big Daddy

highlight

DataGridColumn labelFunction

I am using ActionScript to dynamically create DataGridColumns
to display in a DataGrid. So far, I've been able to create the
columns with the appropriate dataField and headerText properties.
When trying to assign a label function, my column code no longer
works. The statement that I'm using is the following:



myDataGridCols[i+1].labelFunction = ''dataGridNumberFormat'';



If I were to hard code the tag in MXML, I would set the
labelFunction=''dataGridNumberFormat''. Any advice is greatly
appreciated.

progressive download

Hi:

I'm new to video and could use some help. I'm not sure if
this is a server question or not. I'll post it in general also.
have a video clip which plays fine localy but when played from the
server (in progressive download mode) it starts and stops? I've
tried different buffer times without success. I started with
400kbps (i have dsl and I tested it at 700k) I also tried 150kbps
thinking slower data rate would not stop as much ---but it does the
same thing? I just had my boss check it, he has cable and it still
stops. I can't figure out whos turning off my stream? The website
host says its not them same with the isp. Anyone have any ideas how
I can figure out where the interuption is? (maybe its local
somehow).





Thanks very much



Mick

Re: Distribution

you cannot distribute Flash Lite 2.1.



you can create a cab file installer for your swf and other
assets. The end

user will need to install your cab file and the Flash LIte
2.1 player in

seperate steps.



You might ''tune in'' to Part 3: Creating your own installers
for the phone -

Weyert de Boer, which will cover how to make a .cab file.




http://www.adobe.com/cfusion/event/index.cfm?event=detail%26amp;id=546041%26amp;loc=en_us

Error Executing Database Query; Please...

I have been having trouble with getting this record to post
to my DB, I have the same form set up to edit an existing record,
as well as adding a new record. I get 2 errors, Can anyone help me
see what I am doing wrong? I am posting the code I am having
trouble with, and both errors. I am sorry, it is probably simple.
But I have been looking at this code too long and am missing the
problem.



The Code:

%26lt;cfelseif ParameterExists(Form.btnEdit_OK)%26gt;



%26lt;cfif ParameterExists(Form.RecordID)%26gt;

%26lt;cfset eDate = DateFormat(form.eventDate,
''mm/dd/yyyy'')%26gt;

%26lt;cfquery datasource=''#sitedatasource#''
username=''#siteUserID#'' password=''#sitePassword#'' dbtype=''ODBC''%26gt;

UPDATE SEEevents

SET SEEevents.display='#form.display#',
SEEevents.title='#form.title#', SEEevents.eventDate='#eDate#',
SEEevents.eventTime='#form.eventTime#',
SEEevents.location='#form.location#',
SEEevents.contact='#form.contact#', SEEevents.phone='#form.phone#',
SEEevents.fax='#form.fax#', SEEevents.email='#form.email#',
SEEevents.URL='#form.URL#', SEEevents.sponsor='#form.sponsor#',
SEEevents.Body='#form.PDSeditor#'

WHERE RecordID = #form.RecordID#

%26lt;/cfquery%26gt;

%26lt;cflocation
url=''events_RecordView.cfm?RecordID=#Form.RecordID#''%26gt;

%26lt;cfelse%26gt;

%26lt;cfset eDate = DateFormat(form.eventDate,
''mm/dd/yyyy'')%26gt;

%26lt;cfquery datasource=''#sitedatasource#''
username=''#siteUserID#'' password=''#sitePassword#'' dbtype=''ODBC''%26gt;

INSERT INTO SEEevents (display, title, eventDate, eventTime,
location, contact, phone, fax, email, URL, sponsor, Body)

VALUES ('#form.display#', '#form.title#', '###eDate###',
'#form.eventTime#', '#form.location#', '#form.contact#',
'#form.phone#', '#form.fax#', '#form.email#', '#form.URL#',
'#form.sponsor#', '#form.PDSeditor#')

%26lt;/cfquery%26gt;

%26lt;cflocation
url=''events_RecordView.cfm?RecordID=#GetNewRecord.ID_Field#''%26gt;

%26lt;/cfif%26gt;



Here are both errors:

error when editing an existing record:



Error Executing Database Query.

[Macromedia][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC Microsoft Access Driver] Too few
parameters. Expected 1.



The error occurred in
C:\websites\108392zj7\admin\events_RecordAction.cfm: line 70



68 : %26lt;cfif ParameterExists(Form.RecordID)%26gt;

69 : %26lt;cfset eDate = DateFormat(form.eventDate,
''mm/dd/yyyy'')%26gt;

70 : %26lt;cfquery datasource=''#sitedatasource#''
username=''#siteUserID#'' password=''#sitePassword#'' dbtype=''ODBC''%26gt;

71 : UPDATE SEEevents

72 : SET SEEevents.display='#form.display#',
SEEevents.title='#form.title#', SEEevents.eventDate='#eDate#',
SEEevents.eventTime='#form.eventTime#',
SEEevents.location='#form.location#',
SEEevents.contact='#form.contact#', SEEevents.phone='#form.phone#',
SEEevents.fax='#form.fax#', SEEevents.email='#form.email#',
SEEevents.URL='#form.URL#', SEEevents.sponsor='#form.sponsor#',
SEEevents.Body='#form.PDSeditor#'







--------------------------------------------------------------------------------



SQL UPDATE SEEevents SET SEEevents.display='0',
SEEevents.title='VIP Dinner', SEEevents.eventDate='04/13/2007',
SEEevents.eventTime='8:30pm - 11:00pm', SEEevents.location='person
Restaurant', SEEevents.contact='person', SEEevents.phone='(000)
000.6262', SEEevents.fax='', SEEevents.email='mail@person.com',
SEEevents.URL='
http://www.person.com',
SEEevents.sponsor='', SEEevents.Body=' %26lt;font size=''2''
face=''Verdana, Arial, Helvetica,
sans-serif''%26gt;%26lt;strong%26gt;Notes:%26lt;/strong%26gt; Reservations
must be confirmed with a major credit
card.%26lt;br%26gt;%26lt;strong%26gt;Price:%26lt;/strong%26gt; Advance: $125.
per person (includes gratuity and cocktail hour) At the door: $150.
per person %26lt;i%26gt; Limited seating
available%26lt;/i%26gt;%26lt;/font%26gt; ' WHERE RecordID = 13

DATASOURCE csee

VENDORERRORCODE -3010

SQLSTATE 07002



This is the error when posting a new record:



Error Executing Database Query.

[Macromedia][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC Microsoft Access Driver] Data type mismatch
in criteria expression.



The error occurred in
C:\websites\108392zj7\admin\events_RecordAction.cfm: line 78



76 : %26lt;cfelse%26gt;

77 : %26lt;cfset eDate = DateFormat(form.eventDate,
''mm/dd/yyyy'')%26gt;

78 : %26lt;cfquery datasource=''#sitedatasource#''
username=''#siteUserID#'' password=''#sitePassword#'' dbtype=''ODBC''%26gt;

79 : INSERT INTO SEEevents (display, title, eventDate,
eventTime, location, contact, phone, fax, email, URL, sponsor,
Body)

80 : VALUES ('#form.display#', '#form.title#', '###eDate###',
'#form.eventTime#', '#form.location#', '#form.contact#',
'#form.phone#', '#form.fax#', '#form.email#', '#form.URL#',
'#form.sponsor#', '#form.PDSeditor#')







--------------------------------------------------------------------------------



SQL INSERT INTO SEEevents (display, title, eventDate,
eventTime, location, contact, phone, fax, email, URL, sponsor,
Body) VALUES ('0', 'Testing', '#03/25/2007#', '12:47', 'Home',
'MJC', '000-000-0000', '', 'me@saratogaexpo.com',
'www.saratogaexpo.com', 'all of us', ' ')

DATASOURCE csee

VENDORERRORCODE -3030

SQLSTATE 22018



Can anyone help me tweek this code? I am seeing double at
this point. Thank you.



Phoenix



Error Executing Database Query; Please...
Why the triple ###'s around eDate? Notice it is attempting to
put #03/25/07# into a datetime field (at least I assume that's the
data type of the field you are inserting.



Let me know if that works.



I'm going to look at your update code right now.



- Mike

Error Executing Database Query; Please...
Why are you describing a dbtype of ''odbc'' in your cfquery
statement, by the way? That info is usually inferred within the
datasource setup in CF Admin. I could be wrong - does this work
successfully in other pages for you?



I never use dbtype if I have pointed to a datasource. Maybe
try that?



- Mike


In the UPDATE statement, all values are FORM scope except for
edate. Is that intended? The value for eventDate looks a little
wierd in your UPDATE and INSERT statements. What is the data type
in the database?
Yes it is date/time In the field of the db. I took out the 3
### around the eDate in the query, it still didn't accept it.



Is there a way to rewrite this statement and make it work
better? here is the error I get now from trying to update an
existing record:



Error Executing Database Query.

[Macromedia][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC Microsoft Access Driver] Too few
parameters. Expected 1.



The error occurred in
C:\websites\108392zj7\admin\events_RecordAction.cfm: line 70



68 : %26lt;cfif ParameterExists(Form.RecordID)%26gt;

69 : %26lt;cfset eDate = DateFormat(form.eventDate,
''mm/dd/yyyy'')%26gt;

70 : %26lt;cfquery datasource=''#sitedatasource#''
username=''#siteUserID#'' password=''#sitePassword#''%26gt;

71 : UPDATE SEEevents

72 : SET SEEevents.display='#form.display#',
SEEevents.title='#form.title#', SEEevents.eventDate='#eDate#',
SEEevents.eventTime='#form.eventTime#',
SEEevents.location='#form.location#',
SEEevents.contact='#form.contact#', SEEevents.phone='#form.phone#',
SEEevents.fax='#form.fax#', SEEevents.email='#form.email#',
SEEevents.URL='#form.URL#', SEEevents.sponsor='#form.sponsor#',
SEEevents.Body='#form.PDSeditor#'







--------------------------------------------------------------------------------



SQL UPDATE SEEevents SET SEEevents.display='0',
SEEevents.title='VIP Dinner', SEEevents.eventDate='04/13/2007',
SEEevents.eventTime='8:30pm - 11:00pm', SEEevents.location='person
Restaurant', SEEevents.contact='someplace', SEEevents.phone='(000)
000.6262', SEEevents.fax='', SEEevents.email='mail@person.com',
SEEevents.URL='
http://www.person.com',
SEEevents.sponsor='', SEEevents.Body=' %26lt;font size=''2''
face=''Verdana, Arial, Helvetica,
sans-serif''%26gt;%26lt;strong%26gt;Notes:%26lt;/strong%26gt; Reservations
must be confirmed with a major credit
card.%26lt;br%26gt;%26lt;strong%26gt;Price:%26lt;/strong%26gt; Advance: $125.
per person (includes gratuity and cocktail hour) At the door: $150.
per person %26lt;i%26gt; Limited seating
available%26lt;/i%26gt;%26lt;/font%26gt; ' WHERE RecordID = 13

DATASOURCE csee

VENDORERRORCODE -3010

SQLSTATE 07002





Again, been looking at this code too long. Thank you for the
help



Phoenix


Well, it looks like my advice on removeing the dbtype=ODBC
statement was wrong.



I didn't mean take all 3 out, :-), just keep it as '#eDate#',
since at this point it is a variable you set earlier.



Also, I might suggest posting this under the Database Forum,
I saw Dan Bracuk and several others around, they are much sharper
than me.



- Mike


You're
sure that eDate is not FORM scoped? eTime is.
ok, I will go to the DB forum. Thank you for your help.



Phoenix
Whoa! jdeline is responding - you're in luck.



Don't go anywhere just quite yet!




Someone made that cfset for me and were trying to use it. The
DB is an access DB and that spot in the table is set to accept
date/time. If there is a better way to write this expression, I am
all ears... and eyes.



Phoenix
I wanted to add, I also tried these other codes:



I changed SEEevents.eventDate='###eDate###' to:



SEEevents.eventDate=%26lt;cfqueryparam type='' CF_SQL_TIMESTAMP''
value=''#form.eventDate#''%26gt;

and

SEEevents.eventDate=%26lt;cfqueryparam type='' CF_SQL_DATE''
value=''#form.eventDate#''%26gt;

and

SEEevents.eventDate=#CREATEODBCDATE(form.eventDate)#



Now with the code:

SEEevents.eventDate=#CREATEODBCDATE(form.eventDate)#



this is the error I get:

Error Executing Database Query.

[Macromedia][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error
(missing operator) in query expression ''{d '2007-04-13'}''.



The error occurred in
C:\websites\108392zj7\admin\events_RecordAction.cfm: line 69



67 :

68 : %26lt;cfif ParameterExists(Form.RecordID)%26gt;

69 : %26lt;cfquery datasource=''#sitedatasource#''
username=''#siteUserID#'' password=''#sitePassword#'' dbtype=''ODBC''%26gt;

70 : UPDATE SEEevents

71 : SET SEEevents.display='#form.display#',
SEEevents.title='#form.title#',
SEEevents.eventDate='#CREATEODBCDATE(form.eventDate)#',
SEEevents.eventTime='#form.eventTime#',
SEEevents.location='#form.location#',
SEEevents.contact='#form.contact#', SEEevents.phone='#form.phone#',
SEEevents.fax='#form.fax#', SEEevents.email='#form.email#',
SEEevents.URL='#form.URL#', SEEevents.sponsor='#form.sponsor#',
SEEevents.Body='#form.PDSeditor#'







--------------------------------------------------------------------------------



SQL UPDATE SEEevents SET SEEevents.display='0',
SEEevents.title='VIP Dinner', SEEevents.eventDate='{d
'2007-04-13'}', SEEevents.eventTime='8:30pm - 11:00pm',
SEEevents.location='person Restaurant',
SEEevents.contact='person''s', SEEevents.phone='(000) 000.6262',
SEEevents.fax='', SEEevents.email='mail@person.com',
SEEevents.URL='
http://www.person.com',
SEEevents.sponsor='', SEEevents.Body=' %26lt;font size=''2''
face=''Verdana, Arial, Helvetica,
sans-serif''%26gt;%26lt;strong%26gt;Notes:%26lt;/strong%26gt; Reservations
must be confirmed with a major credit
card.%26lt;br%26gt;%26lt;strong%26gt;Price:%26lt;/strong%26gt; Advance: $125.
per person (includes gratuity and cocktail hour) At the door: $150.
per person %26lt;i%26gt; Limited seating
available%26lt;/i%26gt;%26lt;/font%26gt; ' WHERE RecordID = 13

DATASOURCE csee

VENDORERRORCODE -3100

SQLSTATE 42000



What the hack am I missing?

I am kind of new to this adding time/date to a db.

Anyone have a solution that might work. I need to get this
fixed today so records can be modified. Sorry for teh persistance.



Phoenix
I wanted to add, I also tried these other codes:



I changed SEEevents.eventDate='###eDate###' to:



SEEevents.eventDate=%26lt;cfqueryparam type='' CF_SQL_TIMESTAMP''
value=''#form.eventDate#''%26gt;

and

SEEevents.eventDate=%26lt;cfqueryparam type='' CF_SQL_DATE''
value=''#form.eventDate#''%26gt;

and

SEEevents.eventDate=#CREATEODBCDATE(form.eventDate)#



Now with the code:

SEEevents.eventDate=#CREATEODBCDATE(form.eventDate)#



this is the error I get:

Error Executing Database Query.

[Macromedia][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error
(missing operator) in query expression ''{d '2007-04-13'}''.



The error occurred in
C:\websites\108392zj7\admin\events_RecordAction.cfm: line 69



67 :

68 : %26lt;cfif ParameterExists(Form.RecordID)%26gt;

69 : %26lt;cfquery datasource=''#sitedatasource#''
username=''#siteUserID#'' password=''#sitePassword#'' dbtype=''ODBC''%26gt;

70 : UPDATE SEEevents

71 : SET SEEevents.display='#form.display#',
SEEevents.title='#form.title#',
SEEevents.eventDate='#CREATEODBCDATE(form.eventDate)#',
SEEevents.eventTime='#form.eventTime#',
SEEevents.location='#form.location#',
SEEevents.contact='#form.contact#', SEEevents.phone='#form.phone#',
SEEevents.fax='#form.fax#', SEEevents.email='#form.email#',
SEEevents.URL='#form.URL#', SEEevents.sponsor='#form.sponsor#',
SEEevents.Body='#form.PDSeditor#'







--------------------------------------------------------------------------------



SQL UPDATE SEEevents SET SEEevents.display='0',
SEEevents.title='VIP Dinner', SEEevents.eventDate='{d
'2007-04-13'}', SEEevents.eventTime='8:30pm - 11:00pm',
SEEevents.location='person Restaurant',
SEEevents.contact='person''s', SEEevents.phone='(000) 000.6262',
SEEevents.fax='', SEEevents.email='mail@person.com',
SEEevents.URL='
http://www.person.com',
SEEevents.sponsor='', SEEevents.Body=' %26lt;font size=''2''
face=''Verdana, Arial, Helvetica,
sans-serif''%26gt;%26lt;strong%26gt;Notes:%26lt;/strong%26gt; Reservations
must be confirmed with a major credit
card.%26lt;br%26gt;%26lt;strong%26gt;Price:%26lt;/strong%26gt; Advance: $125.
per person (includes gratuity and cocktail hour) At the door: $150.
per person %26lt;i%26gt; Limited seating
available%26lt;/i%26gt;%26lt;/font%26gt; ' WHERE RecordID = 13

DATASOURCE csee

VENDORERRORCODE -3100

SQLSTATE 42000



What the hack am I missing?

I am kind of new to this adding time/date to a db.

Anyone have a solution that might work. I need to get this
fixed today so records can be modified. Sorry for the persistance.



Phoenix
Phoenix,



I'll just post what it is that I do in this situation, and
maybe your can ''translate it'', since there are a few differences,
primarily that I use SQL. (Windows 2003 Server, IIS, CF MX 6.1).



For date/time ''stuff'':



%26lt;cfset todaysdate = #DateFormat(Now(),''mm/dd/yy'')#%26gt;

OR to have the time with it

%26lt;cfset todaystime = #DateFormat(Now())# %26amp; '' '' %26amp;
#TimeFormat(Now())#%26gt;



The above I use to set the default for the field on the form
that correspond, to say ''Field1'' and ''Field2''.



Then, I use ''cfupdate'' to do my updates, although I will
mention that Dan Bracuk, one of the VERY senior members, recommends
your method.



If, of course, I use cfupdate, I have to include my keyfield
first, and do this:



%26lt;cfif IsDefined(''Form.myvariable'') AND Form.myvariable GT
whatevernumberorcriteria%26gt;

%26lt;cfupdate datasource=''mydatasource'' tablename=''mytable''
formfields=''MyPrimaryKey,Field1,Field2''%26gt;

%26lt;/cfif%26gt;



Anyway, give it a translation try, and I will try to keep
checking to see how it's going.



- Mike
Phoenix,



I will re-check posts after 7:30pm. Hope all is well!



- Mike


Ok, I tried it with all the ways you posted. Still getting a
missing operator error. (why is this such a pain?)

Here is my error:

Error Executing Database Query.

[Macromedia][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error
(missing operator) in query expression ''{d '2007-04-13'}''.



The error occurred in
C:\websites\108392zj7\admin\events_RecordAction.cfm: line 70



68 : %26lt;cfif ParameterExists(Form.RecordID)%26gt;

69 : %26lt;cfset EventDate = #DateFormat(Now(),''mm/dd/yy'')#%26gt;

70 : %26lt;cfquery datasource=''#sitedatasource#''
username=''#siteUserID#'' password=''#sitePassword#'' dbtype=''ODBC''%26gt;

71 : UPDATE SEEevents

72 : SET SEEevents.display='#form.display#',
SEEevents.title='#form.title#',
SEEevents.eventDate='#CREATEODBCDATE(form.eventDate)#',
SEEevents.eventTime='#form.eventTime#',
SEEevents.location='#form.location#',
SEEevents.contact='#form.contact#', SEEevents.phone='#form.phone#',
SEEevents.fax='#form.fax#', SEEevents.email='#form.email#',
SEEevents.URL='#form.URL#', SEEevents.sponsor='#form.sponsor#',
SEEevents.Body='#form.PDSeditor#'







--------------------------------------------------------------------------------



SQL UPDATE SEEevents SET SEEevents.display='0',
SEEevents.title='VIP Dinner', SEEevents.eventDate='{d
'2007-04-13'}', SEEevents.eventTime='8:30pm - 11:00pm',
SEEevents.location='Brindisi''s Restaurant',
SEEevents.contact='Brindisi''s', SEEevents.phone='(518) 587.6262',
SEEevents.fax='', SEEevents.email='mail@brindisis.com',
SEEevents.URL='
http://www.brindisis.com',
SEEevents.sponsor='', SEEevents.Body=' %26lt;font size=''2''
face=''Verdana, Arial, Helvetica,
sans-serif''%26gt;%26lt;strong%26gt;Notes:%26lt;/strong%26gt; Reservations
must be confirmed with a major credit
card.%26lt;br%26gt;%26lt;strong%26gt;Price:%26lt;/strong%26gt; Advance: $125.
per person (includes gratuity and cocktail hour) At the door: $150.
per person %26lt;i%26gt; Limited seating
available%26lt;/i%26gt;%26lt;/font%26gt; ' WHERE RecordID = 13

DATASOURCE csee

VENDORERRORCODE -3100

SQLSTATE 42000



Resources:



This is the code I am using now:



%26lt;cfelseif ParameterExists(Form.btnEdit_OK)%26gt;



%26lt;cfif ParameterExists(Form.RecordID)%26gt;

%26lt;cfset eventDate = #DateFormat(Now(),''mm/dd/yy'')#%26gt;

%26lt;cfquery datasource=''#sitedatasource#''
username=''#siteUserID#'' password=''#sitePassword#'' dbtype=''ODBC''%26gt;

UPDATE SEEevents

SET SEEevents.display='#form.display#',
SEEevents.title='#form.title#',
SEEevents.eventDate='#CREATEODBCDATE(form.eventDate)#',
SEEevents.eventTime='#form.eventTime#',
SEEevents.location='#form.location#',
SEEevents.contact='#form.contact#', SEEevents.phone='#form.phone#',
SEEevents.fax='#form.fax#', SEEevents.email='#form.email#',
SEEevents.URL='#form.URL#', SEEevents.sponsor='#form.sponsor#',
SEEevents.Body='#form.PDSeditor#'

WHERE RecordID = #form.RecordID#

%26lt;/cfquery%26gt;

%26lt;cflocation
url=''events_RecordView.cfm?RecordID=#Form.RecordID#''%26gt;

%26lt;cfelse%26gt;

%26lt;cfset eDate = DateFormat(form.eventDate,
''mm/dd/yyyy'')%26gt;

%26lt;cfquery datasource=''#sitedatasource#''
username=''#siteUserID#'' password=''#sitePassword#'' dbtype=''ODBC''%26gt;

INSERT INTO SEEevents (display, title, eventDate, eventTime,
location, contact, phone, fax, email, URL, sponsor, Body)

VALUES ('#form.display#', '#form.title#', '#eDate#',
'#form.eventTime#', '#form.location#', '#form.contact#',
'#form.phone#', '#form.fax#', '#form.email#', '#form.URL#',
'#form.sponsor#', '#form.PDSeditor#')

%26lt;/cfquery%26gt;

%26lt;cflocation
url=''events_RecordView.cfm?RecordID=#GetNewRecord.ID_Field#''%26gt;

%26lt;/cfif%26gt;



I tried the 2 types of cfset:



%26lt;cfset todaysdate = #DateFormat(Now(),''mm/dd/yy'')#%26gt;

and now I have it as:

%26lt;cfset eventDate = #DateFormat(Now(),''mm/dd/yy'')#%26gt;



Neither way is working. I am totally confused at this point.



Phoenix