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 ...
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( ...
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 ...
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 ...
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 ...
(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 ...
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 - ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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(),'% ...
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 ...
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 ...
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 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 ...
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 ...
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 ...
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 ...
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. ...
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 ...
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 ...
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, ...
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 ...
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 ...
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 ...
Im new to sql and access so bare with me. I'm trying to inner join two tables and get rid of duplicate vin #'s in one query. Can this be done?Here is some data I have. I know it's not going to work like this. But can anyone please help???SELECT [ihDinshdr(Old-1-TMIN031920091350)].ih_ibid, [ihDinshdr ...
I'm new to access and I can't get this having clause to work?What i'm I doing wrongSELECT DISTINCT [ih-O-350].ih_ibid, [ih-O-350].ih_vin, [ih-O-350].ih_eqpinit, [ih-O-350].ih_eqpno, [ih-O-350].ih_carrier, [ih-O-350].ih_iaid, [ih-O-350].ih_idtm, [ih-O-350].ih_purpose, [ih-O-350].ih_idate, [ih-O-350]. ...
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 ...
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 ...
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 ...
Well I've been working on this for a while now and part of the problem is that I'm not getting a lot of results searching. Here's where I'm at. I have a table that contains start and end dates in one database It contains a lot of other things too but that's my focus. In another database I've created ...
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 ...
I have a little bit of code, which provides me with two problems.CTime Test = m_iDate + CTimeSpan(30,0,0,0);if (Test < Time::GetCurrentTime()){m_bGo = FALSE; m_strFreeTrial = "Your FreeTrial has ended.";}else{int i = CTime::GetCurrentTime().GetDay() - m_iDate.GetDay() + 30;m_strFreeTria ...
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 ...
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 ...
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 ...
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 ...
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 ...
$query_insert = "INSERT INTO posts(subject,post,userid,catid) VALUES('$subject','$post',1,$catid,'$idate')";mysql_query($query_insert) or die("wrong query!!!"); ...
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 ...
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 ...
I'm working on a script to allow users to upload large (up to about 15MB) binary files to a web server. They are then saved in a DB for later download. Everything works as expected when using small files (say under 1MB). The script is supposed to generate an error message if the file hasn't uploaded ...
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 ...
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 ...
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' ...
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 ...
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 ...