Search results for query: *

I tried with putting parenthesies but it is not working Can you tell me where am I gonna put the parenthesies in the code. Thanks, I am using oracle databases thatis why I use "and" not join conditions

Can someone help me on about this. I have a search form with two operators "and" "or" The query is working when I click "and" but not working when I click "or", it seems query not ending. Here is the query: SELECT Parkcode_XREF.Parkcode1...

Thanks for replying Ceiling(1.025) = 2 It is taking closest integer I am looking for something: it will give me to decimals and the decimal will round up like this: 1.025 will be 1.03 1.022 will be 1.02 1.455555 will be 1.46 Thanks

I wonder how can I round the decimal up. Lets say I have something like 1.025, I would like to round this number up like 1.03 or 1.022 round this number just down 1.02. Is there anyway to do this. Thanks

Oracle database I have a table and a field called Date and type is date. When I try to insert date in it it says invalid user.table column, table column or column specification; Here is the code: insert into parkcode_xref(date) values ('#CrateODBCTime(Now())#') Thanks for help

Thanks for replying Actually I have a field in my table called modified date where date inserted as in LSdateFormat and it is Text type column. I tried your syntax but it seems giving error, seem didnt like it. This code is working in access but not working in Oracle. But SQL server is same as...

I am trying to see a week worth of modified data in my oracle database and I have a field contains modifying date. I wrote the code but the result is strange: It is just using the "day" as a criteria, In other words when I say -7 it is going and finding all data for 7 days but for all...

Never mind webmigit, I got that it was attachment instead of inline Can you help me on that xml tags output problem Thanks

Hi webmigit, this didnt work. I am not sure but I tried different ways but didnt work. But I have a question about downloading file. I have a button, the user will click that button they will download a file from a directory but the user will choose his or her save location in the his hard...

Is there anyway to see the xml tags on the window as a output. I have a page like this: <metadata><br> <idinfo><br> <citation><br> <citeinfo><br> <origin>#q1.Originator_Names#</origin><br> <pubdate>#q1.Publication_Date#</pubdate><br> <title>#q1.Title#</title><br>...

Thanks for your reply Actually it is not zip file, clinet will download text file to their hard drive. I mean when they click the button they can see a prompt where to save like in upload where window brings that up but in download it is not like that. not asking. Do you have any idea how to do...

Can someone help me on this. In my web site I have a button for downloading file. What I would like to do when someone click that button, he or she can she the window where to save the file in their computer. like upload a file. How can I do that. Thanks

Can someone help me on calling java class file from coldfusion. I know I can sue <cfobject> or <cfscript> CreateObject but I am not sure how to do it. I read several articles but not sure what is going on. Can someone help me. Thanks

Tarwn, Thanks for replay. Can you show me that in the code I am pretty new in this: Here is a part of xml file: <metadata> <idinfo> <citation> <citeinfo> <origin>National Park Service Geologic Resources Inventory (GRI) program.</origin> <pubdate>Unpublished Material</pubdate> <title>Geologic...

I am new in Java programming. I have a question about parsing data from an xml file. That can be maybe using string functions or some other functions. here is the xml file I have: <?xml version=&quot;1.0&quot; encoding=&quot;ISO-8859-1&quot;?> <metadata> <idinfo> <citation> <citeinfo>...

I am new in Java programming. I have a question about parsing data from an xml file. That can be maybe using string functions or some other functions. here is the xml file I have: <?xml version=&quot;1.0&quot; encoding=&quot;ISO-8859-1&quot;?> <metadata> <idinfo> <citation> <citeinfo>...

I have something like this but it is giving a syntax erro can someone help me: <cfscript> numSrcinfo=ArrayLen(mydoc.metadata.dataqual.lineage.XmlChildren); num=ArrayLen(mydoc.metadata.dataqual.lineage.procstep); numLinage=numSrcinfo-num; for(k=1; k LTE #numLinage#; k = k+1) { if...

Can I run a coldfusion file on command line

Hello Can someone help on this problem: I have like 1000 xml files and eachfile has 500-700 lines. I would like to write a program to put the data in these xml files into my oracle database. The problem with these xml files is all files are not into same structure. I mean some of them has more...

Thanks for your replay. Can you show me the javascript code. Thanks