[table] Forum Topics

Hello, anyone has an idea of how to use php to check to see if a field in a mysql table is empty or has no values? i tried this $query="SELECT fieldId FROM table WHERE fieldName IS NULL" ; but this works only if the field in the table has …

hello, I have a simple problem. I need to create a new table "smaller" using the data from an old table "larger" table. When I say smaller I mean it will have the exact structure as the older table but will have only a few records. Now, i know that …

Good afternoon, I have a problem... Else I wouldn't be posting here, right? My quandary is thus: I have an empty table in a database that I want a user to be able to fill. This will occur when employees are replaced for sick leaves, etc. I'd like to be …

Hi i'm using a table adapter.insert() method to add new data to my table and i need to get hold of the id of the inserted row. I've read around and seen that the most popular way to do this is with SELECT @@IDENTITY as Value but im not sure …

Hey everybody, So I though that I understood linked lists and arrays well enough to make a hash table with separate chaining. Theoretically, it seems trivial, but I am getting a runtime error. The error appears to arise from the line head = heads[i], where head is a node pointer …

Hi, How do you use the paragraph <p> </p> tag if you want to use it on an entire table? I tried: [CODE] <p> <table> <tr> <td> Content 1 </td> </tr> <tr> <td> Content 2 </td> </tr> <tr> <td> Content 3 </td> </tr> </table> </p> [/CODE] But it did nothing... …

Hey all, I'm implementing a hash table for a spell checker and need some assistance on vector const_iterator - at least I think that's where the problem lies. Can anyone assist in diagnosing how to fix these compiler errors? I initially got this error, which i think will come back …

Hi, Say for example I have a page with 100 includes. How would I reload just one of them? Say I ran an ajax script that did certain tasks on the server side, but I didn't want to display the information by setting it in the ajax script - Instead …

This is a program which declares two vectors of 6 elements each of type double. One vector is named weight and the other is named rate. The program uses a loop to prompt the user for a weight in ounces and a postage rate for that weight and then stores …

I'm new to C# and am having a problem with databases, specifically updating a table with dataset contents. No exceptions are being thrown, the update method tells me one row is affected but there is nothing in the table! Code below, your help is appreciated. [code=c#] RSSDataSet.NewsItemRow newRow = rSSDataSet.NewsItem.NewNewsItemRow(); …

take a look here [url]http://www.gfln.org/default4.aspx[/url] now when u click on radio button 1(from 1 to 7) it generate 3 <TD> (two have text name and telephone and other have textbox which is server side control)on run time now problem is whne u click on any other radio button say greater …

Hi, Simple question: How do you make a table with 2 columns? On the left column - 1 row On the right column - 2 rows -Without using a nested table. Thanks, Ashton.

I'm looking to re-order a table while keeping the table's id column constant. ie, Links has entries in no particular order, whereas LinksPopular is a duplicated table but I want it ordered by category X, while leaving the id category unchanged. That way the first most popular is at id …

Hi, How do you text-wrap something like this: [CODE] <table width="10%"> <tr> <td>IWANTTHISLINETOBEBROKENWHENITREACHESTHEENDOFTHECOLUMN</td> </tr> </table> [/CODE] Thanks, Ashton.

Hello everyone, I am a beginning programmer using XSLT. I work at a company wich has a database witch generates catalogs, exporting XSL and XML to FOP.(wich converts to PDF). the program runs on apache and is build in delphi. That being said, I was wondering if it is possible …

Hi, I'm trying to write a script where I can click an image to hide a table, then hide the table and change the image. Then if I click the image again, it should show the table and change the image to the initial image. Below is the code I …

Hi, am currently trying to create a social networking website but I am having problem with the AJAX part... All i want to do is have a form to both insert the data in my database and to add this data dynamically to a table below it, thus each time …

Okay, so I have 2 tables, mos_users & mos_tempban . mos_tempban contains 2 columns: ID & lastvisitdate (last one is not so relevant) mos_users contains 13 columns, only 2 importent: ID & block What I am trying to do is: I want to set Block = '1' in mos_users where …

hi i need an vb.net program for access database, in an sql query for append (single column) .txt file into existing .mdb table , i used this code but is not working [CODE] Pth2 = My.Application.Info.DirectoryPath STTConn2.ConnectionString = "Provider=Microsoft.jet.oledb.4.0; Data Source=" & Pth2 & "\LugatWordsOk.mdb; User Id=admin; Password=;" STTSql2 = …

I have a table with ~10,000 records. There is a "viewed" column which contains either 0 or 1. At some point in my code I want all rows = 1 for the "viewed" column. Does it matter if I set all rows to 1 or set all rows to 1 …

I am trying to make a reference program that you can use to access any element of the periodic table based on its name, symbol, atomic number, or atomic mass. It is more than one file, and I need a way to return to main if the user wants to. …

hi! I would some advice or guidance to create a timetable or schedule [URL="http://www.dentistry.usyd.edu.au/upload/timetable_example.jpg"]like this[/URL]. the data i am pulling from my db are: Begin and end time of courses, course names and day of the week. Also I would like a notification of when 2 courses overlaps. for example: …

I have a table like below format. [CODE] CREATE TABLE Customer ( number VARCHAR(40) NOT NULL, --col 1 name VARCHAR(100) NOT NULL, --col 2 ssn VARCHAR(50) NOT NULL, --col 3 age INTEGER NOT NULL, --col 4 ) [/CODE] I want to add a new column in the table. If I …

Here is what i have a problem with. I need to display variable inside of an html table if the variable's are not empty from a form on a previous page. When the form is fully filled out it isn't displaying any of the table at all. Please help. [code] …

I a table that I have added the function to be able to sort, it works, but it is coming up with an errors: Notice: Undefined index: sort in C:\wamp\www\test stuff\test.php on line 25 Notice: Undefined index: sort in C:\wamp\www\test stuff\test.php on line 28 Notice: Undefined index: sort in C:\wamp\www\test …

I have a mysql table full of pictures(their path) that are owned by many different users. I need to run the following query and return the results into a 5 column table. The number of rows will be however many it takes to display all the pictures. My query is …

Hi! I'm looking for a way to search and replace certain strings in a database table I have. Those are the commands I execute now from within phpmyadmin: [CODE]UPDATE `feeds` SET `title` = REPLACE(`title`,"ă","a") UPDATE `feeds` SET `title` = REPLACE(`title`,"î","i") UPDATE `feeds` SET `title` = REPLACE(`title`,"ÅŸ","s") UPDATE `feeds` SET `title` …

Adding excel data into hash table: [CODE] Hashtable ExcelSheets = new Hashtable(); System.Data.DataTable dt1 = new System.Data.DataTable(); da.Fill(dt1); System.Data.DataRow dr; //System.Data.DataColumn dc; #endregion # region adding excel file into hash table if (dt1.Rows.Count > 0) { for (int c = 0; c < dt1.Rows.Count; c++) { // if (c > …

I want to add first two columns of excel file into hashtable.. I wrote following code but it is giving me eror saying indexing not allowed in datacolumn... [CODE] Hashtable ExcelSheets = new Hashtable(); System.Data.DataColumn dc; // adding excel file into hash table if (dt1.Columns.Count > 0) { for (int …

This is stumping me...it's probably pretty obvious, but I'm working under medication for the flu... I finally got my form submitting to my database and to separate tables from the update.php script. Problem is, (I know this sounds trivial and I shake my head as I query) I can't get …