|
| |
|
|
jln209
Posts: 40
Joined: 4/14/2005
Status: offline
 |
Database Editor help - 5/19/2005 16:55:38
Hi, I am using a database editor to edit some fields in my contact manager database. I have three different types of fields, autonumber, text and memo. The top section of the database editor has all the fields except the one memo field. However it does appear as a field on the bottom of the database editor. When I publish the site and go to the database editor, the memo field does not show up and I can't get to the edit screen. When I click on the hyperlink in the DRW at the top, the bottom does nothing and shows 'No records returned.' Why? What do I need to do to get the editor working.
|
|
|
|
rdouglass
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
RE: Database Editor help - 5/20/2005 10:25:11
Do you have a URL by chance?
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
BeTheBall
Posts: 6385
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Database Editor help - 5/20/2005 21:27:43
Can you post the code for detail.asp?
_____________________________
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.
| |
|
|
|
jln209
Posts: 40
Joined: 4/14/2005
Status: offline
|
RE: Database Editor help - 5/23/2005 9:35:20
Here is the code for detail.asp...
<html>
<head>
<% ' FP_ASP -- ASP Automatically generated by a FrontPage Component. Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>contact -- Home</title>
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta name="Microsoft Theme" content="copy-of-network-blitz 1011">
</head>
<body>
<!--webbot bot="PurpleText" PREVIEW="-Important- If you modify this Database Results region using the Database Results Wizard, then your Database Editor will no longer work. If you accidentally open the Database Results Wizard, simply click Cancel to exit without regenerating the Database Results region." -->
<!--webbot bot="DatabaseRegionStart" s-columnnames="Customer Number,Name,Address,City,State,Zip,Phone #,Mobile #,Alternate #,Notes" s-columntypes="3,202,202,202,202,202,202,202,202,203" s-dataconnection="calendar9" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="FALSE" i-ListFormat="5" b-makeform="FALSE" s-RecordSource="contact" s-displaycolumns="Customer Number,Name,Address,City,State,Zip,Phone #,Mobile #,Alternate #,Notes" s-criteria="{Customer Number} EQ {Customer Number} +" s-order s-sql="SELECT * FROM contact WHERE "Customer Number" = ::Field1::" b-procedure="FALSE" clientside SuggestedExt="asp" s-DefaultFields="Field1=0" s-NoRecordsFound="No records returned." i-MaxRecords="1" i-GroupSize="0" u-dblib="../../../_fpclass/fpdblib.inc" u-dbrgn1="../../../_fpclass/fpdbrgn1.inc" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" Tag="BODY" startspan BOTID="0" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font color="#000000">This is the start of a Database Results region. The page must be fetched from a web server with a web browser to display correctly; the current web is stored on your local disk or network.</font></td></tr></table>" --><!--#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="SELECT * FROM contact WHERE ""Customer Number"" = ::Field1::"
fp_sDefault="Field1=0"
fp_sNoRecords="No records returned."
fp_sDataConn="calendar9"
fp_iMaxRecords=1
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Customer Number=3&Name=202&Address=202&City=202&State=202&Zip=202&Phone #=202&Mobile #=202&Alternate #=202&Notes=203&"
fp_iDisplayCols=10
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="3074" -->
<table BORDER=0>
<tr>
<td><b><font size="2">Customer Number:</font></b></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="Customer Number,Name,Address,City,State,Zip,Phone #,Mobile #,Alternate #,Notes" s-column="Customer Number" b-tableformat="TRUE" b-hasHTML="FALSE" clientside startspan b-makelink b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Customer Number<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Customer Number")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="33233" --></td>
</tr><tr>
<td><b><font size="2">Name:</font></b></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="Customer Number,Name,Address,City,State,Zip,Phone #,Mobile #,Alternate #,Notes" s-column="Name" b-tableformat="TRUE" b-hasHTML="FALSE" clientside startspan b-makelink b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Name<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Name")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="3900" --></td>
</tr><tr>
<td><b><font size="2">Address:</font></b></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="Customer Number,Name,Address,City,State,Zip,Phone #,Mobile #,Alternate #,Notes" s-column="Address" b-tableformat="TRUE" b-hasHTML="FALSE" clientside startspan b-makelink b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Address<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Address")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="12103" --></td>
</tr><tr>
<td><b><font size="2">City:</font></b></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="Customer Number,Name,Address,City,State,Zip,Phone #,Mobile #,Alternate #,Notes" s-column="City" b-tableformat="TRUE" b-hasHTML="FALSE" clientside startspan b-makelink b-MenuFormat preview="<font size="-1">&lt;&lt;</font>City<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"City")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="4267" --></td>
</tr><tr>
<td><b><font size="2">State:</font></b></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="Customer Number,Name,Address,City,State,Zip,Phone #,Mobile #,Alternate #,Notes" s-column="State" b-tableformat="TRUE" b-hasHTML="FALSE" clientside startspan b-makelink b-MenuFormat preview="<font size="-1">&lt;&lt;</font>State<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"State")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="10114" --></td>
</tr><tr>
<td><b><font size="2">Zip:</font></b></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="Customer Number,Name,Address,City,State,Zip,Phone #,Mobile #,Alternate #,Notes" s-column="Zip" b-tableformat="TRUE" b-hasHTML="FALSE" clientside startspan b-makelink b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Zip<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Zip")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="3973" --></td>
</tr><tr>
<td><b><font size="2">Phone #:</font></b></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="Customer Number,Name,Address,City,State,Zip,Phone #,Mobile #,Alternate #,Notes" s-column="Phone #" b-tableformat="TRUE" b-hasHTML="FALSE" clientside startspan b-makelink b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Phone #<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Phone #")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="11634" --></td>
</tr><tr>
<td><b><font size="2">Mobile #:</font></b></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="Customer Number,Name,Address,City,State,Zip,Phone #,Mobile #,Alternate #,Notes" s-column="Mobile #" b-tableformat="TRUE" b-hasHTML="FALSE" clientside startspan b-makelink b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Mobile #<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Mobile #")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="13042" --></td>
</tr><tr>
<td><b><font size="2">Alternate #:</font></b></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="Customer Number,Name,Address,City,State,Zip,Phone #,Mobile #,Alternate #,Notes" s-column="Alternate #" b-tableformat="TRUE" b-hasHTML="FALSE" clientside startspan b-makelink b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Alternate #<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Alternate #")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="20158" --></td>
</tr><tr>
<td><b><font size="2">Notes:</font></b></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="Customer Number,Name,Address,City,State,Zip,Phone #,Mobile #,Alternate #,Notes" s-column="Notes" b-tableformat="TRUE" b-hasHTML="FALSE" clientside startspan b-makelink b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Notes<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Notes")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="9199" --></td>
</tr>
<tr><td><table>
<tr>
<td>
<form method="POST" action="edit.asp">
<input type="hidden" name="Field1" value="<%=FP_FieldHTML(fp_rs,"Customer Number")%>">
<p><input type="submit" value=" Edit " name="B1"></p>
</form>
</td>
<td>
<form method="POST" action="delete.asp">
<input type="hidden" name="Field1" value="<%=FP_FieldHTML(fp_rs,"Customer Number")%>">
<p><input type="submit" value="Delete" name="B1"></p>
</form>
</td>
</tr>
</table></td></tr>
</table>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside Tag="BODY" startspan preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font color="#000000">This is the end of a Database Results region.</font></td></tr></table>" --><!--#include file="../../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="9297" -->
</body>
</html>
| |
|
|
|
BeTheBall
Posts: 6385
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Database Editor help - 5/23/2005 10:01:28
Spaces in field names can cause a lot of headaches. Does it work if you go into the gray code and change this:
s-sql="SELECT * FROM contact WHERE "Customer Number" = ::Field1::"
to
s-sql="SELECT * FROM contact WHERE [Customer Number] = ::Field1::"
_____________________________
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.
| |
|
|
|
jln209
Posts: 40
Joined: 4/14/2005
Status: offline
|
RE: Database Editor help - 5/23/2005 11:58:49
That allowed me to see the record when I click on the hyperlink, but when I clicked 'edit' it gave me 'No Records Returned'. Do I need to do the same thing for the list.asp?
Thanks,
Jen
| |
|
|
|
jln209
Posts: 40
Joined: 4/14/2005
Status: offline
|
RE: Database Editor help - 5/23/2005 12:03:22
I did update the code the same for edit.asp and now I can see the record and get to edit, but when I click to save the changes, it tells me the DRW has an error. Where do I go from here?
| |
|
|
|
BeTheBall
Posts: 6385
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Database Editor help - 5/23/2005 13:24:45
Look at update.asp. It probably needs the same fix.
_____________________________
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.
| |
|
|
|
jln209
Posts: 40
Joined: 4/14/2005
Status: offline
|
RE: Database Editor help - 5/23/2005 14:27:14
Where in update.asp do I need to change something. It isn't like the other code and I'm not that sure. Here is the code from the page..
<html>
<head>
<% ' FP_ASP -- ASP Automatically generated by a FrontPage Component. Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>contact -- Updated Record</title>
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
</head>
<body bgcolor="#FFFFFF">
<!--webbot bot="PurpleText" PREVIEW="-Important- If you modify this Database Results region using the Database Results Wizard, then your Database Editor will no longer work. If you accidentally open the Database Results Wizard, simply click Cancel to exit without regenerating the Database Results region." -->
<script Language="JavaScript">
<!--
top.list.location.href = top.list.location.href;
// -->
</script>
<!--webbot bot="DatabaseRegionStart" s-columnnames="Customer Number,Name,Address,City,State,Zip,Phone #,Mobile #,Alternate #,Notes" s-columntypes="3,202,202,202,202,202,202,202,202,203" s-dataconnection="calendar9" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="FALSE" b-listseparator="FALSE" i-ListFormat="0" b-makeform="FALSE" s-RecordSource s-displaycolumns s-criteria s-order s-sql="UPDATE contact SET Name = '::Name::' , Address = '::Address::' , City = '::City::' , State = '::State::' , Zip = '::Zip::' , "Phone #" = '::Field7::' , "Mobile #" = '::Field8::' , "Alternate #" = '::Field9::' , Notes = '::Notes::' WHERE ("Customer Number" = ::Field1::)" b-procedure="FALSE" clientside SuggestedExt="asp" s-DefaultFields="Name=&Address=&City=&State=&Zip=&Field7=&Field8=&Field9=&Notes=&Field1=0" s-NoRecordsFound="Record updated in table." i-MaxRecords="1" i-GroupSize="0" u-dblib="../../../_fpclass/fpdblib.inc" u-dbrgn1="../../../_fpclass/fpdbrgn1.inc" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" Tag="BODY" startspan BOTID="0" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font color="#000000">This is the start of a Database Results region. The page must be fetched from a web server with a web browser to display correctly; the current web is stored on your local disk or network.</font></td></tr></table>" --><!--#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 contact SET [Name] = '::Name::' , Address = '::Address::' , City = '::City::' , State = '::State::' , Zip = '::Zip::' , ""Phone #"" = '::Field7::' , ""Mobile #"" = '::Field8::' , ""Alternate #"" = '::Field9::' , Notes = '::Notes::' WHERE (""Customer Number"" = ::Field1::)"
fp_sDefault="Name=&Address=&City=&State=&Zip=&Field7=&Field8=&Field9=&Notes=&Field1=0"
fp_sNoRecords="Record updated in table."
fp_sDataConn="calendar9"
fp_iMaxRecords=1
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Customer Number=3&Name=202&Address=202&City=202&State=202&Zip=202&Phone #=202&Mobile #=202&Alternate #=202&Notes=203&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="14842" -->
<p><!--webbot bot="PurpleText" PREVIEW="This is the UPDATE query." --></p>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside Tag="BODY" startspan preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font color="#000000">This is the end of a Database Results region.</font></td></tr></table>" --><!--#include file="../../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="9297" -->
</body>
</html>
Also, I read somewhere that to update a record each field must contain something. Is there a way around this? My contact manager has three fields available for phone numbers (home, mobile, & alternate) and some customer don't have three numbers.
Thanks,
Jen
| |
|
|
|
BeTheBall
Posts: 6385
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Database Editor help - 5/23/2005 16:24:30
Try this:
In the gray code, find:
s-sql="UPDATE contact SET Name = '::Name::' , Address = '::Address::' , City = '::City::' , State = '::State::' , Zip = '::Zip::' , "Phone #" = '::Field7::' , "Mobile #" = '::Field8::' , "Alternate #" = '::Field9::' , Notes = '::Notes::' WHERE ("Customer Number" = ::Field1::)"
Replace with:
s-sql="UPDATE contact SET [Name] = '::Name::' , Address = '::Address::' , City = '::City::' , State = '::State::' , Zip = '::Zip::' , "Phone #" = '::Field7::' ,[Mobile #] = '::Field8::' , [Alternate #] = '::Field9::' , Notes = '::Notes::' WHERE [Customer Number] = ::Field1::)"
You will notice that I put brackets around Name. Name is a reserved word and should also be avoided. And in the future, avoid spaces like the plague. 
_____________________________
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.
| |
|
|
|
BeTheBall
Posts: 6385
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Database Editor help - 5/23/2005 18:13:48
Oops, I missed one. Does this one work?
s-sql="UPDATE contact SET [Name] = '::Name::' , Address = '::Address::' , City = '::City::' , State = '::State::' , Zip = '::Zip::' , [Phone #] = '::Field7::' ,[Mobile #] = '::Field8::' , [Alternate #] = '::Field9::' , Notes = '::Notes::' WHERE [Customer Number] = ::Field1::)"
_____________________________
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.
| |
|
|
|
jln209
Posts: 40
Joined: 4/14/2005
Status: offline
|
RE: Database Editor help - 5/24/2005 9:15:08
I tried it the last time with the brackets around all the phone numbers and no it still didn't work.
| |
|
|
|
BeTheBall
Posts: 6385
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Database Editor help - 5/24/2005 9:49:41
In that case, follow the advise in the first post in this thread:
http://www.frontpagewebmaster.com/m-175524/tm.htm
That will not fix the error, but will cause you to receive a more descriptive error message that may help us fix the problem. Also, post the most current version of your page so I can see the changes you have made up to now.
_____________________________
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.
| |
|
|
|
jln209
Posts: 40
Joined: 4/14/2005
Status: offline
|
RE: Database Editor help - 5/24/2005 10:14:00
The error message was that no field can be left blank. Is there a way around this? Like I stated before, I have three fields for phone numbers and not all my customers will have three numbers.
Here is the code from the update.asp page. I'm not sure what to do next. I guess I could always append a letter or something to the field so it isn't blank.
<html>
<head>
<% ' FP_ASP -- ASP Automatically generated by a FrontPage Component. Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>contact -- Updated Record</title>
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta name="Microsoft Theme" content="copy-of-network-blitz 1011">
</head>
<body>
<!--webbot bot="PurpleText" PREVIEW="-Important- If you modify this Database Results region using the Database Results Wizard, then your Database Editor will no longer work. If you accidentally open the Database Results Wizard, simply click Cancel to exit without regenerating the Database Results region." -->
<script Language="JavaScript">
<!--
top.list.location.href = top.list.location.href;
// -->
</script>
<!--webbot bot="DatabaseRegionStart" s-columnnames="Customer Number,Name,Address,City,State,Zip,Phone #,Mobile #,Alternate #,Notes" s-columntypes="3,202,202,202,202,202,202,202,202,203" s-dataconnection="calendar9" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="FALSE" b-listseparator="FALSE" i-ListFormat="0" b-makeform="FALSE" s-RecordSource s-displaycolumns s-criteria s-order s-sql="UPDATE contact SET [Name] = '::Name::' , Address = '::Address::' , City = '::City::' , State = '::State::' , Zip = '::Zip::' , [Phone #] = '::Field7::' , [Mobile #] = '::Field8::' , [Alternate #] = '::Field9::' , Notes = '::Notes::' WHERE ([Customer Number] = ::Field1::)" b-procedure="FALSE" clientside SuggestedExt="asp" s-DefaultFields="Name=&Address=&City=&State=&Zip=&Field7=&Field8=&Field9=&Notes=&Field1=0" s-NoRecordsFound="Record updated in table." i-MaxRecords="1" i-GroupSize="0" u-dblib="../../../_fpclass/fpdblib.inc" u-dbrgn1="../../../_fpclass/fpdbrgn1.inc" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" Tag="BODY" startspan BOTID="0" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font color="#000000">This is the start of a Database Results region. The page must be fetched from a web server with a web browser to display correctly; the current web is stored on your local disk or network.</font></td></tr></table>" --><!--#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 contact SET [Name] = '::Name::' , Address = '::Address::' , City = '::City::' , State = '::State::' , Zip = '::Zip::' , [Phone #] = '::Field7::' , [Mobile #] = '::Field8::' , [Alternate #] = '::Field9::' , Notes = '::Notes::' WHERE ([Customer Number] = ::Field1::)"
fp_sDefault="Name=&Address=&City=&State=&Zip=&Field7=&Field8=&Field9=&Notes=&Field1=0"
fp_sNoRecords="Record updated in table."
fp_sDataConn="calendar9"
fp_iMaxRecords=1
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Customer Number=3&Name=202&Address=202&City=202&State=202&Zip=202&Phone #=202&Mobile #=202&Alternate #=202&Notes=203&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="4391" -->
<p><!--webbot bot="PurpleText" PREVIEW="This is the UPDATE query." --></p>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside Tag="BODY" startspan preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font color="#000000">This is the end of a Database Results region.</font></td></tr></table>" --><!--#include file="../../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="9297" -->
</body>
</html>
| |
|
|
|
BeTheBall
Posts: 6385
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Database Editor help - 5/24/2005 10:50:18
You usually account for that problem in the database itself. Go into the table in design view and for every field that can be blank set "Allow zero-length" to Yes.
_____________________________
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.
| |
|
|
|
jln209
Posts: 40
Joined: 4/14/2005
Status: offline
|
RE: Database Editor help - 5/24/2005 16:54:52
Thank you for all your help. My contact manager is up and running. Again, thank you. I never would have figured this out on my own.
Jen
| |
|
 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
|
|
|
Printable Version 
