I have an issue with the search functionality page, on my text search box, if I type "bought by" with quotes to search for these 2 words in sequence in my database for reports that contain these 2 words in sequence, I get an error on the results page.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Oracle][ODBC][Ora]ORA-20000: Oracle Text error: DRG-51030: wildcard query expansion resulted in too many terms
/basic_results.asp, line 289
and my basic_results page code is attached as a txt file.
Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Selected collating sequence not supported by the operating system.
anyone knows wat's wrong with this?I am using asp, msaccess2003, using DSN, and winXP SP2
looking for code to write a seuqence of numbers to a table in access. user selects quantity to populate, lets say 50 . so the table would need to be populated with the first number of trackid0001 up to trackid0050 through the script
I have a website where I present the price of some products. The products and its prices are stored in a database. I want to loop through the products and order them by the price, starting with te cheapest. This is easy if I could use the price in the database. But some of the products have discounted prices. The discount is given on the website, so therefore I cant order the recordset by the price column, I have to set the looping sequence of the recordset in another way.
I am trying to sort out validation for a form to display the error message in sequence. ie; when you click continue with blank form fields the first message should read: "Please enter your previous address (Line 1)" but instead it starts with PostCode then time at the address then town? Code:
I have a "Digital Dashboard" that basically has 4 IFrame sections. The page flows in the following order: Messages, Stocks, Weather, User Links. Please note that this order needs to stay that way. Everything but the Stocks section is pulled from our dB. I am using the server control InetCtls.Inet to obtain the stock data from Yahoo Finance.
The question I have is can I load the page using the dB driven sources first and then the external source (e.g., Messages, Weather, Links, Stocks). In other words, I need to page to render the Stock portion last. What currently happens is the page loads, then "pauses" while loading the stock information, and then finally loads the remaining content. The pause is caused by the "screen scraping." If I can give the appearance that the page has fully loaded, and then load the stocks last, that would be perfect. I tried looking at script defer, but I don't think that is what I want.
In summary, I have 1 asp page that contains 4 IFrames. I need to load the page out of sequence. Is this possible? Any help would be much appreciated. We are running IIS 5.0 w/ asp 3.0.
In my application I get the error 'function sequence error' when i try to use RS.MoveFirst . This happens only in one screen but the same doesn't happen in another 2 screens where i am using RS.Movefirst. Code:
I seem to have a problem retrieving a sequence number from ASP using OO4O. Using ADODB, everything works correctly, however, using OO4O it seems to burn off an additional sequence number (ie it increments by 2 each time).
strSQL = "select sicontractnum.nextval as thenum from dual" set rsContractNum = dbConn.CreateDynaset(strSQL,0) response.write rsContractNum.Fields("thenum") rsContractNum.Close set rsContractNum = nothing
dbConn is a connection object created from the connection pool during session startup.
I'm trying to access an access database by including the DB's password within the connection string. I try to connect to the DB, but I get and "Incorrect Password" error. What am I doing wrong?
set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0"; uid=admin; pwd="pass" conn.Open(Server.Mappath("maindb.mdb")) set rsUpdateEntry = Server.CreateObject("ADODB.recordset")
I use asp to create a report, using content type I push it out as a word document. On my build this works fine, on my co workers it does not. The only difference between the two builds is I am on IE 5.5 sp2 and the other is 5.5 no sps. Unfortunatly I am in no position to get the machine and others like it onto sp 2 and the User agent variable is only returning 5.5.
The problem with the output on the no sps machine is that it opens in word with all the HTML tags visible Does anybody no a solution?
Server object, ASP 0178 (0x80070005) The call to Server.CreateObject failed while checking permissions. Access is denied to this object.
I am running window 2000 professional with IIS 5.0 installed. I know it is a ntfs permissions error and that IUSR_ComputerName needs permission to interface with word, i am just not sure which file needs to be the recipient of these permissions. I have located 'word.exe' in program files, set appropriate permission but no joy.
I have a system that Im about to start building it is in planning stage at the moment and if I was going to a database and keeping everything in HTML I would be right and not posting here at this stage.My client is after a system that they can register a new document enter in the basic information and on save, Create a Word document based on a Word Template prefilled with some of the data from the HTML form. Can any one point me in the direction of some? tutorials/code/tips/prebuilt systems that I can donate or buy from the developer/
I am creating a word document using asp.I have this on top of my asp page.
Response.ContentType="application/msword"
everything works fine.I am displaying some data in the table format.on some machines.may be old machines.the asp page opens up word document fine but the table tags are not rendered properly.
i get all the data fine but not displayed in the table format.instead i see <td> and other tags.it works on my machine(Windows XP) but it does this weird thing on windows 98 machine.what do i need to do to make sure it works fine on all the machines.
how to set a variable to contain the xml data from a file, including the xml tags too. So if I have an xml file like: <contact> <name>Person</name> </contact>
I want the variable to contain: <contact> <name>Person</name> </contact>
I cant seem to figure out how to ensure that a whole word is replaced within a string. For example, if I have an array with two items, "mpeg" and "mpeg4" and the text to look for is "blah blah mpeg4 blah blah"
the text to match with is the array, which is in a loop. how can i prevent "mpeg" from matching with part of "mpeg4"? i only want the whole word to match. do i have to use regexp here? vbscript functions seem inadequate.
I want to do a Ms Word document in a ASP page. I can do it, With the code lines:
///// Response.ContentType = "application/msword" Response.AddHeader "content-disposition", "inline; filename=OrderFax.doc" //// With these lines all document content show like a Word document.
But i can not change the MARGINS of this Word document.And Default left/right margins are very bigs.
I try it, change the <body> attributes and with styles, but this don't work, the margins are always the same.
How can i modify the margins of word document? I should do this with another method? Can I modify PC client settings to change the defaults margins of word document create througt the web?
My problem, i got a string that may can contain more than one word, it can contain upto ten, now my problem is i gotta replace some of the words, but with Replace, you can only do one word at a time? so how do i go about running thruogh the string and replacing all the relevant words, and putting them back into a string?
I'm currently working on an application that has to open word documents (word forms) and read and write data from/to it. But, unfortunately, the web server hasn't Word installed (my ISP...). Is there any other way to do that? I'm currently investigating about working with rtf documents, but the syntax is turning me crazy!!! Any idea/dll/other way to do that?
Is there a way to get records containing a whole word? I've heard regular expressions can do it, but I can't make one work in an ASP / MS Access SQL Query
sSQL="SELECT PageTitle FROM Pages WHERE PageTitle LIKE '%cat%' " rs.open etc
I am maintaining quite a few asp applications. In one of those, I have to change the response.redirect to a particular page. This application has more than fifty asp pages. Instead of going through manually through each page to find the response.redirect phrase, is there any tool that will find and report all occurences of response.redirect (in the present scenario) among all those fifty asp pages? If there is one I would like to know.
I'm trying to output some data from the db into a table but I'm getting a number of problems with the layout if all the words are together. The table stretches across the screen. I want to be able to output a number of words/characters and then insert a line break and then carry on with the rest of the output.
I have a Word doc already created that I want to open from an asp page. I want it to open in Word and allow the user to modify if necessary. I currently have it opening (using href), but it is opening in IE. I think I should be able to do it with javascript to open word and then call that function on the link to the doc. Can someone give me some pointers?
I have an MS Word template and wish to substitute certain values into certain parts of the document. I'm going to open the word doc using FSO. Is there any way to pass parameters in to a word doc when you open it like this?
I have created a word template containing logos. I want to be able to open the document and dynamically add data to it and save the file as something else. the problem is when I use the streamobject method it does not work! I can only add data if the file is a notepad (unicode file). Is there any way to do this? I can't find any ttutorials on the web.
Also I know how to write word documents using html and I cant use this method because when I open the document the image will not display. Is there a way to keep the image contained within the document?
If I can get either of the methods above to work that it would have solved my problem!
Or if anyone knows of other ways to creating a word document using logo's and dyanmic data then please let us know.
i want to know that is it possible to copy from a word document and paste it on to a textarea on a asp page. when i do it normally bullets are not paste as it is . it is changed into different symbol( inverted ?)