More One Word In Sequence
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.
View Replies
ADVERTISEMENT
In the table MYSQL I have this sequence of rows:
CODE===========NAME
610=============ASSI
610=============ASSI
610=============ASSI
610=============ASSI
619=============ASSI-9
619=============ASSI-9
619=============ASSI-9
I like to see:
ASSI
and query that counts for all rows like ASSI ...
View Replies
View Related
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
View Replies
View Related
In an asp file, the statements are like this,
1. HTML Tags
2. Javascript
3. VBScript
4. HTML Tags
5. asp coding
6. Javascript
7. VBScript
8. asp coding
9. HTML
tell me the sequece of execution in an asp file.
View Replies
View Related
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
View Replies
View Related
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.
View Replies
View Related
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:
View Replies
View Related
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.
View Replies
View Related
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:
View Replies
View Related
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.
View Replies
View Related
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")
View Replies
View Related
This is the stubborn error I'm getting in my ASP code:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Function sequence error
It points to the line: lrsQuery.MoveFirst, as below Code:
View Replies
View Related
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?
View Replies
View Related
I am trying to create a word document via asp.
I keep getting this error:
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.
View Replies
View Related
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/
View Replies
View Related
is it possible to produce a report of asp to ms word?
View Replies
View Related
What is the best way to generate a word-document with wbscript code?
I have a text string I would like to save as a word document on the server.
Any tutorials? or code examples?
View Replies
View Related
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.
View Replies
View Related
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>
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
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?
View Replies
View Related
The following code hangs or gives me a "can not fire event" message
The code works from a windows app.
Fails in ASP.NET on the word.open call
I have done the following:
How to configure Office applications to run under a specific user account
http://support.microsoft.com/defaul...b;en-us;Q288367
Before doing the above the cod use to get an access denied on the
new word.application();
oWordApplic = new Word.Application();
object fileName = "filename.doc";
object readOnly = false;
object isVisible = true;
object missing = System.Reflection.Missing.Value;
// hangs here or returns cant fire event msg
oDoc = oWordApplic.Documents.Open(ref fileName, ref missing,ref readOnly,
ref missing, ref missing, ref missing, ref missing, ref missing, ref missing,
ref missing, ref missing, ref isVisible,ref missing,ref missing,ref missing,
ref missing);
Any ideas?
View Replies
View Related
i want to make a program to find out and highlight a particular word on the browser using ASP and javascript.
View Replies
View Related
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?
View Replies
View Related
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
returns scatty, catatonic etc.
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
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?
View Replies
View Related
How can I open/push data to WORD/EXCEL which was installed in client machine? Is it possible without using thirdpaty components?
View Replies
View Related
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.
View Replies
View Related
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 ?)
View Replies
View Related