navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
FrontPage Alternative
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

 

problem with updating a record with DRW

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP and Database >> problem with updating a record with DRW 		Page: [1]
 
marabe

 

Posts: 32
Joined: 2/26/2004
Status: offline

  		problem with updating a record with DRW - 3/24/2004 8:32:01   
Hi,

I have a review site on, www.en.se.

On a page the members will be able to change their reviews, but I have a problem with the page.

http://www.en.se/upload/book/test1.asp

I get "Database Results Wizard Error" and their is no way of updating the record.
The custom query is,

UPDATE Results
SET
Recension='::Recension::'
WHERE Key= ::Key::

Any ideas??

Best, Martin
BeTheBall

 

Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: problem with updating a record with DRW - 3/24/2004 12:14:22   
http://www.frontpagewebmaster.com/m-175524/tm.htm

_____________________________

Duane

Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.

(in reply to marabe)
marabe

 

Posts: 32
Joined: 2/26/2004
Status: offline

  		RE: problem with updating a record with DRW - 3/24/2004 14:59:58   
ok,

The problem seems to be that the database region don't contain any records. And it don't because when I write the custom query it's not possible to edit the list because it's all blank.

Best, Martin

(in reply to marabe)
Spooky

 

Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: problem with updating a record with DRW - 3/24/2004 17:20:12   
Yes, it might pay to add some records to update ;-)

Or is it blank for some other reason?

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to marabe)
BeTheBall

 

Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: problem with updating a record with DRW - 3/24/2004 17:55:43   
WIthout seeing your code, this is just a guess, but it looks like you are trying to host your update form and your update SQL on the same page. This is creating a problem because the SQL is trying to execute before the form is even submitted. Generally, one has a form on one page and then the form submits to a second page whereon sits the UPDATE statement. Having said that, it also looks like you have some FP 2003 issues going on. :)

_____________________________

Duane

Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.

(in reply to Spooky)
marabe

 

Posts: 32
Joined: 2/26/2004
Status: offline

  		RE: problem with updating a record with DRW - 3/25/2004 5:37:33   
Yes, but still, when I fill in the custom query, "edit list" i step three is blank and it's not possible to put in a record.

When the custom query is done on the update page that sends the change to the database, it doesn't seem to include the field names and attributes in the database region of the page.

I read somewhere that MS refer to using .Net technology, but there must be a easier solution. I've read the tutorials and MS documentation thoroughly

I also saw this,
http://www.frontpagetalk.com/forums/m.asp?m=53118&mpage=1&p=1&tmode=1&smode=1&key=

http://www.en.se/upload/book/test1.asp

// Martin

(in reply to marabe)
BeTheBall

 

Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: problem with updating a record with DRW - 3/25/2004 12:36:14   
Having visited your page, it looks like you are making progress. You were correct to move the Custom DRW to a third page. Now post the code for Update.asp and we may be able to help you fix the current error as it is a FP 2003 issue. Also, you should not need to pass the value for Recension in your query string. That makes for one long URL. If you simply pass the ID you can then use the DRW to populate your Form.

_____________________________

Duane

Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.

(in reply to marabe)
marabe

 

Posts: 32
Joined: 2/26/2004
Status: offline

  		RE: problem with updating a record with DRW - 3/26/2004 3:43:55   
ok, here's the code

Best, Martin

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


<table width="100%" border="1" class="books">
<thead>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart" s-columnnames="Recension,Key" s-columntypes="203,203" s-dataconnection="Real_Book" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource s-displaycolumns s-criteria s-order s-sql="UPDATE Results<br>SET Recension='::Recension::'<br>WHERE Key=::Key:: <br>" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="Recension=&Key=" s-norecordsfound="No records returned." i-maxrecords="256" i-groupsize="5" botid="0" u-dblib="../_fpclass/fpdblib.inc" u-dbrgn1="../_fpclass/fpdbrgn1.inc" u-dbrgn2="../_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the start of a Database Results region.</font></td></tr>" startspan --><!--#include file="../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="UPDATE Results SET Recension='::Recension::' WHERE Key=::Key:: "
fp_sDefault="Recension=&Key="
fp_sNoRecords="<tr><td colspan=16 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="Real_Book"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Recension=203&Key=203&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="43139" --><!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="5" clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr><TR><TD VALIGN=MIDDLE COLSPAN=64><NOBR><INPUT TYPE=Button VALUE=" |< "><INPUT TYPE=Button VALUE=" < "><INPUT TYPE=Button VALUE=" > "><INPUT TYPE=Button VALUE=" >| "> [1/5]</NOBR><BR></td></tr>" startspan --><!--#include file="../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="56926" --></tbody>
</table>
<p> <p><br>
<p> </td>
</tr>
</table>

(in reply to marabe)
BeTheBall

 

Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: problem with updating a record with DRW - 3/26/2004 10:41:21   
Not sure if this is the only problem, but Key is a reserved word. Try going into your SQL and changing:

UPDATE Results SET Recension='::Recension::' WHERE Key=::Key::

to

UPDATE Results SET Recension='::Recension::' WHERE [Key]=::Key::

_____________________________

Duane

Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.

(in reply to marabe)
marabe

 

Posts: 32
Joined: 2/26/2004
Status: offline

  		RE: problem with updating a record with DRW - 3/26/2004 12:35:40   
no, didn't solve the problem

// Marabe

(in reply to marabe)
Spooky

 

Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: problem with updating a record with DRW - 3/26/2004 15:31:16   
Key isnt numeric??

Key=203 <- Thats a text field

UPDATE Results SET Recension='::Recension::' WHERE [Key]='::Key::'

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to marabe)
marabe

 

Posts: 32
Joined: 2/26/2004
Status: offline

  		RE: problem with updating a record with DRW - 3/26/2004 16:07:55   
No, didn't work either. I appreciate your help

// Marabe

(in reply to marabe)
BeTheBall

 

Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: problem with updating a record with DRW - 3/26/2004 17:35:53   
What if you use the SQL I provided, namely,

fp_sQry="UPDATE Results SET Recension='::Recension::' WHERE [Key]=::Key::"

But also use the FP 2000 includes, instead of the FP 2003 includes? The includes are in the attachment in the second post from Spooky in this topic:

http://www.frontpagewebmaster.com/m-182839/tm.htm

You may want to save copies of the ones currently in the _fpclass folder and then place these in there and see if your page works.

_____________________________

Duane

Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.

(in reply to marabe)
BeTheBall

 

Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

  		RE: problem with updating a record with DRW - 3/26/2004 18:53:16   
If your host supports ASP.NET, follow the instructions in the article referenced in the error message you are receiving.

http://support.microsoft.com/default.aspx?scid=kb;en-us;817029

_____________________________

Duane

Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.

(in reply to BeTheBall)
marabe

 

Posts: 32
Joined: 2/26/2004
Status: offline

  		RE: problem with updating a record with DRW - 3/27/2004 13:06:40   
I'm afraid there's not .net support on my hosting provider.

When I changed the files it generete another error message. I feel that i have to start in another direction. Thanks for all your help guys,

Best, Martin

(in reply to BeTheBall)
Spooky

 

Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: problem with updating a record with DRW - 3/27/2004 15:02:57   
If its a numeric field in the database, then it would pay to modify the DRW - it shows the coulumn type as '203' which is adLongVarWChar (memo)

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to marabe)
marabe

 

Posts: 32
Joined: 2/26/2004
Status: offline

  		RE: problem with updating a record with DRW - 3/29/2004 6:55:52   
I've a review site on www.en.se. On the left side you se the latest reviews, displayd with their titles. When the title is longer than the cell it's put on a new row. (like "Skruvens vridning / Jeffrey Asperns brev")

I'd like the title to stay on one row, and if it's to long will be wraped like "Skruvens vridning..." The links are genereted from a database.

Is there a smart way of doing this?

// Marabe

(in reply to marabe)
Spooky

 

Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: problem with updating a record with DRW - 3/29/2004 9:16:37   
Use something like this :

<%
If len(input) > 50 then
response.write Left( INPUT, 50) &"..."
else
response.write INPUT
end if
%>

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to marabe)
marabe

 

Posts: 32
Joined: 2/26/2004
Status: offline

  		RE: problem with updating a record with DRW - 3/29/2004 11:01:02   
yes, that works. Thanks.

(in reply to Spooky)
Page:   [1]

All Forums >> Web Development >> ASP and Database >> problem with updating a record with DRW 		Page: [1]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts


Back to top

  Microsoft Corporation in no way endorses or is affiliated with "OutFront."
  OutFront is published and edited by Thomas Brunt.
  440 Great Circle Dr., St. Matthews, SC 29135.
  © 2008 All Rights Reserved
  Click here to view our privacy statement.