Only Displaying First Word Of Field
This script works, however when I read in the fields, if they have a space in them, it only puts the first word in. For example, if the company name is Bell Mobility then it will only put Bell. Code:
View Replies
ADVERTISEMENT
Displaying Word Documents
displaying word documents onto a webpage? The word documents will contain text/tables/pictures. I am new to this and can't quite find what I need.
View Replies View RelatedDisplaying A Portion Of A Db Field
I saw creole's post regarding a similar CF function and thought I'd start a similar ASP thread. If I have an article (entirety of kept in a field adequately named "article") how would I select only the first, say 450 words, to be displayed on a page....followed by a prev/next nav item. Naturally, page 2 would pick up where it left off. How to do this? Or do I have to split the article up into article_sec1, article_sec2, etc?
View Replies View RelatedDisplaying A 'memo' Field
I know how to display a text field from an mdb file. You type: <%= CmdPopulateStates("fieldname") %>
where CmdPopulateStates is declared as:
Set CmdPopulateStates = Server.CreateObject("ADODB.Recordset")
But if 'fieldname' was a memo field rather than text field then the information isn't displayed. In fact, if it's anything other than text then it won't be displayed. How do I display other field types?
Displaying Certain Field Names Only...
I am trying to display only certain columns from a table and this is a code that I am using but it is not diplaying anything, can anyone tell me where my code is wrong
<%FOR EACH field IN rstSite1.FIELDS
if field.name ="EmpName" then
RESPONSE.WRITE("<TH ALIGN='LEFT' BGCOLOR='#B0C4DE'>"& FIELD.NAME & "</TH>")
end if
NEXT%>
Displaying Long Raw Field
I have an Oracle database which has a field LONG RAW type to store text files. I'm trying to display the output of this field in ASP but I'm having problems. I've gone through many different approaches but they either do nothing or do the following;
I've tried doing response.binarywrite(rs("data_object")) and I get
somethinglike below ....
Making Every Word's First Letter On A Field, Uppercase
I'd like to know how can I make the first letter of every word on a textbox field, uppercase, automatically. I'd like to use this for the Name and Surname field, but I don't know how... any hint?
View Replies View RelatedDisplaying Text Field On Form
I'm trying to write a web form that will allow users update info from a database table. Everything is working fine, except the display of the one text field from the database (nothing displays. Here's what I'm trying:Code:
<textarea name="AdditionalInformation" cols="32" rows="10" wrap="VIRTUAL"><%=(UpdateRecruiting.Fields.Item("cs_additionalinformation").Value)%></textarea>
what I'm doing wrong?
Displaying Information Based Off An Empty Field
I've been searching for an answer to this for quite some time now and have found nothing, so maybe (hopefully) someone out there will be able to help me.
At my work, we have a lot of folders for different jobs we've done. And right now, we have more than one person making the folders for all the new jobs that we get. I am trying to make a database were it will only show the jobs that have not had folders made. In order to do this, I've created a field titled "Initials". I want the webpage to pull up all the records where the Initials field is empty, but I'm having trouble doing that. I've tried a few different things and have found no success.
I'm not having a problem accesses the database or updating it, just displaying the right information. I'll give a little illustration (because I'm never good with words):
Say I have 3 jobs: Job #1, Job #2, and Job #3. Someone has already made job folders for Job #1, but Job #2 and Job #3 still need to be made. Since Job #1 has been made, that means there are initials in the initials field of the database and thus, I do not want that Job being displayed on the "To Be Made" page. Job #2 and Job #3 do not have initials in the initials field and as such, I want to display those jobs....
Problem With An .asp Page Displaying Data Based On A Form Field Value.
I have an asp page that displays informaton from an Access database. I want to create a form that allows users to display only data that matches their search criteria.
I have made many forms like this in Front Page with the Database results wizard, but I want to manually code it. Code:
LEFT JOIN On A Date Field And A Numerical Field - Using WHERE Clause
I am using a Relational database for my site and i have the following tables:
FIXTURES, GAMEDATES
the fields in FIXTURES are:
GameDate
Home
Away
(All of the above are numerical fields)
the fields in GAMEDATES are:
DateID(integer)
GameDate(#Date Field#)
What i have done is in the GAMEDATE field in the FIXTURES table i have used the ID number of the date that i wish to assign to that record - using a LEFT JOIN to display the actual date that is pulled from the GAMEDATES table (That which corresponds to the relevant id used in Fixtures)
The problem is that in some of my code i want to display records using sql and sometimes in the where clause i use the following:
WHERE Fixtures.GameDate<=(Date())
obviously meaning WHERE GAMEDATE is LESS THAN or EQUAL to TODAY.
The thing is when i use the join it does not use the where clause and displays all of the records in the FIXTURES table.
Does any one know how to get around this, i have not received any error messages it just isnt displaying the right data
Comparing Field Data From Previous Field
Im comparing values in a field while doing a loop if sAct<>myData(5,i) then At the end of the loop I make the value of sAct equal the current myData
This will work when comparing other fields withing my recordset (so I know the statement works) but it will not work for the field I want to compare. The only difference with this field is that it has null values. Could this be the problem? if so, how do I deal with nulls?
Fill Field Based On Another Field
I have a input form with 5 fields. One of the fields is MajorNo and the other is named Description.
I have a reference table in my MS Access database (tblMajor)that lists the major numbers and their descriptions.
I would like to have the description field in my ASP automatically filled based on the major number entered on the form, so the user will only need to input the major number when submitting to the Access table (tblSalesTotal).
Pass Hidden Form Field Value To Another Form Field To Insert In Db
I am trying to pass a hidden field value on a form into another field on the
form so that it can then be inserted in the database, to enable me then to
reference that number at a later date.
(The hidden value (1 for example) would then automatically get passed to the
other input field.)
The code for the text field that allows users to type an number into it for
submission to the db is below, but what code do i need within the hidden
field to populate this text field below so that users do not have to type the
number in? Code:
How Can I Change One Line Input Field Into Larger Input Field
I have being working with making an edit field over the past few days. The edit function is now working fine. The edit fields that i have are for id, subject, notes, timedate.
All of the edit screens are one line text screens. What I want to do now is increase the size of the notes box to a larger textarea type box to make it easier to edit notes. The notes field in the db is a textarea field. Code:
ASP, Word And IE 5.5
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?
ASP + Word ???
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.
ASP To Word
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/
Asp To Ms Word
is it possible to produce a report of asp to ms word?
View Replies View RelatedMs Word
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?
ASP + MS Word
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.
MS Word To XML
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>
Whole Word Only
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.
MS Word Document
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?
String With More Than One Word
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?
Word Object
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?
Finding Word
i want to make a program to find out and highlight a particular word on the browser using ASP and javascript.
View Replies View RelatedWord Document
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?
Seach For Whole Word
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.
Occurrence Of A Certain Word
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.
Word Count
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 RelatedOpen Word From ASP
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 RelatedPas Params Into Word Doc?
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