I have a large excel document that needs to be posted to the website. The links work perfectly in excel but as soon as the document is posted the links disappear. I can't figure out why. Can anyone help?
If someone does a search on this site, they only get very limited results in "XREF" (or unit 8) and NO results in the other units - 3, 28 & 29. In the database all they keywords are located in "content" column. Can someone tell what is wrong? If I'm in the wrong forum, please let me know...
No, I'm not saying that. I can modify the asp and query the database. The guy who set it up is gone but I know that he was having problems trying to figure out why the search function did not work as intended.
I am confused. It actually does search the appropriate units, pages, contents etc, however, it only 'finds' items in XREF (unit 8). Even though the keywords have all been entered into the data base, it doesn't come up with any keyword results for any other units. Can anyone help?
Here is the coding used. Can you help? ps thanks!
<%
Dim varKeywords
Dim strSQLKeywords
Dim objConn
Dim objRecKeywords
Dim intCount
Dim varUnitID
Dim varSiteID
Dim varSubjectID
Dim strSQLUnit
Dim objRecUnit
Dim tempArray
tempArray = Split(Request.Form("SiteID"),"|")
' set the values for...
I am having a problem with my search. It only seems to search through XREF (site 8). It won't search through Site3, Site 28 or Site 29. Does anyone know why?
' generate SQL statement based on Site ID
If varSiteID = 8 Then
strSQLKeywords= "SELECT XrefMemos.MemoNumber, XrefMemos.MemoTitle...
Thanks for your help. I was wondering, though, if you could be a little more explicit. Could you show me exactly where you think the parens should go (in the coding from the previous e-mai) using a different colour so I can see. thanks a million for your help!
There is no error message. It just comes up with the statement 'no documents where found using these keywords'. I've added all the keywords into the database but it still won't work.
I am having a problem with my search. It only seems to search through XREF. It won't search through Site3, Site 28 or Site 29. Does anyone know why?
' generate SQL statement based on Site ID
If varSiteID = 8 Then
strSQLKeywords= "SELECT XrefMemos.MemoNumber, XrefMemos.MemoTitle...
I am taking over web editing for someone who is gone from this organization. He has the site set up with .asp files which no one here is familiar with. He has it so that the data is shown in alpha order, but I would like it to show in date order. What do I do? I am not familiar with any of...
I am taking over web editing for someone who is gone from this organization. He has the site set up with .asp. He has it so that the data is shown in alpha order, but I would like it to show in date order. What do I do? Don't forget that I am not familiar with asp scripting - only html.
I am taking over web editing for someone who is gone from this organization. He has the site set up with .asp. He has it so that the data is shown in alpha order, but I would like it to show in date order. What do I do? Don't forget that I am not familiar with asp scripting - only html.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.