[table] Forum Topics

Ok...this is my "HELP ME! HELP ME!" thread.:D I finally got my code to work...almost. The form posts to my database but only the first query data inserts and the last value of the third query. All the form fields are correct and the problem appears to be with my …

i get an error when i try and do this. [code=c] private void button2_Click(object sender, EventArgs e) { DataSet ds = new DataSet(); DBconnect db = new DBconnect(); Global.GlobalVar = textBox1.Text; string Co = new Password('J', textBox1.Text).SetSql(); ds = db.GetDataSet(Co); DataTable dt = ds.Tables[0]; if (dt.Rows.Count == 0) { if …

Can somebody help me what to do to place tables in gui?

Hi everyone, i'm having a hard time achieving this: i have a table inside a form, with input fields ( price, qty, desc, total ( to be updated ), this works as it should with the following javascript: [CODE]<script type="text/javascript"><!-- function updatesum() { document.forms['hours'].elements['onktotal[]'].value = (document.forms['hours'].elements['onkqty[]'].value.replace(",", ".") -0) * (document.forms['hours'].elements['onkprice[]'].value.replace(",", …

I have the following table: [CODE] mysql> describe LEVEL1_CUSTOMER; +---------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+--------------+------+-----+---------+-------+ | CUSTOMER_NUM | char(3) | NO | PRI | NULL | | | CUSTOMER_NAME | char(50) | YES | | NULL | | | BALANCE | …

[CODE]$OrderId = (int) $_REQUEST["OrderId"]; // query one of two $sql = 'select * from mickey.mouse where OrderId='.$OrderId ; $result = mysql_query($sql) or die('Query failed'.mysql_error()); $orderID_Passed =1; echo "test2<br/>"; $numfields = mysql_num_fields($result); echo $numfields ; echo "<br/>"; echo "<table><table cellpadding='4' cellspacing='3' border='1'>"; $orderID_Passed = 1 ; //replace with the request object …

<?php echo "<table>"<table cellpadding='4' cellspacing='3' border='1'>; $query = mysql_query("SELECT orderID, entrytime, advertiser, contactname, contactemail, billingadress, billingcity, billingstate, billingzip, accountexecutive, aeemail, aextphone, accountnumber, contactphone, contactfax, nrirep, nriemail, clientwebsite, clickthroughurl, adelements, campaignreports, additionalinfo, assignedto, workpath, status, submittedby, rev, lastupdate, approved FROM Mickeymouse"); while(list($orderID, $entrytime, $advertiser, $contactname, $contactemail, $billingadress, $billingcity, $billingstate, $billingzip, $accountexecutive, …

Hello everyone, I hoping you can help me. I've got a table that I want to be able to show/hide rows based on what check box is checked. By default, I don't want anything displayed, then if you check a or some of the check boxes you'll see the data. …

hello, i have something like this search:_______ search1:___________ submit btn how can i search for something from the same table in the database considering both search fields? I've tried this code nut it doesn't work. thanks [code=php] if($search == '') { $smarty->assign('Error','Please enter any string!'); $z=1; } elseif($type == 'like') …

How would i change this so it will work. I need to link two tables. but i get an error that says "Join expression not supported". [code=c] case 'N'://Get Jobs //long n = Int64.Parse(Del); SEL = "SELECT Employee.[Employee Number], Employee.[Last Name], " + "[DaySchedule]![Shift Code Monday] AS Monday, " + …

Hi all, I'm developing a graphing application that plots several lines from a protein sequencer that outputs its values in .csv format. I've read the csv into a DataGridView just fine, which is laid out like this: Cycle | A1 | A2 | A3 (all the way up to A12, …

I am looking at a project that will import and modify an XML file and then export it to a table. Currently a flat file table system should be fine. I want to export the modified data to the table and then perform a handful of maths(largely simple statistical functions) …

Hello all, I need to find all the records of one table that relate to ALL records of another table. I was thinking that I can check to see if a two tables are equal (via sub-selects). Is there a way to compare tables in SQL or is there an …

I am new to SQL query. I would like to join two SQL queries (MS Office Query and Computer Details Quer) into one. The tables output can be found at [URL="http://rapidshare.com/files/412276985/SQL_query.zip"]http://rapidshare.com/files/412276985/SQL_query.zip[/URL] Or, from [email removed] Thanks for your guidance, below are the query: 1) MS Office Query: ================ [CODE]select v_Add_Remove_Programs.DisplayName0 …

Hi i have data in a mysql table which is about 70000 rows. In one column there is information that I would like to split into 2 rows. The information I want to send over to the other named row is nicely sat in brackets eg (18) . It is …

Hi Friends, I have a question in tables, what is frame attribute in the table tag

Hi How can I transfer some tables created in a database in MySql on my computer to a friend's computer. I have sent to my friend the tables stored in C:\ProgramData\MySQL\MySQL Server 5.1\data\mydatabase folder via email. But when it is pasted in the same location in another computer, it isn't …

Please can somebody help with this. I want a Buy Now image to go to the producturl in the database, at the moment I am just echoing , so it only shows the text of the url in the cell. my code currently is [code=php]echo $row['ProductUrl']; echo "</td></tr>"; [/code] Hope …

Hey.. i'm making a java program with derby databse usin netbeans.. the problem is that when i crate table usin a sql query,netbeans automatically sort them by name..how can i let netbeans sort them by date of creation so i can switch between tables in order of creation??... thx for …

Hi all, I'm having some problem with my codes. I have a output that is generated into a txt file. Now, I need to read the txt file and convert the output into something else. This is the output that is store in a txt file: VAL LEU SER PRO …

To view this tutorial with notes at [URL="http://www.effectivewebdesign.co.nz/tutorial.php"]http://www.effectivewebdesign.co.nz/tutorial.php[/URL] yes I am aware this is more php than mysql. howerver I get asked how to do it so often I thought I'd post it here aswell :)

I'm new to using Temporary Tables in PHP/MySQL. I wrote a very simple test script just to see if it would work, but the SELECT query is giving me a [B]mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given[/B] error on the last line, and I'm not sure why. $dbc …

Hi I am using SQL express 2005 and I need to be able to take old data (data inputed two weeks ago or older)from a table in data base A and move it to a table in database B. I have very little experience with SQL so any suggestions will …

Hello, So here is the story: I'm trying to select from two diferend tables ( bank_wire and visa) [CODE]CREATE TABLE IF NOT EXISTS `bank_wire` ( `id` smallint(6) NOT NULL AUTO_INCREMENT, `method_name` char(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Bank wire', `checked` smallint(1) unsigned NOT NULL DEFAULT '1', `commision` char(255) COLLATE utf8_unicode_ci …

Any way I can remove the additional borders created when I nest a table? Here is the code I am using. [CODE]<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <style type="text/css"> #leftcolumn { width: 72px; height:120px; float: left } #leftcolumn img { width:100%; height:100%; } #rightcolumn { …

I need to GetThe Dynamic Values of Row1 Row2 Row3 Etc. My Code enter code here <script type="text/javascript"> $("document").ready(function(){ $(".addComment").btnAddRow({rowNumColumn:"rowNumber"}); $(".delRow").btnDelRow(); }); </script> <table border="1" class="autoTable"> <tr><td>Your Name</td> <td>Your Age</td><td> </td> </tr> <tr><td> <input type="text" id="wonder" size="25"/> </td> <td><input type="text" id="good" size="25"/> </td> <td><input type="button" value="Delete" class="delRow"/> </td> </tr> <tr> …

I want to fill a Table quick. I have tried something but its not working. Here is my MSSQL-Script: [code] CREATE FUNCTION [dbo].[fillTable] ( @Amount INT ) RETURNS @Integers TABLE ( [IntValue] INT ) AS BEGIN DECLARE @Counter INT SET @Counter = 0 WHILE @Counter < @Amount BEGIN INSERT INTO …

As I told before here is second implementation of one word anagrams, which prepares lookup table for all available words, if it is not generated and afterwards uses it for fast lookup. The implementation of lookup table generation is quite unoptimized, but it is only done once per vocabulary. If …

A lot of web developers are strongly opinionated that divs should be used for design and tables for tabular data, but I am still not entirely convinced that website designers should jump on it yet. I haved designed web sites using both, and in my experience I have found that …

Hello everyone. I am building a web application having various tables and 4-5option buttons in each table. When user check on one of these option buttons then the option is saved at server. I want whenever user returns the option marked by him earlier should be preloaded. For example if …