|
| |
|
|
williamg
Posts: 20
Joined: 6/26/2003
Status: offline
 |
Database is says it is update but it is not!!! - 6/25/2004 15:55:52
 HELP!!!!!
I have my Database all Done but when I am in the EDIT.ASP and make changes it gives me the message the Database was updated, but when I search the the record it doesn't have the changes I just made. Below is the UPDATE code:
PLEASE HELP!!!!!
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Results -- Updated Record</title>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
</head>
<body bgcolor="#FFFFFF">
<script Language="JavaScript">
</script>
<!--#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 Inquiry_Date = '::Inquiry_Date::' ,District_Code = '::District_Code::' , EMS_Number = ::EMS_Number:: , Student_First_Name = '::Student_First_Name::' , Student_Last_Name = '::Student_Last_Name::' , Mailing_Address = '::Mailing_Address::' , Mailing_Address2 = '::Mailing_Address2::' , City = '::City::' , State = '::State::' , Zip = ::Zip:: , Email = '::Email::' , Day_Phone = '::Day_Phone::' , Cell_Phone = '::Cell_Phone::' , Returning_Interested = '::Returning_Interested::' , Self_Improvement_Learn_CPU_Skills = '::Self_Improvement_Learn_CPU_Skills::' , Flexible_Schedule = '::Flexible_Schedule::' , Earn_Extra_Income = '::Earn_Extra_Income::' , Part_Time_Employment = '::Part_Time_Employment::' , Interested_Other = '::Interested_Other::' , Other_Interested_Reason = '::Other_Interested_Reason::' , Direct_Mail = '::Direct_Mail::' , Banner_Office_Signs = '::Banner_Office_Signs::' , Flyers = '::Flyers::' , Website = '::Website::' , Prior_Year_Inquiry = '::Prior_Year_Inquiry::' , Yellow_Pages = '::Yellow_Pages::' , Career_Fair_Job_Fair = '::Career_Fair_Job_Fair::' , Billboards = '::Billboards::' , Newspaper = '::Newspaper::' , Newspaper_Name = '::Newspaper_Name::' , Radio = '::Radio::' , Radio_Station = '::Radio_Station::' , TV = '::TV::' , TV_Station = '::TV_Station::' , Source_Other = '::Source_Other::' , Source_Inquiry_Other_Reason = '::Source_Inquiry_Other_Reason::' , Brochure_Packet_Mailed = '::Brochure_Packet_Mailed::' , Mailed_Packet_Date = '::Mailed_Packet_Date::' , Postcard = '::Postcard::' , Postcard_Date = '::Postcard_Date::' , Mailed_Open_House_Invite = '::Mailed_Open_House_Invite::' , Mailed_Open_House_Invite_Date = '::Mailed_Open_House_Invite_Date::' , attended_open_house = '::attended_open_house::' , Attended_Open_House_Date = '::Attended_Open_House_Date::' , do_not_contact = '::do_not_contact::' , Follow_up_call = '::Follow_up_call::' , follow_up_call_1 = '::follow_up_call_1::' , follow_up_call_2 = '::follow_up_call_2::' , follow_up_call_3 = '::follow_up_call_3::' , follow_up_call_4 = '::follow_up_call_4::' , follow_up_call_5 = '::follow_up_call_5::' , Class_Location1 = '::Class_Location1::' , Class_Location2 = '::Class_Location2::' , Class_Location3 = '::Class_Location3::' , receipt_number_yn = '::receipt_number_yn::' , Receipt_Number = '::Receipt_Number::' , Down_Payment_Amount = '::Down_Payment_Amount::' , Down_Payment_Amount_Date = '::Down_Payment_Amount_Date::' , Payment_Type_For_Down_Payment = '::Payment_Type_For_Down_Payment::' , ems_p1 = '::ems_p1::' , Payment_Amount2 = '::Payment_Amount2::' , Payment_Amount_Date2 = '::Payment_Amount_Date2::' , Payment_Type_For_Payment2 = '::Payment_Type_For_Payment2::' , ems_p2 = '::ems_p2::' , Payment_Amount3 = '::Payment_Amount3::' , Payment_Amount_Date3 = '::Payment_Amount_Date3::' , Payment_Type_For_Payment3 = '::Payment_Type_For_Payment3::' , ems_p3 = '::ems_p3::' , Payment_Amount4 = '::Payment_Amount4::' , Payment_Amount_Date4 = '::Payment_Amount_Date4::' , Payment_Type_For_Payment4 = '::Payment_Type_For_Payment4::' , ems_p4 = '::ems_p4::' , Payment_Amount5 = '::Payment_Amount5::' , Payment_Amount_Date5 = '::Payment_Amount_Date5::' , coupon_code = '::coupon_code::' , ems_p5 = '::ems_p5::' , cost_of_books = '::cost_of_books::' , Date_Books_Issued = '::Date_Books_Issued::' , Date_Books_Issued_Date = '::Date_Books_Issued_Date::' , books_issued_By = '::books_issued_By::' , Course_Assigned = '::Course_Assigned::' , Course_Assigned_Name = '::Course_Assigned_Name::' , Course_Completed = '::Course_Completed::' , course_completed_number = '::course_completed_number::' , Final_Score = '::Final_Score::' , Reason_Course_wasnt_completed = '::Reason_Course_wasnt_completed::' , Why_course_wasnt_completed_reason = '::Why_course_wasnt_completed_reason::' , Hired = '::Hired::' , Not_Hired = '::Not_Hired::' , Days = '::Days::' , Evenings = '::Evenings::' , Weekends = '::Weekends::' WHERE (Evening_Phone = '::Evening_Phone::')"
fp_sDefault="Inquiry_Date=&District_Code=&EMS_Number=&Student_First_Name=&Student_Last_Name=&Mailing_Address=&Mailing_Address2=&City=&State=&Zip=&Email=&Day_Phone=&Cell_Phone=&Returning_Interested=&Self_Improvement_Learn_CPU_Skills=&Flexible_Schedule=&Earn_Extra_Income=&Part_Time_Employment=&Interested_Other=&Other_Interested_Reason=&Direct_Mail=&Banner_Office_Signs=&Flyers=&Website=&Prior_Year_Inquiry=&Yellow_Pages=&Career_Fair_Job_Fair=&Billboards=&Newspaper=&Newspaper_Name=&Radio=&Radio_Station=&TV=&TV_Station=&Source_Other=&Source_Inquiry_Other_Reason=&Brochure_Packet_Mailed=&Mailed_Packet_Date=&Postcard=&Postcard_Date=&Mailed_Open_House_Invite=&Mailed_Open_House_Invite_Date=&attended_open_house=&Attended_Open_House_Date=&do_not_contact=&Follow_up_call=&follow_up_call_1=&follow_up_call_2=&follow_up_call_3=&follow_up_call_4=&follow_up_call_5=&Class_Location1=&Class_Location2=&Class_Location3=&receipt_number_yn=&Receipt_Number=&Down_Payment_Amount=&Down_Payment_Amount_Date=&Payment_Type_For_Down_Payment=&ems_p1=&Payment_Amount2=&Payment_Amount_Date2=&Payment_Type_For_Payment2=&ems_p2=&Payment_Amount3=&Payment_Amount_Date3=&Payment_Type_For_Payment3=&ems_p3=&Payment_Amount4=&Payment_Amount_Date4=&Payment_Type_For_Payment4=&ems_p4=&Payment_Amount5=&Payment_Amount_Date5=&coupon_code=&ems_p5=&cost_of_books=&Date_Books_Issued=&Date_Books_Issued_Date=&books_issued_By=&Course_Assigned=&Course_Assigned_Name=&Course_Completed=&course_completed_number=&Final_Score=&Reason_Course_wasnt_completed=&Why_course_wasnt_completed_reason=&Hired=&Not_Hired=&Days=&Evenings=&Weekends=&Evening_Phone="
fp_sNoRecords="Thank You! Student Now Updated in Database."
fp_sDataConn="tsi2004"
fp_iMaxRecords=1
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../../_fpclass/fpdbrgn1.inc"-->
<p></p>
<!--#include file="../../../_fpclass/fpdbrgn2.inc"-->
I KNOW IT IS A LOT OF FIELDS BUT I CHECKED EVERYTHING, I HOPE I CAN GET SOME HELP!!!!!!!!!!
< Message edited by Spooky -- 6/25/2004 21:08:43 >
|
|
|
|
williamg
Posts: 20
Joined: 6/26/2003
Status: offline
|
RE: Database is says it is update but it is not!!! - 6/26/2004 15:44:21
quote:
Response.write fp_sQry
Response.end
Thanks for the response!
I think my mistake was using the Spooky Diet on the UPDATE.ASP page! I think it brokeapart the database.
SO I created another Database Editor with the wizard and I will cut and paste the new UPDATE.ASP into the live folder.
My questions:
I used the Spooky Diet of the Submission Form and Edit Page--> How do I get it to work on the UPDATE.ASP page?
THIS IS THE NEW CODE
fp_sQry="UPDATE Results SET District_Code = '::District_Code::' , EMS_Number = '::EMS_Number::' , Student_First_Name = '::Student_First_Name::' , Student_Last_Name = '::Student_Last_Name::' , Mailing_Address = '::Mailing_Address::' , Mailing_Address2 = '::Mailing_Address2::' , City = '::City::' , State = '::State::' , Zip = '::Zip::' , Email = '::Email::' , Day_Phone = '::Day_Phone::' , Evening_Phone = '::Evening_Phone::' , Cell_Phone = '::Cell_Phone::' , Returning_Interested = '::Returning_Interested::' , Self_Improvement_Learn_CPU_Skills = '::Self_Improvement_Learn_CPU_Skills::' , Flexible_Schedule = '::Flexible_Schedule::' , Earn_Extra_Income = '::Earn_Extra_Income::' , Part_Time_Employment = '::Part_Time_Employment::' , Interested_Other = '::Interested_Other::' , Other_Interested_Reason = '::Other_Interested_Reason::' , Direct_Mail = '::Direct_Mail::' , Banner_Office_Signs = '::Banner_Office_Signs::' , Flyers = '::Flyers::' , Website = '::Website::' , Prior_Year_Inquiry = '::Prior_Year_Inquiry::' , Yellow_Pages = '::Yellow_Pages::' , Career_Fair_Job_Fair = '::Career_Fair_Job_Fair::' , Billboards = '::Billboards::' , Newspaper = '::Newspaper::' , Newspaper_Name = '::Newspaper_Name::' , Radio = '::Radio::' , Radio_Station = '::Radio_Station::' , TV = '::TV::' , TV_Station = '::TV_Station::' , Source_Other = '::Source_Other::' , Source_Inquiry_Other_Reason = '::Source_Inquiry_Other_Reason::' , Brochure_Packet_Mailed = '::Brochure_Packet_Mailed::' , Mailed_Packet_Date = '::Mailed_Packet_Date::' , Postcard = '::Postcard::' , Postcard_Date = '::Postcard_Date::' , Mailed_Open_House_Invite = '::Mailed_Open_House_Invite::' , Mailed_Open_House_Invite_Date = '::Mailed_Open_House_Invite_Date::' , attended_open_house = '::attended_open_house::' , Attended_Open_House_Date = '::Attended_Open_House_Date::' , do_not_contact = '::do_not_contact::' , Follow_up_call = '::Follow_up_call::' , follow_up_call_1 = '::follow_up_call_1::' , follow_up_call_2 = '::follow_up_call_2::' , follow_up_call_3 = '::follow_up_call_3::' , follow_up_call_4 = '::follow_up_call_4::' , follow_up_call_5 = '::follow_up_call_5::' , Class_Location1 = '::Class_Location1::' , Class_Location2 = '::Class_Location2::' , Class_Location3 = '::Class_Location3::' , receipt_number_yn = '::receipt_number_yn::' , Receipt_Number = '::Receipt_Number::' , Down_Payment_Amount = '::Down_Payment_Amount::' , Down_Payment_Amount_Date = '::Down_Payment_Amount_Date::' , Payment_Type_For_Down_Payment = '::Payment_Type_For_Down_Payment::' , ems_p1 = '::ems_p1::' , Payment_Amount2 = '::Payment_Amount2::' , Payment_Amount_Date2 = '::Payment_Amount_Date2::' , Payment_Type_For_Payment2 = '::Payment_Type_For_Payment2::' , ems_p2 = '::ems_p2::' , Payment_Amount3 = '::Payment_Amount3::' , Payment_Amount_Date3 = '::Payment_Amount_Date3::' , Payment_Type_For_Payment3 = '::Payment_Type_For_Payment3::' , ems_p3 = '::ems_p3::' , Payment_Amount4 = '::Payment_Amount4::' , Payment_Amount_Date4 = '::Payment_Amount_Date4::' , Payment_Type_For_Payment4 = '::Payment_Type_For_Payment4::' , ems_p4 = '::ems_p4::' , Payment_Amount5 = '::Payment_Amount5::' , Payment_Amount_Date5 = '::Payment_Amount_Date5::' , coupon_code = '::coupon_code::' , ems_p5 = '::ems_p5::' , cost_of_books = '::cost_of_books::' , Date_Books_Issued = '::Date_Books_Issued::' , Date_Books_Issued_Date = '::Date_Books_Issued_Date::' , books_issued_By = '::books_issued_By::' , Course_Assigned = '::Course_Assigned::' , Course_Assigned_Name = '::Course_Assigned_Name::' , Course_Completed = '::Course_Completed::' , course_completed_number = '::course_completed_number::' , Final_Score = '::Final_Score::' , Reason_Course_wasnt_completed = '::Reason_Course_wasnt_completed::' , Why_course_wasnt_completed_reason = '::Why_course_wasnt_completed_reason::' , Hired = '::Hired::' , Not_Hired = '::Not_Hired::' , Days = '::Days::' , Evenings = '::Evenings::' , Weekends = '::Weekends::' WHERE (Inquiry_Date = ::Inquiry_Date::)"
fp_sDefault="District_Code=&EMS_Number=&Student_First_Name=&Student_Last_Name=&Mailing_Address=&Mailing_Address2=&City=&State=&Zip=&Email=&Day_Phone=&Evening_Phone=&Cell_Phone=&Returning_Interested=&Self_Improvement_Learn_CPU_Skills=&Flexible_Schedule=&Earn_Extra_Income=&Part_Time_Employment=&Interested_Other=&Other_Interested_Reason=&Direct_Mail=&Banner_Office_Signs=&Flyers=&Website=&Prior_Year_Inquiry=&Yellow_Pages=&Career_Fair_Job_Fair=&Billboards=&Newspaper=&Newspaper_Name=&Radio=&Radio_Station=&TV=&TV_Station=&Source_Other=&Source_Inquiry_Other_Reason=&Brochure_Packet_Mailed=&Mailed_Packet_Date=&Postcard=&Postcard_Date=&Mailed_Open_House_Invite=&Mailed_Open_House_Invite_Date=&attended_open_house=&Attended_Open_House_Date=&do_not_contact=&Follow_up_call=&follow_up_call_1=&follow_up_call_2=&follow_up_call_3=&follow_up_call_4=&follow_up_call_5=&Class_Location1=&Class_Location2=&Class_Location3=&receipt_number_yn=&Receipt_Number=&Down_Payment_Amount=&Down_Payment_Amount_Date=&Payment_Type_For_Down_Payment=&ems_p1=&Payment_Amount2=&Payment_Amount_Date2=&Payment_Type_For_Payment2=&ems_p2=&Payment_Amount3=&Payment_Amount_Date3=&Payment_Type_For_Payment3=&ems_p3=&Payment_Amount4=&Payment_Amount_Date4=&Payment_Type_For_Payment4=&ems_p4=&Payment_Amount5=&Payment_Amount_Date5=&coupon_code=&ems_p5=&cost_of_books=&Date_Books_Issued=&Date_Books_Issued_Date=&books_issued_By=&Course_Assigned=&Course_Assigned_Name=&Course_Completed=&course_completed_number=&Final_Score=&Reason_Course_wasnt_completed=&Why_course_wasnt_completed_reason=&Hired=&Not_Hired=&Days=&Evenings=&Weekends=&Inquiry_Date="
fp_sNoRecords="Record updated in table."
fp_sDataConn="tsi2004"
fp_iMaxRecords=1
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
Also Now with the new UPDATE.ASP code I would need the Spooky Diet to change the Key to Evening_Phone instead of Inqury_Date.
I think that is my problem I can't change to code because I get the frontpage unable to change error.
| |
|
|
|
BeTheBall
Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Database is says it is update but it is not!!! - 6/26/2004 18:45:35
With that many fields, the Spooky Diet would get a little dicey because you are likely to miss something. There is a macro that automatically runs the diet for you, which I highly recommend. Here is the code:
Sub spooky_Diet()
Dim innerHTML As String, Webbot As String
If Not FrontPage.ActiveDocument Is Nothing Then
If FrontPage.ActivePageWindow.ViewMode = fpPageViewNormal Then
innerHTML = ActiveDocument.body.innerHTML
Do
Webbot = Ellipse(innerHTML, "<!--webbot", "-->")
If Webbot = "" Then Exit Do
If InStr(Webbot, "bot=""Database") <> 0 Then
innerHTML = Replace(innerHTML, Webbot, "")
End If
If InStr(Webbot, " bot=""SaveAsASP") <> 0 Then
innerHTML = Replace(innerHTML, Webbot, "")
End If
If InStr(Webbot, " bot=""AspInclude") <> 0 Then
innerHTML = Replace(innerHTML, Webbot, "")
End If
Loop
ActiveDocument.body.innerHTML = innerHTML
End If
End If
End Sub
Function Ellipse(i, s, e)
Dim f As Integer, t As Integer
Ellipse = ""
f = InStr(1, i, s, 1)
If f > 0 Then
t = InStr(f + 1, i, e, 1)
If t > 0 Then
Ellipse = Mid(i, f, t - f) & e
End If
End If
End Function
Open FrontPage and click Tools, then Macro, then Macros. Then in the box for Macro name, enter:
spooky_Diet()
Then click the "Create" button. Delete the little bit of code that is already there and paste in the above code. Close the Microsoft Visual Basic Editor and you now have a Macro that will run the Spooky Diet for you. Simply open the page you need to diet, click tools - macro - macros. Select the macro you just created and click run. It's a real time saver, especially with that many fields in your db.
_____________________________
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.
| |
|
|
|
williamg
Posts: 20
Joined: 6/26/2003
Status: offline
|
RE: Database is says it is update but it is not!!! - 6/28/2004 10:10:26
UPDATE Results SET Inquiry_Date = '::Inquiry_Date::' , District_Code = '::District_Code::' ,EMS_Number = '::EMS_Number::' , Student_First_Name = '::Student_First_Name::' , Student_Last_Name = '::Student_Last_Name::' , Mailing_Address = '::Mailing_Address::' , Mailing_Address2 = '::Mailing_Address2::' , City = '::City::' , State = '::State::' , Zip = '::Zip::' , Email = '::Email::' , Day_Phone = '::Day_Phone::' , Cell_Phone = '::Cell_Phone::' , Returning_Interested = '::Returning_Interested::' , Self_Improvement_Learn_CPU_Skills = '::Self_Improvement_Learn_CPU_Skills::' , Flexible_Schedule = '::Flexible_Schedule::' , Earn_Extra_Income = '::Earn_Extra_Income::' , Part_Time_Employment = '::Part_Time_Employment::' , Interested_Other = '::Interested_Other::' , Other_Interested_Reason = '::Other_Interested_Reason::' , Direct_Mail = '::Direct_Mail::' , Banner_Office_Signs = '::Banner_Office_Signs::' , Flyers = '::Flyers::' , Website = '::Website::' , Prior_Year_Inquiry = '::Prior_Year_Inquiry::' , Yellow_Pages = '::Yellow_Pages::' , Career_Fair_Job_Fair = '::Career_Fair_Job_Fair::' , Billboards = '::Billboards::' , Newspaper = '::Newspaper::' , Newspaper_Name = '::Newspaper_Name::' , Radio = '::Radio::' , Radio_Station = '::Radio_Station::' , TV = '::TV::' , TV_Station = '::TV_Station::' , Source_Other = '::Source_Other::' , Source_Inquiry_Other_Reason = '::Source_Inquiry_Other_Reason::' , Brochure_Packet_Mailed = '::Brochure_Packet_Mailed::' , Mailed_Packet_Date = '::Mailed_Packet_Date::' , Postcard = '::Postcard::' , Postcard_Date = '::Postcard_Date::' , Mailed_Open_House_Invite = '::Mailed_Open_House_Invite::' , Mailed_Open_House_Invite_Date = '::Mailed_Open_House_Invite_Date::' , attended_open_house = '::attended_open_house::' , Attended_Open_House_Date = '::Attended_Open_House_Date::' , do_not_contact = '::do_not_contact::' , Follow_up_call = '::Follow_up_call::' , follow_up_call_1 = '::follow_up_call_1::' , follow_up_call_2 = '::follow_up_call_2::' , follow_up_call_3 = '::follow_up_call_3::' , follow_up_call_4 = '::follow_up_call_4::' , follow_up_call_5 = '::follow_up_call_5::' , Class_Location1 = '::Class_Location1::' , Class_Location2 = '::Class_Location2::' , Class_Location3 = '::Class_Location3::' , receipt_number_yn = '::receipt_number_yn::' , Receipt_Number = '::Receipt_Number::' , Down_Payment_Amount = '::Down_Payment_Amount::' , Down_Payment_Amount_Date = '::Down_Payment_Amount_Date::' , Payment_Type_For_Down_Payment = '::Payment_Type_For_Down_Payment::' , ems_p1 = '::ems_p1::' , Payment_Amount2 = '::Payment_Amount2::' , Payment_Amount_Date2 = '::Payment_Amount_Date2::' , Payment_Type_For_Payment2 = '::Payment_Type_For_Payment2::' , ems_p2 = '::ems_p2::' , Payment_Amount3 = '::Payment_Amount3::' , Payment_Amount_Date3 = '::Payment_Amount_Date3::' , Payment_Type_For_Payment3 = '::Payment_Type_For_Payment3::' , ems_p3 = '::ems_p3::' , Payment_Amount4 = '::Payment_Amount4::' , Payment_Amount_Date4 = '::Payment_Amount_Date4::' , Payment_Type_For_Payment4 = '::Payment_Type_For_Payment4::' , ems_p4 = '::ems_p4::' , Payment_Amount5 = '::Payment_Amount5::' , Payment_Amount_Date5 = '::Payment_Amount_Date5::' , coupon_code = '::coupon_code::' , ems_p5 = '::ems_p5::' , cost_of_books = '::cost_of_books::' , Date_Books_Issued = '::Date_Books_Issued::' , Date_Books_Issued_Date = '::Date_Books_Issued_Date::' , books_issued_By = '::books_issued_By::' , Course_Assigned = '::Course_Assigned::' , Course_Assigned_Name = '::Course_Assigned_Name::' , Course_Completed = '::Course_Completed::' , course_completed_number = '::course_completed_number::' , Final_Score = '::Final_Score::' , Reason_Course_wasnt_completed = '::Reason_Course_wasnt_completed::' , Why_course_wasnt_completed_reason = '::Why_course_wasnt_completed_reason::' , Hired = '::Hired::' , Not_Hired = '::Not_Hired::' , Days = '::Days::' , Evenings = '::Evenings::' , Weekends = '::Weekends::' WHERE (Evening_Phone = '::Evening_Phone::')
I know it is alot of Fields but It work last year the only thing I am doing different was rearrange the EDIT.ASP Fields so that the edit interface looked more like the Submission form.
I looks like everything is correct and I get a 'Record Now updated in Database' after I submit but it doesn't write to the DB I even check in the DB itself but nothing.
| |
|
|
|
BeTheBall
Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Database is says it is update but it is not!!! - 6/28/2004 10:34:52
Maybe the permissions got changed on the db folder. Can you add a new record?
_____________________________
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.
| |
|
|
|
williamg
Posts: 20
Joined: 6/26/2003
Status: offline
|
RE: Database is says it is update but it is not!!! - 6/28/2004 11:16:17
YUP! I was able to add a record, I checked the DB permissions and they are all set. Allow Zero Length are there other permissions I should check?
Also I just want to test and I was able to edit the record in the DB itself.
| |
|
 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 
k¥ 