|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| ||||||||||||||||||||||||||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
October 21st, 2009, 06:48 AM
|
|||
|
|||
VBScript - Database - General - Update wont work
hello, im new here, have one big problem,
Code:
// save bigram
foreach(Ngram ngram in m_bigramCharList)
{
cmd = new OleDbCommand("select ID from BigramChar where bigram = @bigram", conn);
cmd.Parameters.Add(new OleDbParameter("@bigram", ngram.Znakovi));
object NgramID = cmd.ExecuteScalar(); cmd.Dispose();
// if there is bigram then update else insert into table
if (NgramID != null)
{
int iNgramID = (int)NgramID;
cmd = new OleDbCommand("UPDATE BigramChar SET bigram_broj = bigram_broj + @bigram_broj, bigram_txt = bigram_txt + @bigram_txt where ID = @ID", conn);
cmd.Parameters.Add(new OleDbParameter("@ID", iNgramID));
cmd.Parameters.Add(new OleDbParameter("@bigram_broj", ngram.Count));
cmd.Parameters.Add(new OleDbParameter("@bigram_txt", BrojZnakova));
cmd.ExecuteNonQuery();
cmd.Dispose();
}
else
{
cmd = new OleDbCommand("insert into BigramChar (JezikID, bigram, bigram_broj, bigram_txt) values (@JezikID, @bigram, @bigram_broj, @bigram_txt)", conn);
cmd.Parameters.Add(new OleDbParameter("@JezikID", JezikID));
cmd.Parameters.Add(new OleDbParameter("@bigram", ngram.Znakovi));
cmd.Parameters.Add(new OleDbParameter("@bigram_broj", ngram.Count));
cmd.Parameters.Add(new OleDbParameter("@bigram_txt", BrojZnakova));
cmd.ExecuteNonQuery();
cmd.Dispose();
}
}
so, problem is that code for update wont work, it seems to be good and i really dont know how else to write it, can someone please help thanks
|
|
#2
October 21st, 2009, 07:15 AM
|
||||||
|
||||||
|
Hi and welcome to the forums
Have you debugged and seen if it goes in IF loop?? Code:
if (NgramID != null)
|
|
#5
October 21st, 2009, 07:26 AM
|
||||||
|
||||||
|
Quote:
 Well to me, query looks good, so it should run or throw any error. I am not fluent in C#, but may be you can try adding some brackets in query like this........ its just a shot in the dark  Code:
cmd = new OleDbCommand("UPDATE BigramChar SET (bigram_broj = bigram_broj + @bigram_broj), (bigram_txt = bigram_txt + @bigram_txt) where ID = @ID", conn);
|
|
#7
October 21st, 2009, 07:34 AM
|
||||||
|
||||||
|
Quote:
|
|
#9
October 22nd, 2009, 04:08 AM
|
||||||
|
||||||
|
Quote:
|
|
#10
October 22nd, 2009, 04:17 AM
|
|||
|
|||
|
ill just try to insert @ID value into blank table to see what is he inserting
only problem and main can be when he found multiple id's id is number of autonumber field of founded bigram (as example bigram = 'as') and when he found multiple bigrams to update that's maybe the problem, i have to save it into other table and then just with querry update those fields  ?
|
|
#11
October 22nd, 2009, 03:12 PM
|
|||
|
|||
|
with text
"hi im new" in textbox im getting values into my table ID JezikID bigram bigram_broj bigram_txt 141 3 hi 1 7 142 3 i 1 7 143 3 im 1 7 144 3 m 1 7 145 3 n 1 7 146 3 ne 1 7 147 3 ew 1 7 on statement Code:
foreach(Ngram ngram in m_bigramCharList)
{
cmd = new OleDbCommand("select ID from BigramChar where bigram = @bigram", conn);
cmd.Parameters.Add(new OleDbParameter("@bigram", ngram.Znakovi));
object NgramID = cmd.ExecuteScalar();
cmd.Dispose();
// ako ne postoji ngram, insert, ako postoji, update...
if (NgramID != null)
{
int iNgramID = (int)NgramID;
cmd = new OleDbCommand("insert into tbl_ID (charID) VALUES (@ID)", conn);
cmd.Parameters.Add(new OleDbParameter("@ID", NgramID));
im getting values ID charID 159 141 160 132 161 142 162 143 163 144 164 145 165 146 166 147 so he founded id's in table but he wont to update 
|
|
#12
October 22nd, 2009, 04:07 PM
|
||||
|
||||
|
I think when you use just add - it's a lot more picky unless you actually specify which datatype it is set to in the database, in the command itself. I've found addwithvalue a lot easier.
Try changing it addwithvalue.... Code:
cmd.Parameters.AddWithValue(new OleDbParameter("@ID", iNgramID));
cmd.Parameters.AddWithValue(new OleDbParameter("@bigram_broj", ngram.Count));
cmd.Parameters.AddWithValue(new OleDbParameter("@bigram_txt", BrojZnakova));
Last edited by Rictor : October 22nd, 2009 at 04:09 PM.
|
|
#13
October 22nd, 2009, 04:14 PM
|
|||
|
|||
|
Code:
cmd = new OleDbCommand("UPDATE BigramChar SET bigram_broj = bigram_broj + @bigram_broj, bigram_txt = bigram_txt + @bigram_txt where ID = @ID", conn);
cmd.Parameters.AddWithValue(new OleDbParameter("@ID", NgramID));
cmd.Parameters.AddWithValue(new OleDbParameter("@JezikID", JezikID));
cmd.Parameters.AddWithValue(new OleDbParameter("@bigram_broj", ngram.Count));
cmd.Parameters.AddWithValue(new OleDbParameter("@bigram_txt", BrojZnakova));
cmd.ExecuteNonQuery();
cmd.Dispose();
im getting this error from compiler Compiler Error Message: CS1501: No overload for method 'AddWithValue' takes '1' arguments Error 1 No overload for method 'AddWithValue' takes '1' arguments and i cant compile project
|
|
#14
October 22nd, 2009, 05:19 PM
|
||||
|
||||
|
Try this:
Code:
cmd.Parameters.AddWithValue("ID", NgramID);
cmd.Parameters.AddWithValue("JezikID", JezikID);
cmd.Parameters.AddWithValue("bigram_broj", ngram.Count);
cmd.Parameters.AddWithValue("bigram_txt", BrojZnakova);
cmd.ExecuteNonQuery();
Last edited by Rictor : October 22nd, 2009 at 05:27 PM.
|
|
| Viewing: ASP Free Forums > Programming > .NET Development > VBScript - Database - General - Update wont work |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
