this sucks !!!

mrbleide · 11-Jun-2007, 12:08 PM #1

hi eribody i just wanted to ask for some help if possible, so the problem is:

i have a file addnews.asp that sends information via methodpost to addnews2.asp, addnews2.asp is supposed to stock some info in a *.mdb file. but i think that there is smthng wrong with the addnews2.asp script, check this out :

Code:

<%
if session("login") <> 1 THEN response.redirect("index.asp")
dim newsmonth
dim newsday
dim newsyear
dim news

newsmonth = request.form("month")
newsday = request.form("day")
newsyear = request.form("year")
news = request.form("News")

response.Write request.Form("month") & newsmonth & newsday & newsyear & news

' ADD DATA TO DATABASE
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.connectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=d:\webs\nito\data\products.mdb;"
objConn.Mode = 3 
objConn.Open 

strSQL = "INSERT INTO News ([Month], [Day], [Year], News) SELECT " & newsmonth & "," & newsday & ",'" & newsyear & "','" & news & "';"
response.write strSQL
set objRS = objCONN.Execute(strSQL) 
'objRS.Open strSQL, objCONN

'response.write strSQL & vbcrlf

response.Redirect("mainmenu.asp")' & "&msg=Upload+Successful")
%>

thx alot guys i apreciate your help, take care

Rockn · 11-Jun-2007, 11:03 PM #2

<%

dim newsmonth
dim newsday
dim newsyear
dim news
Dim rsNews
Dim strConnect

newsmonth = request.form("month")
newsday = request.form("day")
newsyear = request.form("year")
news = request.form("News")

response.Write request.Form("month") & newsmonth & newsday & newsyear & news

' ADD DATA TO DATABASE
Set rsNews = Server.CreateObject("ADODB.Recordset")
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=E:\wwwroot\TEST\database\db13.mdb;"
rsNews.Open "NEWS", strConnect, adOpenForwardOnly, adLockOptimistic, adCmdTable
rsNews.AddNew
rsNews("month") = newsmonth
rsNews("day") = newsday
rsNews("year") = newsyear
rsNews("news") = news
rsNews.Update
rsNews.Close
Set rsNews = Nothing

You may also need to put this in the top of your page if there is still an error:



Make sure the msado15.dll is at that location

mrbleide · 13-Jun-2007, 09:34 AM #3

Yeah so now this is my code, and it is still not working :s

Code:

<%
<!-- METADATA TYPE="typelib" 
              FILE="C:\Program Files\Common Files\System\ado\msado15.dll" -->

if session("login") <> 1 THEN response.redirect("index.asp")

dim newsmonth
dim newsday
dim newsyear
dim news
Dim rsNews
Dim strConnect

newsmonth = request.form("month")
newsday = request.form("day")
newsyear = request.form("year")
news = request.form("News")

response.Write request.Form("month") & newsmonth & newsday & newsyear & news

' ADD DATA TO DATABASE
Set rsNews = Server.CreateObject("ADODB.Recordset")
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;DATA
SOURCE=d:\webs\nicolettiitalia.com\data\products.mdb;"
rsNews.Open "NEWS", strConnect, adOpenForwardOnly, adLockOptimistic, adCmdTable
rsNews.AddNew
rsNews("month") = newsmonth
rsNews("day") = newsday
rsNews("year") = newsyear
rsNews("news") = news
rsNews.Update
rsNews.Close
Set rsNews = Nothing


response.Redirect("mainmenu.asp")
%>

mrbleide · 13-Jun-2007, 10:05 AM #4

BUT ALSO THIS IS MY CODE IN : ADDNEWS.ASP

Code:

<%if session("login") <> 1 THEN response.redirect("index.asp")%>
<html>
<head>
<title>Add News &amp; Events</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script Language="JavaScript">
function isEmailAddr(email)
{
  var result = false;
  var theStr = new String(email);
  var index = theStr.indexOf("@");
  if (index > 0)
  {
    var pindex = theStr.indexOf(".",index);
    if ((pindex > index+1) && (theStr.length > pindex+1))
	result = true;
  }
  return result;
}

function validRequired(formField,fieldLabel)
{
	var result = true;
	
	if (formField.value == "")
	{
		alert('Please enter a value for the "' + fieldLabel +'" field.');
		formField.focus();
		result = false;
	}
	
	return result;
}

function allDigits(str)
{
	return inValidCharSet(str,"0123456789");
}

function inValidCharSet(str,charset)
{
	var result = true;

	// Note: doesn't use regular expressions to avoid early Mac browser bugs	
	for (var i=0;i<str.length;i++)
		if (charset.indexOf(str.substr(i,1))<0)
		{
			result = false;
			break;
		}
	
	return result;
}

function validEmail(formField,fieldLabel,required)
{
	var result = true;
	
	if (required && !validRequired(formField,fieldLabel))
		result = false;

	if (result && ((formField.value.length < 3) || !isEmailAddr(formField.value)) )
	{
		alert("Please enter a complete email address in the form: yourname@yourdomain.com");
		formField.focus();
		result = false;
	}
   
  return result;

}

function validNum(formField,fieldLabel,required)
{
	var result = true;

	if (required && !validRequired(formField,fieldLabel))
		result = false;
  
 	if (result)
 	{
 		if (!allDigits(formField.value))
 		{
 			alert('Please enter a number for the "' + fieldLabel +'" field.');
			formField.focus();		
			result = false;
		}
	} 
	
	return result;
}


function validInt(formField,fieldLabel,required)
{
	var result = true;

	if (required && !validRequired(formField,fieldLabel))
		result = false;
  
 	if (result)
 	{
 		var num = parseInt(formField.value,10);
 		if (isNaN(num))
 		{
 			alert('Please enter a number for the "' + fieldLabel +'" field.');
			formField.focus();		
			result = false;
		}
	} 
	
	return result;
}


function validDate(formField,fieldLabel,required)
{
	var result = true;

	if (required && !validRequired(formField,fieldLabel))
		result = false;
  
 	if (result)
 	{
 		var elems = formField.value.split("/");
 		
 		result = (elems.length == 3); // should be three components
 		
 		if (result)
 		{
 			var month = parseInt(elems[0],10);
  			var day = parseInt(elems[1],10);
 			var year = parseInt(elems[2],10);
			result = allDigits(elems[0]) && (month > 0) && (month < 13) &&
					 allDigits(elems[1]) && (day > 0) && (day < 32) &&
					 allDigits(elems[2]) && ((elems[2].length == 2) || (elems[2].length == 4));
 		}
 		
  		if (!result)
 		{
 			alert('Please enter a date in the format MM/DD/YYYY for the "' + fieldLabel +'" field.');
			formField.focus();		
		}
	} 
	
	return result;
}

function validateForm(theForm)
{
	// Customize these calls for your form

	// Start ------->
	if (!validRequired(theForm.ProductName,"Month"))
		return false;
		
	if (!validRequired(theForm.ProductName,"Day"))
		return false;
		
	if (!validRequired(theForm.ProductName,"Year"))
		return false;
		
	if (!validRequired(theForm.ProductDescription,"News",true))
		return false;
	// <--------- End
	
	return true;
}
</script>

</head>

<body>
<table width="100%" border="0" cellspacing="3" cellpadding="3">
  <tr> 
    <td width="50%" bgcolor="#000066"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><strong>ADD 
      NEWS &amp; EVENTS</strong></font></td>
    <td width="50%" bgcolor="#000066">
<div align="right"><font size="2" face="Arial, Helvetica, sans-serif"><a href="mainmenu.asp"><font color="#FFFFFF">Return 
        to Main Menu</font></a></font></div></td>
  </tr>
</table>
<form action="addnews2.asp" method="post" name="add" id="add" onSubmit="return validateForm(this)" >
  <table width="100%" border="0" cellspacing="3" cellpadding="3">
    <tr valign="top"> 
      <td> <p><font size="2" face="Arial, Helvetica, sans-serif"><strong>Month: 
          <select name="month">
            <option value="1">1</option>
            <option value="2">2</option>
            <option value="3">3</option>
            <option value="4">4</option>
            <option value="5">5</option>
            <option value="6">6</option>
            <option value="7">7</option>
            <option value="8">8</option>
            <option value="9">9</option>
            <option value="10">10</option>
            <option value="11">11</option>
            <option value="12">12</option>
          </select>
          Day: 
          <select name="day">
            <option value="1">1</option>
            <option value="2">2</option>
            <option value="3">3</option>
            <option value="4">4</option>
            <option value="5">5</option>
            <option value="6">6</option>
            <option value="7">7</option>
            <option value="8">8</option>
            <option value="9">9</option>
            <option value="10">10</option>
            <option value="11">11</option>
            <option value="12">12</option>
            <option value="13">13</option>
            <option value="14">14</option>
            <option value="15">15</option>
            <option value="16">16</option>
            <option value="17">17</option>
            <option value="18">18</option>
            <option value="19">19</option>
            <option value="20">20</option>
            <option value="21">21</option>
            <option value="22">22</option>
            <option value="23">23</option>
            <option value="24">24</option>
            <option value="25">25</option>
            <option value="26">26</option>
            <option value="27">27</option>
            <option value="28">28</option>
            <option value="29">29</option>
            <option value="30">30</option>
            <option value="31">31</option>
          </select>
          Year: 
          <select name="year">
            <option value="07">07</option>
            <option value="08">08</option>
          </select>
          </strong> </font></p>
        <p><font size="2" face="Arial, Helvetica, sans-serif">Line Breaks = &lt;br&gt;</font></p>
        <p><strong><font size="2" face="Arial, Helvetica, sans-serif">D</font></strong><font size="2" face="Arial, Helvetica, sans-serif"><strong>escription:</strong><br>
          <textarea name="News" cols="45" rows="10" id="textarea"></textarea>
          </font></p>
        <p><font size="2" face="Arial, Helvetica, sans-serif"> </font><font size="2" face="Arial, Helvetica, sans-serif"> 
          </font></p></td>
    </tr>
    <tr valign="top"> 
      <td><div align="left"><font size="2" face="Arial, Helvetica, sans-serif"> 
          <input type="submit" name="Submit" value=" Save  &amp; Continue">
          </font></div></td>
    </tr>
  </table>
</form>
</body>
</html>

but i think everything is allright in this page

Search
Search in:
Show Threads Show Posts
Advanced Search

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)