Problem writing Form results to Access DB
Problem writing Form results to Access DB
(OP)
I have a main Domain & Site "sejasedentariocomsaude.com" with subdomains: "curesuacoluna.com", etc.
In "index.asp" page of both sites I have a FORM that must write its results to the same Access DB: contactos.mdb, located in the special sub-directory "fpdb".
The problem is: the main one works correctly BUT the other never writes its data to the DB, but I can't see no error.
The only difference in both forms is the DB's address and related files.
I already lost a lot of time trying to solve the problem, without success but I'm not a professional in this field.
Could you help me ? You can see the code accessing my pages in the respective sites.
In "index.asp" page of both sites I have a FORM that must write its results to the same Access DB: contactos.mdb, located in the special sub-directory "fpdb".
The problem is: the main one works correctly BUT the other never writes its data to the DB, but I can't see no error.
The only difference in both forms is the DB's address and related files.
I already lost a lot of time trying to solve the problem, without success but I'm not a professional in this field.
Could you help me ? You can see the code accessing my pages in the respective sites.
RE: Problem writing Form results to Access DB
1) sejasedentariocomsaude.com/index.asp » FORM:
***********************************************************
<TABLE class=verdanasmall cellSpacing=0
cellPadding=2 width="100%" align=center
border=0>
<form method="POST" name="saiba mais" action="index.asp" webbot-action="--WEBBOT-SELF--">
<!--webbot bot="SaveDatabase" SuggestedExt="asp" S-DataConnection="ConectDB"
S-RecordSource="TbContatos" U-Database-URL="fpdb/contatos.mdb" U-Confirmation-Url="cadastro.asp"
S-Form-Fields="nome email pais site" S-Form-DBFields="Nome Email Pais Site" startspan
U-ASP-Include-Url="_fpclass/fpdbform.inc" --><input TYPE="hidden" NAME="VTI-GROUP" VALUE="0"><!--#include file="_fpclass/fpdbform.inc"--><!--webbot bot="SaveDatabase" endspan i-checksum="40548" -->
<P>
<TBODY>
<TR>
<TD class=verdanasmall id=padrao vAlign=center
width="25%">Nome:</TD>
<TD><INPUT TYPE=TEXT NAME="nome" SIZE=12>
</TD></TR>
<TR>
<TD class=verdanasmall id=padrao vAlign=center
width="25%"><NOBR>E-mail:</NOBR></TD>
<TD><INPUT TYPE=TEXT NAME="email" SIZE=12>
</TD></TR>
<TR>
<TD class=verdanasmall id=padrao vAlign=center
width="25%">País:</TD>
<TD><INPUT TYPE=TEXT NAME="pais" SIZE=12>
</TD></TR>
<input TYPE="hidden" NAME="site" VALUE="SSCS">
<TR>
<TD class=verdanasmall id=padrao vAlign=center Colspan=2 align="center"><BR>
<INPUT TYPE=SUBMIT STYLE="Cursor: hand" VALUE="Clique já, é gratuito"></TD></TR>
</FORM></TBODY></TABLE>
***********************************************************
2) curesuacoluna.com/index.asp » FORM:
<table align=center width="144">
<form method="POST" name="preencha" action="index.asp" webbot-action="--WEBBOT-SELF--">
<!--webbot bot="SaveDatabase" SuggestedExt="asp" S-DataConnection="ConectDB"
S-RecordSource="TbContatos" U-Database-URL="../fpdb/contatos.mdb" U-Confirmation-Url="cadastro.asp"
S-Form-Fields="nome email pais site" S-Form-DBFields="Nome Email Pais Site" startspan
U-ASP-Include-Url="../_fpclass/fpdbform.inc" --><input TYPE="hidden" NAME="VTI-GROUP" VALUE="0">
<!--#include file="../_fpclass/fpdbform.inc"--><!--webbot bot="SaveDatabase" endspan i-checksum="34604" -->
<tr><td width="154"><font face=verdana><B>Nome:<br><input type=text name="nome" size=26></b></font></td></tr>
<tr><td width="154"><font face=verdana><B>E-mail:<br><input type=text name="email" size=26></b></font></td></tr>
<tr><td width="154"><font face=verdana><B>País:<br><input type=text name="pais" size=26></b></font></td></tr>
<input TYPE="hidden" NAME="site" VALUE="CSC">
<tr><td width="150" valign="bottom" height="40"><center><b><input type=submit value="Clique já, é gratuito"
style="font-weight: bold"></b></center></td></tr>
</form>
</table>
RE: Problem writing Form results to Access DB
[code]
cacls xxx.mdb /E /G everyone:C