|
I am using oracle database to store my data. Then I have problem to retrieve data that store date, I have try to use this code;
sql = "SELECT DELIVERY_DT, CONTROL_NO, LOCATION FROM DELIVERY WHERE DELIVERY_DT = to_date(21/07/2003) ORDER BY DELIVERY_DT DESC"
but it is not function, I also try the function like in vb with the # sign like; .... WHERE DELIVERY_DT = #21/07/2003# and this come out with error invalid char.
Anybody have experience with this problem, please help me?
Thanks
|
|
|
|
|
It seems to me that your sql query is not valid.
Try TO_DATE('21-07-2003', 'DD-MON-YYYY')
See NSL_DATE_FORMAT
|
|
|
|
|
To not to get such date errors, always use universal form of dates, which is "YYYY-MM-DD". So your statement will look like:
SELECT DELIVERY_DT, CONTROL_NO, LOCATION
FROM DELIVERY
WHERE DELIVERY_DT = '2003-07-21'
ORDER BY DELIVERY_DT DESC
Philip Patrick
Web-site: www.stpworks.com
"Two beer or not two beer?" Shakesbeer
|
|
|
|
|
I have try that code and it is not work, I have tried so many method but still can't working.
It like, the code can't find and match it.
Thanks
|
|
|
|
|
This is what I'm using *every day*. So I know for sure it does working. Are we both talking about MS SQL Server?
Philip Patrick
Web-site: www.stpworks.com
"Two beer or not two beer?" Shakesbeer
|
|
|
|
|
I am sorry I am not using MS SQL Server but I am using Oracle (Oracle Orahome92). This make me confuse. I know it work with MS Access and Ms SQL server but not for oracle and I can't find the method.
|
|
|
|
|
I have a Windows User Control, which connects to a Messenger server. It works fine in a Windows Form. However, it doesn’t connect if hosted in IE. Is it a security issue? Any one knows how to make it work? TIA
|
|
|
|
|
Hi,
I have a problem on storing foreign char to SQL DB.
If user inputs a foreign char from asp page, for example, "ROSÉ", it
will be stored in the DB as "ROSé".
I need to be able to store as it is in the DB, "ROSÉ".
BTW, it is displayed properly in the Web GUI.
Thanks for any help that you can provide,
Charles
"Computers are like Old Testament gods; lots of rules and no mercy." -JosephCampbell
|
|
|
|
|
You are having a problem with character encoding. The easiest way to fix this problem is to simply replace the É with É the html encoded equivalent before inserting into the database. For a complete list of such encodings visit this page:
http://www.bbsinc.com/iso8859.html[^]
Steve
McLenithan
Is Bert Evil? | Homer: "Hello, operator, gimme the number for 911!"
|
|
|
|
|
The Server object should provide you with some methods to encode and decode characters. Also, make sure the database uses MBCS or Unicode for strings. In SQL Server, this is nvarchar or nchar (which pads extra space with spaces).
-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----
|
|
|
|
|
Thanks Steve and Heath for your reply.
I found the solution, although it was not obvious at first.
It turns out that web application uses UTF-8 encoding, and SQL uses UCS-2.
This different encoding standard caused the wrong data conversion.
The following article explains the issue:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;232580
I hope this helps other people who has similar issue.
Charles
"Computers are like Old Testament gods; lots of rules and no mercy." -JosephCampbell
|
|
|
|
|
I just learned PHP and I am using it in conjunction with mySql. I just wanted to say that php rules. It is really easy. I run a wrestling roleplay site and the members can actually edit there own pages but I dont have to give them a password to my site. They run there own stable bio and things like that so for those of you who have not yet checked out php take a look into it. Also if using php all a person will see when they click on view and source is just whatever html you used which means sometimes they will see nothing at all but if there is something that I am not seeing that php is bad let me know
|
|
|
|
|
Round here, a lot of us will be using ASP or ASP.NET, which can do everything you described  And view source always shows the HTML sent to the client, not the PHP/ASP/Whatever on the server.
--
Ian Darling
|
|
|
|
|
But why use PHP when you have ASP.NET?
Give one good reason other than slightly cheaper web hosting...
In ASP.NET you can use VB, C#, J# or a combination of all these making it more easy to set up a development team.
Not to mention the top class resource place (MSDN online) where you can find anything you want with examples etc...
Personally, I find the .net platform very developer friendly.
|---------------|
| theJazzyBrain |
|---------------|
|
|
|
|
|
Many people swear by PHP and MySQL - they work great together and are simple to learn and implement. If the tool does the job efficiently, it belongs in your bag of tricks. Many webhosting services don't support it, though, so don't limit yourself to just this pair; learn some ASP/ASP.Net and SQLServer as well.
"The Lion shall lie down with the Lamb;
but the Lamb will not get much sleep..."
Lazarus Long
|
|
|
|
|
DX,
I have to agree with the previous posters, ASP.NET has an extended and easy to use method, You call out the System.Namespace.Class and then you build upon that and you get a really cool app that works well. I have written PHP for practice and made that work also, however, Many hosting companys use 2000 Server with IIS 5.0, and now they seem to be leaning towards 2003 Server with IIS 6.0 which allows integration with Visual Studio.NET. I don't want to bag on PHP but it seems that the going thing is VS.NET, all of the things you described are possible with ASP.NET running atop the .NET Framework.
Regards
Tony
|
|
|
|
|
There is also the versioning problem. If you code using one version of PHP and deploy to a server that has another version you're in trouble. ASP.NET doesn't have this problem.
|
|
|
|
|
XML support is almost non-existant in PHP. It is listed as experimental. XML isn't an experiment any longer it is a powerful and useful tool the ASP.NET and the .NET Framework take full advantage of.
|
|
|
|
|
Not only full advantage, but you can treat XML files almost the same way you treat databases... this is very helpfull in some cases and opens new capabilities for developers...
|---------------|
| theJazzyBrain |
|---------------|
|
|
|
|
|
Many said about PHP here, so I'll say something about MySQL. Guys, I can't imagine a database that has NO support for stored procedures (which is MySQL). All it gives you is tables and that's all. Phhhhh.
Yes, PHP is very powerful scripting language, but has a lack of OOP support. Well yes, you can create kinda "classes" in PHP, but is this ALL you need in OOP? Where is inheritance? Where is protected/private/public members? This is not OOP. Maybe they added it in latest version (5 I guess), I dunno, the last one I worked with was PHP4
Philip Patrick
Web-site: www.stpworks.com
"Two beer or not two beer?" Shakesbeer
|
|
|
|
|
I need to redist soap 3.0 in a wise install script(.wse
file).
What are all the dlls that I need to pack in the wise
script?
What keys need I modify in the regedit?
|
|
|
|
|
If you're using Wise for Windows Installer (if you have it - use it - MSI's are much better), the redist includes a merge module. If not, you'd best check the Wise Solutions web site. They might have a downloadable object you can insert into your setup. If not, you'll have to make your own.
PS: Newer setup IDE's have built-in support for finding pre-canned objects and merge modules. If you have a newer version, try looking under the Tools menu (usually) or consult the documentation for more information.
-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----
|
|
|
|
|
I need to create more than one text box with the same name(this call array),with the code;
for i = 1 to CInt(request.Form("quantity"))
count = count + 1
serial_field = "serial"&count
end loop
then, when I need to check whether user already fill in this text box, I can not access that text box name.Text box name suppose to be serial1, serial2 and so on.I am using this code;
for (a=o;a<=30;a++){
if (document.Reg.element.serial[a].value == "") {
err = true;
msgstring = "Fill in serial number";
}
}
I can access the value only if I directly use the name like;
if (document.Reg.element.serial1.value == "") {
err = true;
msgstring = "Fill in serial number";
}
Any suggestion what I should do to solve this problem. I am sorry my explanation is quite massy.
Thanks
|
|
|
|
|
serial_field = "serial"&count gives all the fields different names - serial1, serial2 etc...
Just use serial_field = "serial";
Ryan "Punctuality is only a virtue for those who aren't smart enough to think of good excuses for being late" John Nichol "Point Of Impact"
|
|
|
|
|
Ya, that true according to logic but the problem bow, the object(text box) has been created first than we need to check when user click on save button.
How we can refer to the object name?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
