|
|
Browse by Tags
- 10
- 10g
- 2003
- 2005
- 2306
- 5
- access
- affected
- all
- alternate
- another
- background
- between
- blank
- cells
- code
- collapse
- color
- cols
- column
- columns
- combine
- comma
- compare
- concatenate
- concatenating
- convert
- copy
- count
- create
- crystal
- csv
- data
- database
- dataset
- date
- db2
- delete
- deleted
- duplicate
- eliminate
- excel
- exclude
- expand
- exporting
- extra
- fetch
- fields
- file
- find
- finding
- first
- flatten
- form
- from
- get
- getting
- hidden
- hide
- how
- import
- insert
- javascript
- join
- limit
- loop
- macro
- many
- maximum
- more
- multiple
- mysql
- number
- one
- oracle
- php
- pivot
- query
- remove
- reporting
- return
- returned
- select
- services
- show
- single
- spreadsheet
- sql
- string
- table
- tables
- text
- through
- too
- top
- total
- transpose
- two
- update
- vba
-
Removing space between table rows
How do I remove the spaces between table rows, it seems that the image doesn't take all the td space? -------------------- g" /> .......................... file is .aspx and have tried style="padding: 0px; margin: 0px" on td, tr, form and none worked. I have also tried width and... -
Php Mysql count rows function.
Hi, I have this sql_query code on my message board front page: $amount = mysql_query("SELECT p.*, t.ID FROM posts p, topics t WHERE p.TopicID=t.ID"); $num_rows = mysql_num_rows($amount); and to print it out I have the The 2 tables looks the following way: Table posts: ID int(5) PRI NULL auto_increment... -
Loop through cells in a table row
Is it possible to loop through the cells in a row using javascript? I need to loop through all the given cells in a row and set certain css properties. This is part of a mouseover script hence I am not hard-coding the css into the TD's. The pseudo-code would be something like... for each cell in... -
Inserting multiple rows at a time
Is there a way to insert multiple records in a database in a single SQL statement? I'm running the Insert statements separately to input in the track table. My SQL is below. create table track ( trkid integer, trknum integer not null, trktitle varchar(25) not null, trklength decimal(4,2) not null... -
Updating multiple rows in a single statement
Hey all! I thought I'd have a look at trying to make our update queries more efficient, because our code currently generates multiple update queries when I'd rather just operate on multiple rows at the same time. I've tried both of the revised queries below, because (to me), they seemed to... -
DB2 - Select x number of rows
How can I limit a select statement to x numbers of rows returned. If this was Oracle I could say select * from my_table where ROWNUM to get the first 49 rows. I want to do the same thing with DB2. -
How can i delete blank rows in a text file.
Hi, I want to delete the blank rows in the text file.I dont want to put the data to any other file edit and replace it to the text file.Any built in way or a script to run on the text file to remove blank lines. Regards Sharath -
Query to transpose data in rows into column.
Hello, i have 2 tables, one containing product information (product number, description) and the other containing product details (price by customer). I would like to run a query that display in one row the product information and pricing. Table 1 id Prod_name Description 1 prod1 ipod 2 prod2 key Table... -
Return total row count with LIMIT parameter in MySQL
I am doing some pagination for a web site using MySQL and Java. The SQL I am using is something like SELECT * FROM table WHERE ....... LIMIT 0,10 There Where clause differs depending on some HTML fields which filter the results. I am changing the LIMIT part dynamically so the user can browse through... -
Mailwatch - MailScanner
Hello I have a Fedore Core Yarrow Box EnsimPro 4.01 Installed. I've installed Mailwatch by following the steps mentioned @ http://forum.rackshack.net/showthread.php?s=e37add8b86d5762691507a5925393e3b&threadid=45146&highlight=Mailwatch My question when ever I run my Mailwatch and goes to its...