What is the difference between my and local in Perl?
I am seeing both of them used in this script I am trying to debug and the literature is just not clear. Can someone demystify this for me? ...
my
how can i control text box's visible at dropdownlist's selected index change without postback
i have one dropdownlist and two text box When i select an item from dropdownlist, text box1's visible want to be false and text box2's visible want to be true. i don't want to be postback for dropdownlist help me? ...
How to handle foreign key while partitioning
Hello, I am working on fleet managment.I am having large amount of writes on a location table with following coloums 1>date 2>time 3>vehicle no. $>long 5>latitude 6>speed 7>userid (which is foreign key...) Here this table is going to have write operation every 3 sec.Hence there will be millions of record in it. So to ret...
How to change name of table while creating it through Stored procedure...
I want to write a Stored procedure...which will create a table with xyz name ...but when i call the SP for very second time it will give the error bcoz table already exist...I want to take table name as input..and want table to be created with that name... How to archive this..... Asp.net ---My sql ...
Blackberry index search
hello, following is my code for application which takes data from user.displays it in a list. what i am trying to do is if user clicks delete button specified list entry should be deleted. but my index is not returning properly. please help me i am trying it for last two days. import net.rim.device.api.ui.; import net.rim.device.api.ui...
Access virtual folder under My Computer
When I connect my digital camera, it creates a folder under My Computer named Canon PowerShot SD1100 IS. Using the File Explorer, I can browse this folder and its subfolders to access the pictures on the camera. Can anyone tell me how to access this folder and its subfolders programmatically? From within my software, I can drill down i...
What is the default scope of foreach loop in Perl?
In Perl, does using 'my' within a foreach loop have any effect? It seems that the index variable is always local whether or not 'my' is used. So can you drop the 'my' within the foreach loop and still have private scope within the body of the loop? As can be seen, using the 'for' loop there is a difference between using / not using 'm...
declare and assign value my sql stored procedure(5.0.45)
Hi everybody , DELIMITER $$ DROP PROCEDURE IF EXISTS quotations.sp_addservices $$ CREATE PROCEDURE quotations.sp_addservices (In categoryname varchar(25),in servicename varchar(250),in hours float,in cost float,in basis nvarchar (100)) BEGIN insert into categorydetails (Category_Name) values (categoryname); if(categoryname!=null) then ...
sql injection in php
my query written in php is: $sql="SELECT * FROM ".TABLE_PREFIX."login WHERE username ='".$username."' AND password='".$password."'"; $res_id = mysql_query($sql); $num_rows = mysql_num_rows($res_id); echo $num_rows; When i enter a valid user name and password from a form it works ok. When i input some sql injection code the que...
creation of pie and bar charts in php website
HI. I wanted to know if we could create pie and bar charts based on info from the database on a php website. I want to grab some information from the database and show it as an image so better analysis. Is there anyway to do this? Also, If i am using fpdf to generate pdfs from php and mysql, can i also design pie charts in that pdf and ...
Can i set up sql server as master and my sql as slave in replication
Can i set up sql server as master and my sql as slave in replication? I can find only two subscriber ie.Oracle Subscribers and IBM DB2 Subscribers. how to add my sql>??? – Edit Sorry for not asking question properly,See we will be getting sql server backup from client every night,and we have to load it to my sql every night.so we my s...
if row contain integer value then column name not coming while reading .csv file using ObjOLEDBConnection
if row contain integer value then corresponding column name not coming while reading .csv file using ObjOLEDBConnection. can any one give me a solution ...
PhpMyAdmin File too large error when trying to import sql
Hey folks, I am trying to import a database (.sql) file using phpmy admin on a clients server. I get a file too large error even thought I have the option to break the file into pieces etc but I still get the error. The upload size is 50MiB and the file I am trying to import is 90mb (for the db.) I had the same error in MAM and know I ...