|
|
Browse by Tags
- 1
- 2
- access
- all
- avg
- batch
- blank
- byte
- cells
- character
- column
- columns
- conditional
- cpu
- crystal
- cursor
- database
- date
- days
- db2
- directory
- display
- distinct
- duplicates
- excel
- expression
- field
- file
- files
- Filter
- folder
- formula
- function
- get
- group
- having
- incorrect
- informix
- join
- jsp
- left
- limit
- line
- loop
- lotus
- maximum
- month
- MS
- mssql
- multiple
- mysql
- notes
- number
- occurrences
- open
- oracle
- page
- per
- perl
- php
- query
- record
- records
- recordset
- report
- reporting
- reports
- row
- rows
- running
- script
- select
- server
- services
- slow
- specific
- sql
- SQL Server
- string
- sum
- sybase
- syntax
- table
- tables
- times
- total
- unique
- unread
- using
- value
- variable
- vba
- veritas
- Weekday
- word
- words
- xpath
- xslt
- year
- zero
-
Invalid Field Count importing data through MyPHPAdmin
Newbie at MySQL, much to learn - please forgive ignorance! Using PHPMyAdmin I'm trying to import data into a MySQL dB on my server. Datafile consists of over 60,400 records and is currently in MS Excel. To check the ORDER of fields in the columns I first exported the existing records from the dB... -
Perl count fetchrow...
Hi World! Actually I have two questions, first one: I have a perl script that does a select from a DB2 database and stuffs the data in a variable like this: -------------------------------------------------------------------------------------------------- $dbh = DBI->connect($dbname, $user, $password... -
Count how many files are in a directory
I am looking for a perl script that can count the number of jpg files in a given directory. Can this be done? What does the script look like? -
XSLT Count() usage
I am writing a simple report given an XML file that is a fax log. In each fax, there is a job code, and I want to give a summary of counts by job code. I cannot figure out how to write that -- all I can manage is a total for all faxes. Here's a sample of the log entries: - - 99999998 123 5551212umber>... -
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... -
Best way to count results (PHP/MySQL)
Which of the following two methods would perform best? /////////////////////////////////////////////// mysql_query $query = "SELECT COUNT(`page`) FROM `book` where `text` like '%$term%'"; $result = mysql_query($query) or die(mysql_error()); if($row = mysql_fetch_array($result)){ $number_of_resutlts... -
count down flash
Hi I found this count down flash tutorial in kirupa at " www.kirupa.com/developer/mx/countdown.htm " I like it a lot but I wish to have a way to edit the time from external file such as txt. Is it possible? Can anyone show mw how to do it to it will take the time from external file (text or... -
MySQL: How to INNER JOIN a COUNT with a SELECT statement
I have two tables. One has a bunch of listings.. One has a bunch of votes.. or views or whatever based on Table A. So Table A has a bunch of listings with Unique ID Numbers. Table B has information about who voted on table A. So there can be 4 entries in Table B, and if they all have the "id"... -
SQL GRoup by having count(*)
Hallo, I would like to select data from a database using 'Select * " based on a value in a row (same column)being unique. By that I mean that that data must not repeat again. Idealy I would like to set the number my self so rather then unique I could say select the rows from the database only... -
How do I get a count in Crystal Reports til the report reads all of the records. I need a loop function in Crystal Reports see inside
i am developing a Crystal Report and I want to be able to provide the following function, but I need help writing this function in VB. groupcountnumber = 0 if( {Command.Status} <> "PRS" or {Command.ACTIONCODE} = "ZDEC" or {Command.ACTIONCODE} = "ZCLO") Then groupcountnumber...