Databases :: Loop Is Failing When Writing To Table?
Nov 16, 2010
My site extracts data from a MS SQL db and then connects to a mySql db which it writes the data to. My site is working properly when connecting to a db in cPanel at a remote website.
However, I have a mysql db also hosted on my site, and I'm connecting to it ok, but the loop is failing. There are 2 tables, one stores the category, and the other stores link data.
For each category
write to the category table
for each link in this category
write to the link table
next
next
The tables are being created, and the very first category is written to the table, but then nothing gets written to the link table.
How can I make this generate an error message? My webhost doesn't know what to do about it and they just want to see an error message.
I tried this once already, and neither of my lines worked:
HttpContext.Current.Response.Write(lnkid & " " & url)
Why doesn't that get written into the source of the page on each iterance of the loop? How do I see the data that isn't being written?
[Code]....
View 2 Replies
Similar Messages:
Sep 29, 2010
I have a table in orcale database where I am inserting records. I am able to insert a record in a table but it is not being saved permenantly.When inserting there is no error. what could be causing this?
View 4 Replies
Aug 5, 2010
I am creating an site where a user uploads an excel file to check if any of the records exist in a database. Then they are returned an excel file with only the records that are NOT in the database.
I was thinking I should do it this way1. User uploads their excel file. The app opens excel file and loads records into a dataset (so far this is working with the code below)2. Using datarow and another function to check if each excel record exists in the database3 If the record does NOT exist, and it is the first record tested, create an excel file called records.xlsx and write the record into the file
4. Check the next record and if it does NOT exist in the database, then check if records.xlsx already exists then open it and write it into it.
[Code]....
Hopefully its clear, sorry if its not, I'm a bit of a novice at this. Is this a good way to do it? Does anyone know of any tutorials that might outline how to open an existing file and write to it?
View 2 Replies
Mar 4, 2011
Want to create a web based application for reading and writing excel files.
Issue :
1. Want to upload an excel file and store it some location.
2. Read data from excel file, performing some sorting and filtering
3. Write filtered data to new excel file.
View 1 Replies
Sep 23, 2010
I am writing to excel file using jet driver. If the length of value exceeds 255 characters i get the below error.'The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data'Please could you provide a solution to how can i add values with length greater than 255. Excel file is 97-2003 format.
System.Data.OleDb.OleDbCommand command = new System.Data.OleDb.OleDbCommand();
View 1 Replies
Sep 30, 2010
I'm trying to delete a bunch of records in mysql. The record info to delete (userid, name) is stored in an arraylist. It seems to only delete the first record and gives an error ("Transaction has already been rolled back or is not pending.") afterwards. I have the transaction commit inside the loop which I think is the issue but not sure how to go further if I bring it outside of the loop. Here's the relevant bits of the code.
try
{
ArrayList alist = new ArrayList();
//alist gets populated with data like (12345,robot)(23456,car) here.
MySqlConnection conn2 = new MySqlConnection(query_connection);
conn2.Open();
MySqlCommand command2 = conn2.CreateCommand();
MySqlTransaction mytransaction;
mytransaction = conn2.BeginTransaction();
command2.Transaction = mytransaction;
for (int i = 0; i < alist.Count; i++)
{
string[] s = alist[i].ToString().Split(',');
try
{
command2.CommandText = "DELETE from users_settings WHERE UserID=" + s[0].ToString();
command2.ExecuteNonQuery();
command2.CommandText = "DELETE from users WHERE ID=" + s[0].ToString();
command2.ExecuteNonQuery();
mytransaction.Commit();
}
catch (Exception e){
mytransaction.Rollback();
}
}
}
catch(Exception e){
}
View 1 Replies
Feb 15, 2010
I think I'm just after advice on best practice with this! I have a database which has 2 tables. The first table has ID, Name, Address and the second table has ID and JobType. Table 02 can list multiple types of JobType so we could have
Table01:
1. D Smith. Address01
2. S.Jones. Address02
Table02
1. Accounts
1. Sales Ledger
1. Chartered Accountant
2. IT
2. Web Design
2. Graphic Design
2. 1st line support
A join gets them together and all works perfectly.However, the content will be updated when some one fills in a web form. Do get the form to send results to both tables, I assume I have to open the database twice or can I open it once and open each table one at a time? I know I could practice this and not ask the question but I am interested to know what is the most efficient way. I would also need to know what ID to use. So when I populate Table02 it uses the correct ID from Table01. At the moment Table01 ID field is incremented automatically. Would you suggest I always assign the ID myself, or would I need to query the database, find out what ID number is currently in use and then increment it by 1 and assign the new number to an ID variable which then populates the Table's Field? In which case, am I opening the database again or trying to perform all 2/3 stages in one go?
View 3 Replies
Jan 15, 2011
I have a table that is not getting updated. My insert command is working fine. Here is the update code from business logic area and stored prodecure. The SP works fine when I execute it from sql mgmt studio and updates the table:
[Code]....
View 3 Replies
Sep 6, 2010
i done one web application in this application i need to transfer the data from one table to another automatically when the time is 10.00PM. i need to write this function sepearte time function not in page load function.the user select any of page the data should be transfer from one to another without page load only using time control function..
View 5 Replies
Jun 7, 2010
I don't understand how the stored procedure is returning false. It's supposed to continue looping and continue writing rows. Right now it writes the very first row, and then it goes into the If Not AdvanceLinkBanned.Add(banrec) Then and it goes in here, prints the message and exits the sub. Why is it thinking the add returns false? If Not AdvanceLinkBanned.Add(banrec) ? Doesn't this return the id of the new record? Isn't this not zero? Zero would make it false. How can this be false? Isn't it supposed to return the next record created ? Doesn't SELECT SCOPE_IDENTITY() return the value of the record id? How do I test this?
[Code]....
View 2 Replies
Jan 21, 2010
I am building a little app to upload a picture and various downloads for different file types for the photos, but I also need be able to select the catergory they will go into. So I have two tables one that stores the catergory names and one that holds the paths to the photos and downloads the tables are related through the catergoryID.
What I need is those catergories to show up in the photo's and downloads table so that when I go to upload the photos I will be able to select the categories.
I have also built the DataSet and the Business Logic.
View 3 Replies
Feb 23, 2010
Having serious trouble inserting data into my db... i am able to select and display data just not write it to the database..
[Code]....
View 1 Replies
Mar 19, 2010
im learning t-sql, infact i needed its while-loop to loop through records of a table, i found this code in some book:
[Code]....
i understand here that setting the rowcount variable to 1 will force the select statements to return only one record, do all above select statements return one record only?
if the underlined select statement returns one record everytime it is executed, isn't it supposed to return the same first record of the table everytime? is there a better way to loop through a table's records?
View 9 Replies
Feb 27, 2011
I have 3 drop down lists on a form that collects data from a visitor.
Each DDL shows a list of Music Genre and the User can make up to 3 choices ( 1 selection from each DDL)
I want to loop through the DDL´s and Insert the GenreId (int) and UserId (Guid) into a Junction Table called
UserGenre which has UserId and GenreId as Primary Keys.
In C sharp - How can I loop through and get each DDL selected value (If chosen) from the form and insert to table?
View 8 Replies
Oct 7, 2010
loop table depending on arraylist and load datagrid?
View 1 Replies
May 18, 2010
Say for example, I have script like below whereby everything is same except the table name and each table name will append an incremental number, is it possible for me to have a for loop to dynamically add the incremental number?
CREATE TABLE Persons1
(
P_Id int,
[code]...
View 5 Replies
Feb 8, 2011
I have a question about asp.net
I have this table with checkbox for each row:
[URL]
table code inside the ASPX page:
[URL]
So I'm trying to implement the delete selected button.. How exactly do i point to the specific checkbox for a particular row from codebehind when all 3 have the same name chkSelected? I know how to do it with a gridview, but not quite sure how if we do it with a for loop..
Can I do something like this inside btnDelete_Click?
[Code]....
View 1 Replies
Feb 26, 2010
What's the best method for looping through a table, grabbing all the data in the cells, but skipping the <th>? Do I put the data in an array?
View 1 Replies
Feb 10, 2010
I am using vs2008, Sqlserver2008.
my table: PostGL having data like thi
AutoIdx TxDate Id AccountLink Description Debit Credit
3 2010-01-22 JL 2 bcb 0 35.09
5 2010-01-28 JL 2 g 3.51 0
select AutoIdx,TxDate,Id,AccountLink,Description,Debit,Credit,(Debit-Credit) as Actual from PostGL where Id='JL' and AccountLink=2
AutoIdx TxDate Id AccountLink Description Debit Credit Actual
3 2010-01-22 JL 2 bcb 0 35.09 -35.09
5 2010-01-28 JL 2 g 3.51 0 3.51
I am trying in view like this
declare @cnt int
declare @i int
set @budget=20
set @cnt= (select COUNT(*) from PostGL where AccountLink=2 )
set @i=1
WHILE (@i<=@cnt )
BEGIN
set @tdebit=??
END
I am taking count the no of rows having AccountLink=2
I need to read all debit,credit and add all debit into totaldebit,all credit into totalcredit independently from table.
then i need to show the totaldiff as Actual.
i need ....totaldiff=totaldebit-totalcredit
View 3 Replies
May 5, 2010
as a php developer ive been told to go the MVC route which ive been trying since yesterday. Im using visual web delveloper 2010 express and im using the MVC template project.Ive basically got a news table in MSSQL Express, in there are these fields ID,(Title,Body,PostedOn,PostedBy) all i wanna do is loop through them to put them on the view.Im after a nudge in the right direction, I want to be able to do a SQL lookup in the controller put that data in a DataTable then run a foreach loop on the table to display this on the view. The problem im getting is I know youre not suppsed to put any HTML in the controller and I cant pass the datatable to the view to do the loop in the view.. so where/how do I do the loop.
View 2 Replies
Feb 27, 2010
I'm working on locking down some MySQL user accounts. At the moment I typically grant my user accounts execute privileges over the required stored procedures within a schema.Now I'm looking at the proc table in the mysql schema. The common wisdom that's quoted many times on various websites says "Stored procedures require the presence of the proc table in the mysql schema".By granting select access over the proc table stored procedures will work. But if I removed the above select privilege and grant the user execute privilege over the entire mysql schema the procedure will also work.
Does anyone have any ideas about the security issues by choosing one of the above over another?I would prefer to lock the proc table down all together so the user cannot see it cannot select from it.
View 1 Replies
Aug 18, 2010
If I use Microsoft.Jet.OLEDB.4.0 to retreive for example named range or sheet from Excel and use it as data source for some server control on the ASP page, everything works fine. But when I try to get table from Excel like this: "select * from [Table1]", debugger complains that database engine could not find object Table1. So how should I reference Table1 in Excel file so that the database engine could find it?
View 2 Replies
Jan 13, 2011
I am using PL/SQL Developer. I have a Table "C_PARTY_HXRF". Now I want see the Column Names and the corresponding Data types of this Table. Which Command should I Use?
View 28 Replies
Sep 9, 2010
I try to work with MYSql (because it's free) and I saw that the colums are different then when they are exployed in MS SQL?
Why is this? The most strange differents is that in MySQL there is no applicationId in the membership table.
This differents in tables cost me more time to do a export and import from MS SQL to MySQL.
View 1 Replies
Jan 17, 2010
I have this table called "students", with the columns :Name, ID, Faculty.
I want to display the info in my .aspx page in such fashion that the columns will appear on the left, the ID on the top, and the data populated properly.
So, basially, should look something like this:
ID 123 234 345 456 567 234 135 135
Name John Erick...
Faculty CS BIo ...
View 1 Replies
