understanding idate....

Seeking ur advice once again...I'm trying to test the result of the query below as I am not getting the expected 24hrs in the result but only from 00:00 to 20:00 hrs.but when I test the select statement and comment out the line AND TRUNC(OMIP_RAW.DATETIME)=IDATE I get the result containing all 24hrs ...

sphinx newbie on windows, php, mysql

i'm newbie on sphinx world, and recently after reading some blogs and tutorial here, ican install it smoothly. i use windows xp, php5 and mysql5.there is small problem i found, that sphinx does not return the whole column in resultset. here is the print_r of the results set:Array(    ...

MySQL UNION queries between seperate databases

folks, I have a large SQL statement that combines tables from a number of seperate databases. The problem is that it still groups by database even though I want to to group all database results together so... select customers.partner, count(customers.partner) as sales from digiweb_wireless.customers ...

Not really sure whats up

Well not really sure whats up. Heres the problem. IF one person uses the exit exchange code. And in the window that pops up if that member is using the exit exchange code and so on.I get like an infinate loop or something happening that does not stop.I have beat my self in the head over this and eve ...

MySQL date_format() when group by date with rollup

This has me confused. A query like this: SELECT concat(date_format(wi.idate,'%D %b'),' - ',sec_to_time(wi.itime)) as label, avg(wi.itime) FROM workouti wi WHERE wi.wid=7 GROUP BY wi.idate WITH ROLLUP will return the formatted date of each record concatenated with the sec_to_time() of the NEXT rather ...

pab: error while writing date into db2e

(for development i use the db2e personal application builder 7.1.1)my table contains a column ID (char(10)), a column name (varchar(20)) and a column idate (date).the input field for the date is filled by the pab-functions for getting the actual date. (the right date is shown during the test of the ...

Compare 2 lines in a mysql db

The data comes from a custom data base, that our accounting software uses, that I have imported into MYSQL so I can run reports and use the info. it lay out is as followsTYPE - Order or invoiceDOCNO - Order number or Invoice numberORDERNO - Order NumberODATE - Order DateRDATE - Delivery DateIDATE - ...

MySQL using AS 'name' on WHERE clause to filter entries

i tried to left join table feed_logger on whitch there COULD be an entry with date column, if there is not, i have declare an IDATE on the begining of the select using IFNULL in hope there i can use it on where clause to filter rows that are no longer than 1 day old but i cannot to do so by comparin ...

Date calculation is not deleting members

HiI'm working on a script so that users sign up to my website they have to validate there e-mailaddress before they can go to the next step in there registration.I setup a prepared_members table in Mysql and when they click the e-maillink they get auto-erased out of the prepared_members table.All wo ...

understanding delete query

HiCould someone please help me understand how 'IDATE' is being used?DELETE FROM SCHEMA.TABLE WHERE DATETIME BETWEEN TO_DATE(IDATE,'DD-MM-YY') AND TO_DATE(IDATE,'DD-MM-YY')+1-1/1440; I tried SELECT SCHEMA.TABLE WHERE DATETIME BETWEEN TO_DATE(IDATE,'DD-MM-YY') AND TO_DATE(IDATE,'DD-MM-YY')+1-1/1440; b ...

Struct with variable length arrays of struct

I need to create a data structure of data structures, but I can know "how many structs I need" only at runtime.typedef struct tagPredefinedStruct{int iSize;int iCount;} PREDEFINEDSTRUCT;int x;x = GetNumberofStructs(); //x is known only at runtime.typedef struct APIStruct {int iNumber;PREDE ...

o Check requests from same machine continously

What is wrong with this code ? If a person clicks on a link before the 10 seconds are finished counting down to 0, they are redirected to a error page. Problems is, it seems to work just once, if i go back and click link again i dont get error page and i should, I dont think it is checking the datab ...

SQL Join Error

I am getting a bit stuck on the following sql string, I have an asp classic web page connected to an access 2007 database. I am trying to get the totals from a query called qrycondetailsextended totals, the fields I want from there are sumofextended price, perhaps sumofquantity too but most importan ...

Cast function in mysql

Helo everybodyHow to convert database type from datetime to varchar? and decimal to varchar?Can I use this code?Quote ... CAST(now() as varchar(20)) I use MySQL version 5.0.21Other question:If I execute procedureQuote ... CREATE PROCEDURE `formatdate`(dtDate datetime)BEGINSELECT date_format(now(),'% ...

Pivot Tables using SQL

I need some help in writing an SQL script that would convert the results into a pivot table in Toad. I am extracting data from an Oracle database.I need to have each post date as a column header from the SQL below:select ca.ACCOUNT_ID, cd.CLIENT_NAME, od.post_date, sum(oi.PRICE)from order_details od ...

Help me plz File not Found yet file is there

I have created a Program that first searches and returns the contents of a file into a richedit then opens up the next file finds the matching record and displays that in the rich edit and then the same again with another file.My problem is that when i search it displays an EinOut Error File Not Fou ...

Need help with print monthly calendar function

I'm trying to print out a monthly calendar, but it's only printing out 6 days and not even accurately... I've been through a number of times, but I think I'm just flatout not seeing something... Here's the code:function last_day($month, $year) {return mktime(23, 59, 59, $month + 1, 0, $year);}functi ...

at all who want to manipulate the date

at all who want to manipulate the UNIX-Date backwards or forwards.Move the attachment to idate.sc and give x permissions to the file.The script idate.sc works from 01.01.1900 since 31.12.2099.On commandline insert "idate.sc dd.mm.yyyy" and you get the days since 01.01.1900.or "idate.s ...

Email validation using java script

I need to validate the email address when submit the form using java script. When I enter one email address i have to val;idate the mail id. But at the same time I have entered multiple email address seprated by comma . I unable to validateHow can i validate the multiple email address when i click o ...

.Net Connector 6.0.4 SELECT command denied to user for table 'proc' error

The storedprocedure bug is still present? I'm not able to retrieve storedprocedure data with the 6.0.4 version. <asp:SqlDataSource ID="ds_periodicalspot" runat="server" ProviderName="MySql.Data.MySqlClient" ConnectionString="<%$ ConnectionStrings:LocalMySQLSe ...

MySQL result->getString() no longer works with datetime data types

I recently upgraded to C++ Connector 1.1.0 from 1.0.5. My code mostly still works, except I needed to change some std::string variables into the new sql::SQLString data type. One table I am retrieving data from has a datetime type. In 1.0.5 I used to retrieve this data as a std::string, then convert ...

How to add a data into existing record(s)?

My problem is that...I've a temp table which construct with 6 fields.Four of them will filled once.After that the last two field will be fill after a checking process.Those fields are IDate and IRefNo.Every records of that table have the same IDate and IRefNo. ...

convert int into string

just trying to convert the int into CStringsince I don't know how. I convert it into char* first ,then CString(pChar)when I went to itoa(iDate, pChar,2), it throws an access violation exception. No idea why . Help?code: char* pY="a";int iDate=2001;itoa(iDate,pY,4);//this is where the error ...

Howto create a cronfile??

I created a file to keep my db clean, but cannot get it to work.Someone told me to use it as a cron file, so it gets activated by time or so.I named the file scheduler.php and here is the code.Do i have to change something in this or is there another way to get it to work?ThxMarc #!/usr/bin/php -q ...

recurring schedule records for specified day of week...

I am using the code below to generate recurring schedule recordsiDate is a Start Date while EndDate is an endingdateif iDate = 2/16/06 - which is ona Thursday and EndDate = 12/31/06 thenI want to loop thru and create a record for each Thursday from 2/16/06 to 12/31/06using DateAdd("d", 7, ...

Recurring Appt on Same Day Each Month

I am using the code below to add recurring appointments to a databaseIt works well when a frequency of 7, 14, or 21 days is selected...It adds a recurring entry for every Mon,Tues,etc depending on the start datewhen I select a frequency of 30 days, ift adds the appointment, but the days may be diffe ...

Problem with Do Statement - Recurring Schedule Entries

I am using the code below to schedule recurring events eother every 7. 14 or 21 daysthe case below assumes it is every 7 daysIf I enter a start date of 5/1/06and an end date of 7/31/06I should get weekly entries until 7/31/06It works well, however. the last entry is dated August, 7, 2006 - which is ...

Dsum #error

I am stumped over DSUM. I have a datasheet subform consisting of a few fields PurchasedQty, ConsumedQty and txtRemain. The subform is bound to tblsubProduct. txtRemain is an unbound field and its control source is =DSum("[PurchasedQty]-[ ConsumedQty]","tblsubProduct","(QtyID ...

MySQL SELECT SUM() Slow

I am runing MySQL 5.0.17 Under Windows XP I have a table INVOICE: DROP TABLE IF EXISTS `xxxxx`.`invoice`; CREATE TABLE `xxxxx`.`invoice` ( `INVNO` int(10) unsigned NOT NULL auto_increment, `CUSTNO` int(10) unsigned NOT NULL default '0', `JOBNO` int(10) unsigned NOT NULL default '0', `IDATE` datetime ...

Access VBA for ordering names that exist as foreign keys

Kind of clueless here, I want to order by company names but in the table they exist as foreign keys and ultimately numbers.I am considering this but I am wondering if it would work?Private Sub Form_Open(Cancel As Integer)Dim Strsql As StringstrSQL = "SELECT tbl_ShipOrders.ship_order_id, tbl_Shi ...

MySQL 5.0.41 Upgrade Problem and Query

Greetings, I have upgraded to MySQL version 5.0.41, my previous version was 5.0.22. To upgrade I did rpm -Uvf <rpm>.My applications and queries has been working fine, but I got a query that now isnt' works and before the upgrade was fine. Here the query: SELECT A.iprovidercod, A.iposcod, A.isa ...

Oracle Vertical Yearly Total...Kindly Help.

Please help me in getting vertical total.I mean the structure likeIcode Jan-02 Feb-02 .... Dec-02 Total Jan-03AA 10 20 .... 10 40 10BB 05 10 .... 30 45 20..I want to have 12 Months total and 13th Month Just qty, the 13th month will be the user entered parameter month.The below statement is just givi ...

Oracle query returning many columns is very slow

I'm using Oracle 8.1.6 on Windows.In my system, I have a query that joins 11 tables and selects about 39 columns from the joined tables. I've included the query text below. Actually, in the run-time environment this query is limited to retrieve only a few rows (about 20) that fit in a web page.The a ...

Please help with code

I recently converted the script below from PHP/FI to PHP 3+. For some reason, I get tons of parse errors when I try to run it on my linux box with the latest versions of PHP, MySQL, and Apache. My other scripts(newer scripts) work fine, but this old script doesn't work. I included the code below and ...

Porting IOC Classes to XL C/C++

We must run legacy codes for an XL C/C++ AIX environment.But, many IOC (IBM Open Class) in VisualAge 5 C/C++ have been used within them. For example, ikeyset.hiseq.histring.hppitime.hppidate.hppitmstamp.hppibase.hpp http://www-01.ibm.com/support/docview.wss?uid=swg27001511&aid=1By above document ...

convert string value to time_t

I do find a lot of information on converting time structure and time value to a string value but I want to achieve the opposite of this. I want to convert a string value to time value in the form of time_t structure. I am unable to get desired results. I am attaching the part of code on which I am w ...

Getting error message " Data type mismatch in criteria expression."

my problem is that When trying to insert a statement into an MSAccess file I get this message: Data type mismatch in criteria expressionBelow are my codes. Im using vb.net 2.0 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.ClickDim sql As String ...

what's wrong in this query?

$query_insert = "INSERT INTO posts(subject,post,userid,catid) VALUES('$subject','$post',1,$catid,'$idate')";mysql_query($query_insert) or die("wrong query!!!"); ...

Email validation using java script

I need to validate the email address when submit the form using java script. When I enter one email address i have to val;idate the mail id. But at the same time I have entered multiple email address seprated by comma . I unable to validate How can i validate the multiple email address when i click ...

day of week(urgently needed)plzzzzzzz

In my code i have to display day_of_week from Monday to Sunday.and as well as I have to display dates of that particular weeek dynamically.here iam highlighting the code that need to modify.please I structed here please help me to overcome this problem.If possible give me some hot code to modify. Da ...

How to change date to seconds?

I have format of date YYYY-MM-DD and qould like to change simple as possible to seconds UNIX time. How to do it?I have tried with $alteredd= time($idate);echo $alteredd;But this is current time...in seconds ...

Super globals?

My hosting company have turned off register globals because of the security risk. I thought my forms would be fine, but now they are not working. Im told I need to change a few bits to Super Globals?... thats where im getting stuck.Ive included the code from one of my forms, below, it just takes the ...

redirect issue

I have a form page that is submitting variables to a page that is to process the info and insert it into a DB. I have a simple IF condition:$idatearray=$_POST["idate"];//Make sure at least 1 date is being postedif (empty($datearray)){header( 'Location: ../msc/msc_errors.php?error=sansdate' ...

Updating ASP.net Profile

Hey. I have created a website that uses aspnetdb. Using this, i'm trying to take advantage of the profile table. I have it working and I can pull info from the logged in user and display it on the page, however, when i try and load the info on another page and get it to update, it will not update. C ...

Ubuntu wine hangs the system in random intervalls

I've installed the latest nvidia drivers from source, the latest kernels from the update and the latest wine from winehq (1.1 something)After random intervalls in e.g. World of Warcraft running under Wine, the whole system freezes and I've to push the reset button to reboot.How can I solve this? (th ...

Oracle XMLDOM.Makenotation: ORA-31183:Node type document cannot be converted...

We have upgraded the database to 10g (10.2.0.1.0) from 9 and are unable to create XML files. An error is occurring when the function XMLDOM.MakeNotation is called, ORA-31183 : Node type document cannot be converted to desired type.I'm not clear on what makenotation does and whether it's needed as wh ...

Oracle collection update

CREATE TABLE D_TALLY(ID NUMBER(8),IDATE DATE NOT NULL,XMLFILENAME VARCHAR2(32 BYTE) NOT NULL,ZIPFILENAME VARCHAR2(32 BYTE),XSLVERSION VARCHAR2(16 BYTE),XML2ORAVERSION VARCHAR2(16 BYTE),TALLYDATA T_UPLOADDATA) Object type :T_UPLOADDATA CREATE OR REPLACETYPE "T_UPLOADDATA" AS OBJECT (uploadDate DATE,n ...

Help with string manipulation

I am writing an application that will automate a phone billing service, but I'm a bit stuck and have been for a few days. I've trawled so many help files that they've all blurred into one so I'm hoping somebody here will be able to help me find my way. So far I have managed to read the CSV file in a ...

Strange date problem

I have the following javascript code (from opensourcecms.com):// global variablesvar gtdiff; // diff between server and local timevar counttime=120; // number of minutes to count down//var counttime=2; // number of minutes to count downvar onesec=1000; // millisecondsvar oneminute=60*onesec;var gser ...

Ubuntu lirc and elisa, from the top

all. I was originally planning to post this on the elisa forums (http://elisa.fluendo.com/forums/) but in the process of doing so I got banned (!), presumably because I was generating load on their already overstrained server. In desperation therefore, I'm turning to you guys to see if you can help ...