Hi,
Thanks for your reply, can you explain further on what you mean by the method you mentioned?
Thank you
Regards,
Kencana Kesuma
kencana
Last Activity: Nov 12 '08, 09:11 AM
Joined: Nov 10 '06
Location:
-
Hi All,
anybody has any idea on how to insert string date into mssql database?
Thank you
Regards,
Kencana KesumaLeave a comment:
-
hi,
the following are my inserting code:
[PHP]
$content = str_replace("'" , "''",$_POST['content']);
$startDate = "17/02/2008 12:00:00 AM";
$endDate = "17/02/2008 12:00:00 PM";
$insertStatemen t = "INSERT ANNOUNCEMENT (content,startd ate,enddate,dat eupdated) VALUES('" . $content . "', $startDate,$end Date,getdate()) ";...Leave a comment:
-
Hi,
i realized that the datetime format in mssql is dd/mm/yyyy hh:mm:ss am/pm
so I changed the input date time format and it still gave me no luck. it keep inserting 1/01/1900. Also, i tried to insert the date time value into the database manually by entering 17/02/2008 and it is accepted.
Any idea on how to solve this?
Thank you
Regards,
KencanaLeave a comment:
-
Hi,
User will choose the date and time from the date time picker (javascript) and it is in yyyy/mm/dd hh:mm:ss
Every time i try to insert it, it will insert different date and time into the database.
I hope you can help me out
Regards,
KencanaLeave a comment:
-
inserting string date and time into mssql database
Hi All,
I have some problem in inserting date and time entered by user from the GUI into the form. Any idea on how this can be done?
Thank you
Regards,
Kencana -
PHP mssql connection pool with IIS
Hi all,
is there any tutorial for me about creating connection pool in php?
so far, what i read from articles is that i have to use mssql_pconnect.
As I am going to create a web service, thats mean I have to store
the connection pool into memory.
any idea of this?
Thank you
Regards,
Kencana -
sending mail attachment in php
Hi all,
I got problem in sending email with image file attached. the problem is that i can't see the image, apart from that i also try to attach a txt file and it gave me no luck. the txt file in the mail attachment is empty.
Tha following is my code, i hope somebody can help me out.
[PHP]
$file="Globe.gi f";
$fp = fopen($file,"r" );
$fcontent = fread($fp ,filesize($file ));... -
Printing function
Hi all,
I am currently developing a web page using jsp. what i need to do is,
to create a java print form function so that i can call this function by pressing
printing button.
what i need to do is, to create a print layout and print the form. have tried the javascript print function "window.print() " but it will print the whole web page.
any idea of to get this function done?
... -
mssql data retrieval
Hi all,
I have a database which consists of address data. so there will be duplicate value of postal code. how ever each postal code contains different x and y value.
what i want to do is to retrieve all the data by the building name and if there are similar building name i want to display it only once. i try to group it but since each record has different x and y...it return me error message.
which is as follows:... -
question about str_replace function
Hi all,
I got a doubt about the str_replace function.
[PHP]<?php
$string="avenue 1, ave 1";
$words=str_repl ace ("ave","avenue" , $string);
echo $words;
?>[/PHP]
the php code above will return me "avenuenue 1, avenue 1". i expect the result will be "avenue 1, avenue 1". any idea of how can i get such result?
... -
Hi all,
sorry there is small mistake in accessing xml file code...
the following is my final code:
[PHP]$clients = simplexml_load_ file('http://localhost/V3JRoute?slot=1 &startX=103.880 764&startY=1.33 5458&endX=103.8 86297&endY=1.33 4953&routeType= 1&format=1');
echo $clients->routeType;[/PHP]
Thanks...
Regards,
KencanaLeave a comment:
-
failed to open stream problem
Hi all,
I was wondering why I always get "failed to open stream: HTTP request failed!" error in either loading a normal or xml file. i don't understand why i can't get the whole result. the result i get is only some part of the respective url (the one i tried to load). The following is my php code to open the file:
[PHP]$file= fopen('http://localhost/V3JRoute?slot=1 &startX=103.880 764&startY=1.33 5458&endX=103.8 86297&endY=1.33 4953&routeType= 1&format=2',"r" );[/PHP]... -
Hi Ronald,
Sorry for the late reply.
What i mean is, if the words contains a single quote.
by the way the words will be used for retrieving data from the
database.
therefore, if there is a single quote in it, it will return an error message.
by the way, i have found a way to solve it by using the following code:
<?php
$keywords=str_r eplace(" ' ", " ' ' ",...Leave a comment:
-
replacing single quote
Hi all,
Any idea on how to replace a single quote into other characters?\
Thank you
Regards,
Kencana -
capturing the screen size
hi all,
is that possible to capture the screen size of the mobile and use the
captured screen size to resizing the image.so that, the image will be displayed fixed to the screen size. if possible, can i know how it can be done?
Thank you very much
Regards,
Kencana -
SOAP and PHP 5 Authentication
Hi all,
I am trying to create authentication features of my web service where only registered users are allowed to have
an access to my service.can I know how it can be done?
I hope somebody can help me out and thank you very much
Regards,
Kencana -
png->svg conversion
hi All,
is that possible to convert the png image format to svg format in php?
can i know how it can be done?
thank you very much
regards,
Kencana -
problem in passing variable from soap client to soap server
hi All,
I got problem in passing data (more than one) from soap client to the soap server. but if i only passing one data at a time, it works successfully..
The following is the error message i get when i pass more than one data:
"SoapFault exception: [Client] looks like we got no XML document in C:\Program Files\MapGuideO penSource\WebSe rverExtensions\ www\phpviewersa mple\clienttry2 .php:24 Stack trace: #0 [internal... -
counting hyperlink clicks
Hi all,
is that possible to count how many times user have click a specific hyperlink?and it will reset the count click to 0 once user quit from the respective page.
if yes, can i know how to code it in php?
I hope somebody can help me out and thanks
Regards,
Kencana
No activity results to display
Leave a comment: