Update

[alexz]

I'm trying to update my database fields
Employee, Status and Location with values from a form.
Is this going to work?

Dim strEmployee, strStatus, strLocation

strEmployee= request.form("Employee")
strStatus = Request.Form("Status")
strLocation = Request.Form("Location")

SQLstmt = "UPDATE Table SET "

SQLstmt = SQLstmt & "RS("Employee")= strEmployee"
SQLstmt = SQLstmt & "RS("Status")= strStatus"
SQLstmt = SQLstmt & "RS("Location")= strLocation"

[Ray at]

No, try this:

strEmployee= request.form("Employee")
strStatus = Request.Form("Status")
strLocation = Request.Form("Location")

SQLstmt = "UPDATE Table SET [Employee]='" & strEmployee & "',[Status]='" &
strStatus & "',[Location]='" & strLocation & "'"

That statement will update EVERY record though if you don't have a WHERE
clause, i.e. WHERE [EmployeedID]=6.

Ray at work


"alexz" <alexz33@hotmail.com> wrote in message
news:43d72b53.0307170855.1221c25f@posting.google.c om...

> I'm trying to update my database fields
> Employee, Status and Location with values from a form.
> Is this going to work?
>
> Dim strEmployee, strStatus, strLocation
>
> strEmployee= request.form("Employee")
> strStatus = Request.Form("Status")
> strLocation = Request.Form("Location")
>
> SQLstmt = "UPDATE Table SET "
>
> SQLstmt = SQLstmt & "RS("Employee")= strEmployee"
> SQLstmt = SQLstmt & "RS("Status")= strStatus"
> SQLstmt = SQLstmt & "RS("Location")= strLocation"

[TurkBear]

On 17 Jul 2003 09:55:27 -0700, [email]alexz33@hotmail.com[/email] (alexz) wrote:

>I'm trying to update my database fields
>Employee, Status and Location with values from a form.
>Is this going to work?
>
>Dim strEmployee, strStatus, strLocation
>
>strEmployee= request.form("Employee")
>strStatus = Request.Form("Status")
>strLocation = Request.Form("Location")
>
>SQLstmt = "UPDATE Table SET "
>
>SQLstmt = SQLstmt & "RS("Employee")= strEmployee"
>SQLstmt = SQLstmt & "RS("Status")= strStatus"
>SQLstmt = SQLstmt & "RS("Location")= strLocation"

It appears that you are not telling the database table which records to update ---So it may update all your existing
records
You may want to add something like

SQLstmt = SQLstmt & " Where some_field_in_the_table = some_field_to_identify_which_record_get_this_updat e"

( I am not sure what the RS refers to, since I do not see any Recordset )

[alexz]

TurkBear <noone@nowhere.com> wrote in message news:<skmdhvg2hosm1oso21jr0265sdb4u35ft5@4ax.com>. ..

> On 17 Jul 2003 09:55:27 -0700, [email]alexz33@hotmail.com[/email] (alexz) wrote:
>

> >I'm trying to update my database fields
> >Employee, Status and Location with values from a form.
> >Is this going to work?
> >
> >Dim strEmployee, strStatus, strLocation
> >
> >strEmployee= request.form("Employee")
> >strStatus = Request.Form("Status")
> >strLocation = Request.Form("Location")
> >
> >SQLstmt = "UPDATE Table SET "
> >
> >SQLstmt = SQLstmt & "RS("Employee")= strEmployee"
> >SQLstmt = SQLstmt & "RS("Status")= strStatus"
> >SQLstmt = SQLstmt & "RS("Location")= strLocation"

>
> It appears that you are not telling the database table which records to update ---So it may update all your existing
> records
> You may want to add something like
>
> SQLstmt = SQLstmt & " Where some_field_in_the_table = some_field_to_identify_which_record_get_this_updat e"
>
> ( I am not sure what the RS refers to, since I do not see any Recordset )

Thanks, Got it working.

[Rob Dillon]

If this is for SW, there's no intermovie communication, nor do global
variables allow you to hold a value. Use setPref and getPref to hold a
value and then have the other movie retreive it. Look at the example in
the Lingo Dictionary.

--
Rob
_______
Rob Dillon
Team Macromedia
[url]http://www.ddg-designs.com[/url]
412-243-9119

[url]http://www.macromedia.com/software/trial/[/url]

[Jota Mix]

But i´m using this segments, but this broke!!!!!

I think be memory cache or buffer....

how do I Clean ??


"Rob Dillon" <rob@ddg-designs.com> escreveu na mensagem
news:080920031547530387%rob@ddg-designs.com...

> If this is for SW, there's no intermovie communication, nor do global
> variables allow you to hold a value. Use setPref and getPref to hold a
> value and then have the other movie retreive it. Look at the example in
> the Lingo Dictionary.
>
> --
> Rob
> _______
> Rob Dillon
> Team Macromedia
> [url]http://www.ddg-designs.com[/url]
> 412-243-9119
>
> [url]http://www.macromedia.com/software/trial/[/url]

[Rob Dillon]

SetPref and getPref don't use the cache, the file is actually written
the user's hard drive in a folder in the same location as the plugin.

It should always work, even if you don't have write permission.

In what way do you think that this is broken?

--
Rob
_______
Rob Dillon
Team Macromedia
[url]http://www.ddg-designs.com[/url]
412-243-9119

[url]http://www.macromedia.com/software/trial/[/url]

[Jota Mix]

I don´t know what is hapened!!!

I´m making a program that save a record in 3 members, and this members (
external cast ) will be opened another movie, bur it isn´t updating... the
records be old records.... sorry my english, I´m brasilian, i don´t know if
you understand me.... do you understand????


tks...
"Rob Dillon" <rob@ddg-designs.com> escreveu na mensagem
news:090920030805304939%rob@ddg-designs.com...

> SetPref and getPref don't use the cache, the file is actually written
> the user's hard drive in a folder in the same location as the plugin.
>
> It should always work, even if you don't have write permission.
>
> In what way do you think that this is broken?
>
> --
> Rob
> _______
> Rob Dillon
> Team Macromedia
> [url]http://www.ddg-designs.com[/url]
> 412-243-9119
>
> [url]http://www.macromedia.com/software/trial/[/url]

[Rob Dillon]

If this is a Shockwave movie, then you can't use save castLib to update
members. The cast that you would be updating would be the local one in
your cache, and that would only benefit you. Save castLib can't reach
back out to the server and save a new version, that's disabled.

Depending on the content for these members, you may be able to use one
of the SW exporting Xtras to save your new members out to a server. If
it's just text that you want to save, then you can use setPref and
getPref to hold that content. Again, that's a local thing and so it
will only effect your movie, not the content on the server.

--
Rob
_______
Rob Dillon
Team Macromedia
[url]http://www.ddg-designs.com[/url]
412-243-9119

[url]http://www.macromedia.com/software/trial/[/url]

[Jota Mix]

Ok, i´m using setpref and getpref, but the datas don´t change!!!!

it isn´t a shockwave....


"Rob Dillon" <rob@ddg-designs.com> escreveu na mensagem
news:090920030912386769%rob@ddg-designs.com...

> If this is a Shockwave movie, then you can't use save castLib to update
> members. The cast that you would be updating would be the local one in
> your cache, and that would only benefit you. Save castLib can't reach
> back out to the server and save a new version, that's disabled.
>
> Depending on the content for these members, you may be able to use one
> of the SW exporting Xtras to save your new members out to a server. If
> it's just text that you want to save, then you can use setPref and
> getPref to hold that content. Again, that's a local thing and so it
> will only effect your movie, not the content on the server.
>
> --
> Rob
> _______
> Rob Dillon
> Team Macromedia
> [url]http://www.ddg-designs.com[/url]
> 412-243-9119
>
> [url]http://www.macromedia.com/software/trial/[/url]

[Rob Dillon]

OK, now I'm completely confused.

If you want to hold data from one Director movie to the next in the
same session, then you can use a global variable. If you're not working
with Shockwave then don't use setPref and getPref. While it works well
with Shockwave, there are restrictions on using it with a projector.

Look in the Lingo Dictionary and the Learning Example movies for more
on these commands.

Back to the problem at hand. If you are changing the content of a
member in movie A, are you using that member in movie B in the same
Director session? In other words are you going directly from movie A to
movie B, or are you quiting the projector and then starting it again
before you go to movie B?

If you open movie A, change a member in the external shared cast, and
then go to movie B, the change should show up in that member in movie
B.

If you open movie A, change a member in the external shared cast, and
then quit the movie. Open movie B, the changed member will not show the
change, because it wasn't saved before you quit the first movie.

If you are quiting the first movie, then you need to use save castLib
to save that change. If you are running from a CD then you will have to
save the castLib to the user's hard drive. Then you will need to search
for that cast when you start up again and link the version saved to the
user's drive to your movie.

--
Rob
_______
Rob Dillon
Team Macromedia
[url]http://www.ddg-designs.com[/url]
412-243-9119

[url]http://www.macromedia.com/software/trial/[/url]

[Jota Mix]

tks Rob...

my problem was that when I come the movie B, it doesn´t make a update in the
movie, it opened the movie B on final frame, so doesn´t make the lingo
programation!!!

so, if for there and another if´s... it´s ok now!!!!


thanks for help!!!!

if you want, I send the final project for you see... if you want, give me
your personal email!!!!

tks!!!!



"Rob Dillon" <rob@ddg-designs.com> escreveu na mensagem
news:090920031008213980%rob@ddg-designs.com...

> OK, now I'm completely confused.
>
> If you want to hold data from one Director movie to the next in the
> same session, then you can use a global variable. If you're not working
> with Shockwave then don't use setPref and getPref. While it works well
> with Shockwave, there are restrictions on using it with a projector.
>
> Look in the Lingo Dictionary and the Learning Example movies for more
> on these commands.
>
> Back to the problem at hand. If you are changing the content of a
> member in movie A, are you using that member in movie B in the same
> Director session? In other words are you going directly from movie A to
> movie B, or are you quiting the projector and then starting it again
> before you go to movie B?
>
> If you open movie A, change a member in the external shared cast, and
> then go to movie B, the change should show up in that member in movie
> B.
>
> If you open movie A, change a member in the external shared cast, and
> then quit the movie. Open movie B, the changed member will not show the
> change, because it wasn't saved before you quit the first movie.
>
> If you are quiting the first movie, then you need to use save castLib
> to save that change. If you are running from a CD then you will have to
> save the castLib to the user's hard drive. Then you will need to search
> for that cast when you start up again and link the version saved to the
> user's drive to your movie.
>
> --
> Rob
> _______
> Rob Dillon
> Team Macromedia
> [url]http://www.ddg-designs.com[/url]
> 412-243-9119
>
> [url]http://www.macromedia.com/software/trial/[/url]

[Abdlah]

:confused; I am retrieving data from the database and altering some information
but I get an error which does not make sense because the line indicati ng the
error is properly compiled. Please help

My code is attached:

form code
<!--- Check that FilmID was provided --->
<cfif NOT IsDefined("URL.FilmID")>
<h1>You did not specify the FilmID</h1>
<cfabort>
</cfif>

<!--- Get the film record --->
<cfquery datasource="ows" name="film">
SELECT FilmID, MovieTitle, PitchText,
AmountBudgeted, RatingID,
Summary, ImageName, DateInTheaters
FROM Films
WHERE FilmID=#URL.FilmID#
</cfquery>

<!--- Get Ratings --->
<cfquery datasource="ows" name="ratings">
SELECT RatingID, Rating
FROM FilmsRatings
ORDER BY RatingID
</cfquery>

<!--- Page header --->
<cfinclude template="../9/ows_header.cfm">

<!--- Update movie form --->
<CFFORM ACTION="update2.cfm">

<!--- Embed primary key as a hidden field --->
<cfoutput>
<input type="hidden" name="FilmID" value="#Film.FilmID#">
</cfoutput>

<TABLE ALIGN="center" BGCOLOR="orange">
<TR>
<TH COLSPAN="2">
<FONT SIZE="+1">Update a Movie</FONT>
</TH>
</TR>
<TR>
<TD>
Movie:
</TD>
<TD>
<CFINPUT TYPE="Text"
NAME="MovieTitle"
VALUE="#Trim(film.MovieTitle)#"
MESSAGE="MOVIE TITLE is required!"
REQUIRED="Yes"
SIZE="50"
MAXLENGTH="100">
</TD>
</TR>
<TR>
<TD>
Tag line:
</TD>
<TD>
<CFINPUT TYPE="Text"
NAME="PitchText"
VALUE="#Trim(film.PitchText)#"
MESSAGE="TAG LINE is required"
REQUIRED="Yes"
SIZE="50"
MAXLENGTH="100">
</TD>
</TR>
<TR>
<TD>
Rating:
</TD>
<TD>
<!--- Ratings list --->
<SELECT NAME="RatingID">
<CFOUTPUT QUERY="ratings">
<OPTION VALUE="#RatingID#">#Rating# <cfif ratings.RatingID
IS
film.RatingID>SELECTED</cfif>#Rating#</OPTION>
</CFOUTPUT>
</SELECT>
</TD>
</TR>
<TR>
<TD>
Summary:
</TD>
<TD>
<cfoutput>
<TEXTAREA NAME="summary"
COLS="40"
ROWS="5"
WRAP="virtual">#Trim(Film.Summary)#</TEXTAREA>
</cfoutput>
</TD>
</TR>
<TR>
<TD>
Budget:
</TD>
<TD>
<CFINPUT TYPE="Text"
NAME="AmountBudgeted"
VALUE="#Int(film.AmountBudgeted)#"
MESSAGE="BUDGET must be a valid numeric Amount!"
VALIDATE="integer"
REQUIRED="NO"
SIZE="10"
MAXLENGTH="10">
</TD>
</TR>
<TR>
<TD>
Release Date:
</TD>
<TD>
<CFINPUT TYPE="Text"
NAME="DateInTheaters"
VALUE="#DateFormat(film.DateInTheaters, "MM/DD/YYYY")#"
MESSAGE="RELEASE DATE must be a valid date!"
VALIDATE="date"
REQUIRED="NO"
SIZE="10"
MAXLENGTH="10">
</TD>
</TR>
<TR>
<TD>
Image File:
</TD>
<TD>
<CFINPUT TYPE="Text"
NAME="ImageName"
VALUE="#Trim(film.ImageName)#"
REQUIRED="NO"
SIZE="20"
MAXLENGTH="50">
</TD>
</TR>
<TR>
<TD COLSPAN="2" ALIGN="center">
<INPUT TYPE="submit" VALUE="Update">
</TD>
</TR>
</TABLE>

</CFFORM>

<!--- Page footer --->
<CFINCLUDE TEMPLATE="../9/ows_footer.cfm">

&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&& &&&&&&&&&&&&&&&&&&&&&&&&&&&&


Processing page

<!--- Update movie --->
<cfquery datasource="ows">
Update Films
SET MovieTitle='#Trim(FORM.MovieTitle)#',
PitchText='#Trim(FORM.PitchText)#',
AmountBudgeted='#Trim(FORM.AmountBudgeted)#',
RatingID=#Trim(FORM.RatingID)#,
Summary='#Trim(FORM.Summary)#',
ImageName='#Trim(FORM.ImageName)#',
DateInTheaters=#CreateODBCDate(FORM.DateInTheaters )#
WHERE FilmID=#FORM.FilmID#
</cfquery>

<!--- Page header --->
<cfinclude template="../9/ows_header.cfm">

<!--- Feedback --->
<cfoutput>
<h1>New movie #FORM.MovieTitle# updated</h1>
</cfoutput>

<!--- Page footer --->
<cfinclude template="../9/ows_footer.cfm">

@@@@@@@@@@@@@@@ ERROR MESSAGE @@@@@@@@@@@@@@@@@@@@@@@@@@@@@

Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Operation must use an updateable query.

The error occurred in D:\StudioMX2004\ColdFusion\wwwroot\ows\13\update2. cfm:
line 18

16 : ImageName='#Trim(FORM.ImageName)#',
17 : DateInTheaters=#CreateODBCDate(FORM.DateInTheaters )#
18 : WHERE FilmID=#FORM.FilmID#
19 : </cfquery>
20 :




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

SQL Update Films SET MovieTitle='Closet Encounters of the Odd Kind',
PitchText='Some things should remain in the closet', AmountBudgeted='350001',
RatingID=1, Summary='One man find out more than he ever wanted to know about
the skeletons in his closet - and not just figuratively either.',
ImageName='f3.gif', DateInTheaters={d '2000-11-07'} WHERE FilmID=3
DATASOURCE ows
VENDORERRORCODE -3035
SQLSTATE HY000

[Tulsa]

<cfquery datasource="ows">

Not sure if this is causing the error, but according to MM docs, all querys must have the required "name" attribute. Try naming your query and see if that works.

[byron1021]

yeah i think that's the case with access update queries. You don't need a name for MS SQL queries when updating.

[LRS]

<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft DHTML Editing Control">
<TITLE></TITLE>
</HEAD>
<BODY>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><B
style="mso-bidi-font-weight: normal"><SPAN style="FONT-SIZE: 14pt">SFNN- - - POWERFUL HIDDEN BOTTOM
PLAY!!!<o:p></O:P></SPAN></B></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><B><SPAN
style="FONT-SIZE: 14pt; COLOR: black">CURRENT PRICE=
..003<o:p></O:P></SPAN></B></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><B><SPAN
style="FONT-SIZE: 14pt; COLOR: black">TARGET PRICE = 15 CENTS<SPAN
style="mso-spacerun: yes">&nbsp; </SPAN><o:p></O:P></SPAN></B></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><B><SPAN
style="FONT-SIZE: 14pt; COLOR: black">TARGET HOLD TIME = 9
MONTHS<o:p></O:P></SPAN></B></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><B
style="mso-bidi-font-weight: normal"><SPAN style="FONT-SIZE: 14pt">ESTIMATED
ROI= 4500%<o:p></O:P></SPAN></B></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><B
style="mso-bidi-font-weight: no