thanks for the quick reply,
i had more then 5 arrays , of which one was named location,
i renamed this to locationn.It worked.
Thank You So Much.
crs27
Last Activity: Dec 27 '10, 06:16 AM
Joined: Jul 25 '07
Location:
-
array declaration not working in firefox
Hi,
I Have the below declaration of an array
var latitude = []; which is working in IE but the same is not working in Mozilla.
i changed it to var latitude = new Array() ;
var latitude = new Array(10).But none is working .
Weird thing is it is hitting the server many times sort of infinite loop.If i remove the above declaration the page is at least displayed. -
How to send SMS over/using GPRS MODEM
hello,
I'm working on a tracking application,whe re im currently sending SMS through GSM MODEM.
To make the application cost effective,i want to implement the same either through GPRS modem
or any other equivalent. Their is a need about 8000-10000 messages to be sent in a day.
I want to cut down this cost.
Thanks in advance -
Google Map API - adding infoWindow to a marker
Hai All,
In my application i hve a MarkerManager with markers greater then 1nos.
On click of any marker i want to display the info window.Im not getting how to add GEvent.I want the info window to be displayed on click on the marker .
here is the code snippet
...Code:mgr = new MarkerManager(map); mgr.addMarkers(getplotMark(count),0); function getplotMark(n){ var batch = -
Close pop up when the browser is closed.
Hi all,
My application comprises of multiple menu's.In one menu i have a functionality where a pop up is created.I want this pop up to be close , if the user either logs off or closes the browser.I'm able to close the pop up,if i'm in the the same page where pop up was created,if i'm in some other page i.e, some other menu the browser is closing but the pop up is still present.
Thanks in advance.
CRS -
Date time Diff
Hai All,
I wanted to know how can i get the difference between two Timestamp using some function in mysql and write a query.
For eg:i have from date time = 01/01/2008 01:00:00
to date time = 01/05/2008 19:00:00
result is = 4 months 18 hrs
How do i get the difference i wanted that in year,days,hours ,min? -
I too have no idea about Session Management, give me some reference links that would help me out.Leave a comment:
-
Log4j-multiple log files
Hai All,
I would like to use multiple appender in my application.i.e , i want to write info messages to one log file ,while i want to write error messages to other file.
Im using xml file, with dailyfileappend er class.I would also like to know how can i clear the log files after a certain period.
Thanks in advance. -
Yes, it is a part of a transaction.But what i wonder is even if i execute the same query in Mysql Query Browser also it is giving the same exception.
Im using Mysql 5.1
Query Browser MySql Query Browser 1.2.12Leave a comment:
-
Lock wait timeout exceeded; try restarting transaction
Hai,
I have a simple query fired on click of a button.
i.e., update table_name set column1='20' , column2='15' where id='1';
Even through the query browser it is giving
Lock wait timeout exceeded; try restarting transaction ,this exception.
The same was working a couple of days before.
what might be the reason for this exception.
Thanks in advance -
thanks again atli.Shal follow the same.Leave a comment:
-
thanks for the reply Atli.
I realized that,but i did not want to add 12 in my logic and then to make it 24 hr time.
Is their any other way that i get 24hr time in the query itself.Leave a comment:
-
Truncated incorrect time value: '1:05 AM'
Hai All,
This is my create statement
[code=mysql]
CREATE TABLE `dbname`.`table name` (
`vh_id` int(10) unsigned NOT NULL,
`gh_utc` time NOT NULL,
`gh_mydate` date default NULL,
`gh_serverdate_ time` timestamp NOT NULL default CURRENT_TIMESTA MP,
KEY `FK_geo_gpsdata _2` (`vh_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;[/code]
when i query this table im getting "Truncated... -
Im getting the above same error.
The syntax for the trigger is same as above.Checked with delimiter begin and end.
The same trigger is working fine ON Windows Mysql Query Browser 1.2.12
but when i use the same on Linux EL4 its says syntax error 1064.
Awaiting for reply.
Thanks in advanceLeave a comment:
-
MySql 5.0 - Trigger with Bussiness Logic
Hai,
I would like to know if i can include bussiness logic in Trigger.
For Example:
On a insert/update on a table(primary) i want to insert values to other table(secondary ).
A insert is done on a primary table only when their are no records present w.r.t the id .If the id is present in the table an update action is performed.
I will have to check if the id is present or not.But not... -
thanks for the reply ....Leave a comment:
-
Too many connection
Hai,
I would like to know to how to increase pool(Connection s) size in Mysql Adminstrator Browser.
Im getting "Too many connections.. Connection Timed out"
Thanks in advance. -
Mysql - Triggers
Hai All,
How can i know if a table is associated with a trigger.Can i get the trigger name by any means?
I would also like to know what is the syntax for creating a trigger,which comprises of a if condition.
Is it something like an administrator only can create trigger or can he give permission for the root user to create one.
Thank You. -
it did nt help me much..
as the example their the field was of datetime.But my sinario is different i was to get records between a datetime range and tht particular field is of String datatype.
i wrote a query something like this
SELECT * from vts3 where convert(datetim e,dubaidatetime )between '31-03-2008 01:00:00' and '02-04-2008 01:00:00'
its giving me an exception
Error code 242, SQL...Leave a comment:
-
thanks for the help..
Shal get back if still got problem...Leave a comment:
No activity results to display
Leave a comment: