Avaliar uma noticia....

[Pachevisk 3]

seguinte to com um erro aqui q já tentei de tudu e não consegui.... o erro é esse

UPDATE links SET rating = 9,67, votes = votes+1 WHERE linkid = 5

 

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

 

[Microsoft][ODBC SQL Server Driver]

Line 1: Incorrect syntax near '67'. 

 

funciona assim o cara vota na noticia...

<select size="1" name="rating">			<OPTION value="0"><%= LV_pnorat%></OPTION>		  <option>10</option>		<option>9</option>		<option>8</option>		<option>7</option>		<option>6</option>		<option>5</option>		<option>4</option>		<option>3</option>		<option>2</option>		<option>1</option>	  </select>		<input type=submit name="submit" value="<%=LV_rbutton%>">

e depois é feito um update assim .....

			if NOT addreviewwoa = 0 then				if cint(Request.Form("rating")) = 0 then					objConn.Execute "UPDATE links SET posts = posts + 1 WHERE linkid = "&funcb				else					objConn.Execute "UPDATE links SET rating = "& Round(((linkRec("votes") * linkRec("rating")) + Request.Form("rating"))/(linkRec("votes")+1),2)_							&", votes = votes+1, posts = posts + 1 WHERE linkid = "&funcb				end if			else				if NOT cint(Request.Form("rating")) = 0 then					Response.Write "UPDATE links SET rating = "& Round(((linkRec("votes") * linkRec("rating")) + Request.Form("rating"))/(linkRec("votes")+1),2)_										& ", votes = votes+1 WHERE linkid = " & funcb										objConn.Execute "UPDATE links SET rating = "& Round(((linkRec("votes") * linkRec("rating")) + Request.Form("rating"))/(linkRec("votes")+1),2)_										& ", votes = votes+1 WHERE linkid = " & funcb				end if			end if			if funcc = 0 AND addreviewwoa then							objConn.Execute ("UPDATE links SET threads = threads + 1 WHERE linkid = " & funcb &";")			end if			func = "revlist"		else			if funcc = 0 then				func = "revpost"			else				func = "revresponse"			end if		end if	end if

o erro é sempre na hora da soma do segundo voto... alguem ai pra da uma sugestão, ajuda...??

[Pachevisk 3]

uuppp.... alguem??? http://forum.imasters.com.br/public/style_emoticons/default/assobiando.gif

[PedBolo 0]

acontece que tem uma virgula 9,67

 

esse eh o erro... substitua por ponto (.)

[Pachevisk 3]

valeu PedBolo mas substitui por (.)e da erro (linkRec("votes")+1),2)_-----------------------^se substituir por ponto ....... ele pede ")"....como faço entaum ???

[joacatito 0]

'objConn.Execute "UPDATE links SET posts = posts + 1 WHERE linkid = "&funcbresponse.write "UPDATE links SET posts = posts + 1 WHERE linkid = " & funcb & "<br>"				else'objConn.Execute "UPDATE links SET rating = "& Round(((linkRec("votes") * linkRec("rating")) + Request.Form("rating"))/(linkRec("votes")+1),2)_							&", votes = votes+1, posts = posts + 1 WHERE linkid = "&funcb"UPDATE links SET rating = "& Round(((linkRec("votes") * linkRec("rating")) + Request.Form("rating"))/(linkRec("votes")+1),2)_							&", votes = votes+1, posts = posts + 1 WHERE linkid = "&funcb&"<br>"				end if			else				if NOT cint(Request.Form("rating")) = 0 then					Response.Write "UPDATE links SET rating = "& Round(((linkRec("votes") * linkRec("rating")) + Request.Form("rating"))/(linkRec("votes")+1),2)_										& ", votes = votes+1 WHERE linkid = " & funcb					'objConn.Execute "UPDATE links SET rating = "& Round(((linkRec("votes") * linkRec("rating")) + Request.Form("rating"))/(linkRec("votes")+1),2)_										& ", votes = votes+1 WHERE linkid = " & funcb"UPDATE links SET rating = "& Round(((linkRec("votes") * linkRec("rating")) + Request.Form("rating"))/(linkRec("votes")+1),2)_										& ", votes = votes+1 WHERE linkid = " & funcb & "<br>"				end if			end if			if funcc = 0 AND addreviewwoa then			'objConn.Execute ("UPDATE links SET threads = threads + 1 WHERE linkid = " & funcb &";")"UPDATE links SET threads = threads + 1 WHERE linkid = " & funcb &";<br>"			end if			func = "revlist"		else			if funcc = 0 then				func = "revpost"			else				func = "revresponse"			end if		end if	end if

Assim, você vai printar na tela os comandos... Posta aqui para tentarmos te ajudar melhor...

Outra coisa: Qual é a linha 67?

 

Grato.

[Pachevisk 3]

galera já ta resolvido.....

fiz um replace ali.....

e ta blza....... valeu mesmuh http://forum.imasters.com.br/public/style_emoticons/default/clap.gif

até o próx... erro.... hehe