Jump to content


  • Content Count

  • Joined

  • Last visited

Everything posted by kwilliams

  1. I copied and pasted the revised code you provided into my SP, ran it, and it was successful. I did a count on the DB table as I ran the job, and it counted occurrences of arrows in this count pattern: 75 (initial count), 53, 26, 15, 9, 5, 3, 2, 2, 0. I manually ran the job on purpose to make sure that it was working on my side, which it did...yeah:)So I see that the next step is to add a loop for the job using the SELECT COUNT method that you noted. You've already helped me a great deal, so I don't want to request for you to write more code for me. But if you could give me an idea of how I sho
  2. ...also, I received an error when I applied your suggested changes to my SP. Here's what I have:CREATE PROCEDURE [dbo].[spRemoveArrow]ASBEGINDECLARE @arrow binary(16)SELECT @arrow = TEXTPTR(details)FROM tblTableNameWHERE (details LIKE '%& #9658;%')UPDATETEXT tblTableName.details @arrow (PATINDEX('►', details) - 1) 7 '-'GOPlease Note: I still kept the space is still between "&" and "#" to allow code to come through, but there's no space in my code.and here's the error message that I received:Error 170: Line 9: Incorrect syntax near '('.Any additional suggestions would be ve
  3. Ok, I'll give that a try. I actually already posted it in the first post in this thread. The example is at the bottom of the page.P.S. I saw that bulk copy code as something to do with running the stored procedure, but since I'm going to run it within a scheduled DTS package, I didn't see the need for it. I'll await your response on the MS example code. Thanks.
  4. I did that because that's how I had seen it done in the sample. So you're saying that I should instead do the following: SELECT TEXTPTR(details) FROM... ? if this is wrong, please let me know how I can go about fixing it. Ok, I understand that now. And I'll use the "PATINDEX('& #9658;', details) - 1" method you referenced, as I don't know before-hand where the arrow occurs for each record. No, I want it to loop through all of the records in the table. The MS example has the following code at the beginning of the SP:USE DATABASENAMEGOEXEC spRemoveArrow 'DATABASENAME', 'select into/bulkcopy'
  5. I need to replace a few strange characters that are located in a table field that has a text datatype. My first try is to replace an arrow character (code: & #9658;) with a dash.Please Note: I had to place a space between & and # for you to to see the code of the arrow.I found a MS article on the UPDATETEXT method at http://msdn2.microsoft.com/en-us/library/a...58(sql.80).aspx...which provides the following example: DECLARE @ptrval binary(16)SELECT @ptrval = TEXTPTR(pr_info) FROM pub_info pr, publishers p WHERE p.pub_id = pr.pub_id AND p.pub_name = 'New Moon Books'UPDATETEXT p
  6. Yes, you are correct. Sorry that I wasn't more clear. The other form fields show up behind the menu; only the select menu shows up in front. I went to several links through the Google Search you referenced, but I'm already using their solution with z-index on my menu's container, like this:#navlist { position:absolute; width:auto; margin-left:10px; margin-top:-1px; z-index:1;/* brings menu to front of content */ font-size:1.0em;}This brings the menu in front of the content on the page except for the select menu. So I'm not sure what else to do at this point. Any suggestions would be greatly ap
  7. I developed a pure CSS menu with the help of Eric Meyer's tutorial, and it works great. But in IE6 and IE7, the menu shows up *behind* the form fields below. I hope that there's a quick fix for this that I haven't been able to find. If you can help me out, that would be great. Thanks.
  8. Yes, that is what I'm having trouble with. Yes, according to the referenced article, that is what the purpose for "padding-bottom: 1001em" and "margin-bottom: -1000em". I commented them out to see what would happen, and although it did fix the overflow problem, the left column doesn't go all to way down to the footer as it should. I also tried moving those two values from "#wrapper.column" to "#screenleftnav", but it again causes the same overflow problem. Any other suggestions would be great. Thanks.
  9. This site is on a test server, so there is no link to provide...sorry.The code attached can simply be copied and pasted into an ASP.NET doc, and then displayed on several browsers to see what I'm talking about. This shouldn't at all clutter up your machine. Let me know if you have any other questions. Thanks.
  10. Thankfully, this question was answered by another forum, and I wanted to put the fixed code in this forum as well: #screenleftnav li {float:left;}#screenleftnav a {width: 117px;display:block;background-color:#99C;padding:1px 1px 1px 1px; /*'padding-top' 'padding-right' 'padding-bottom' 'padding-left*/border-bottom:1px solid #000; /*'border-bottom-width' 'border-bottom-style' 'border-bottom-color'*/} Thanks:)
  11. I created a CSS stylesheet based on this article: http://www.alistapart.com/articles/dropdowns/...and I created a 100% div height design from that with this article: http://www.webmasterworld.com/css/3333354.htmWith these referenced sites, I created a site with a header, footer, left column, center column, and a right column. It looks great in all browsers that I've tested so far, which include IE6, IE7, and Firefox. But for some reason, a few of the pages don't obey the "overflow:hidden" in IE6 and IE7. Most of them do, which is what's confusing me about it.If anyone could let me know what I'
  12. I created a CSS-based menu using an unordered list based on this article: http://www.alistapart.com/articles/dropdowns/...and I created a 100% div height design from that with this article: http://www.webmasterworld.com/css/3333354.htm */My resulting stylesheet basically makes an unordered list within a <div> tag into a group of buttons. It worked great before I added the 100% div height code, but the background color is not showing up for the first list item in IE6 and IE7 (shocking, I know). It shows up fine in Firefox. The rest of the list items show up fine in all browsers. I've look
  13. I'm in the process of migrating my site from classic ASP to ASP.NET 2.0, but I need to use some of the classic ASP apps until this process is complete. I'm trying to use a XML/XSLT transformation within an ASP doc (w/JScript syntax), but I'm getting an error. This setup works fine in my ASP.NET page, and I know that the XSLT doc is proper, so I'm thoroughly confused. I've included code for all of the referenced pages below, and all of these files are located in the same directory on my machine. If anyone can let me know what I'm doing wrong, that would be great. Thanks.xmldoc.xml:<?xml vers
  14. Thanks for the quick reply boen_robot.I added your suggested code like so:Dim args As New XsltArgumentList()If recordId_qs <> "" Then args.AddParam("record_id", "", recordId_qs)End If...and it worked great. I can't believe that I didn't figure that out on my own. I really appreciate your help. Have a good one.
  15. My site uses a XML/XSL transformation using an ASP.NET page, and I'm trying to reset one of the XSL doc's parameters depending on a querystring value (ex: default.aspx?record_id=pw). But I'm getting an error, and I'm not sure how to solve it. This is what I have so far:ASP.NET DOC 'Assign XML and XSLT docsDim strThisPage_xml As String = "/docs/xml/default.xml" 'XML doc stringDim strThisPage_xsl As String = "/docs/xslt/default.xsl" 'XSLT doc string'Declare querystring variableDim recordId_qs As String = Request.QueryString("record_id")'Create the XsltArgumentList objectDim args As New XsltArgu
  16. Well, I googled "XsltArgumentList Transform Source", and I came up with a lot of great resources for what I was looking for. The one that worked for me is titled "Create ASP.NET pages from XML data", and it's located at http://articles.techrepublic.com.com/5100-22_11-1050062.html. So I just added this bit of code to the default.aspx page:'Assign maincolumn XML/XSLT transformation propertiesxslTransform_mc.DocumentSource = strThisPage_xmlxslTransform_mc.TransformSource = strThisPage_xslxslTransform_mc.TransformArgumentList = args...and the arguments were applied to the XML/XSL transformation. N
  17. I'm using the ASP.NET MasterPage method for my new site, that includes a XML/XSLT transformation. Now I'm trying to create a form with XSLT and ASP.NET that uses a XSLT paramater to change the displayed data. I found a MSDN Library item "XSLT Parameters" at http://msdn2.microsoft.com/en-us/library/dfktf882.aspx, and it works great statically. Now I'm trying to implement the same concept on my MasterPage site, but when I put this code into the content page's codebehind doc, the parameter isn't being passed back from the ASP.NET content page to the XSLT doc.I'm hoping that I won't have to move t
  18. Worked like a charm:#navlist { position:absolute; width:auto; margin-left:10px; z-index:1;}Thanks jamess:)
  19. The 3-column design with a header and a footer is still working great, but I'm having two related problems:1) The footer shows up at the bottom of the page in both Firefox and IE 6.0, but the left and right columns are not going all the way to the bottom in IE 6.0.2) I've created a popup menu to go with this site, but it's showing up behind the content section.I'm including my current code at the bottom of this post. If anyone can see what I need to change to make this work properly, that would be wonderful. Thanks for any and all help.default.aspx <%@ Master Language="VB" CodeFile="Master
  20. Ah, I've figured it out:)This is the revised code that works great, for anyone that would like to see it. Thanks again for your help ste! <?xml version="1.0" encoding="UTF-8"?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"><html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" ><head><title>One Hundred Percent Height Divs</title><style type="text/css" media="screen">html, body {margin:0;padding:0;height:100%;}#wrap {position: relative;min-height: 100%;}* html #wrap {height: 100%;}#header {background-
  21. Wow, that works great. Thanks for the quick reply.My next step would be to have the header go all the way across the screen, and have the height at 154px, while keeping the footer at the bottom of the screen. Adding a 100% width to the #header worked for the width issue, but I'm having a problem when revising the height. This is what happened when I tried to revise the code:Case #1:#header {position:absolute;height: 154px; /*<-----THIS IS A REVISION */background-color: #EAEAEA;border:1px solid #333;width:100%; /*<-----THIS IS A REVISION */}#left {position:absolute;left:0;top:154px; /*<
  22. I found this great tutorial at titled "CSS 100% Height DIV's tutorial" at http://www.webmasterworld.com/forum83/200.htm, which seemed to solve my problem. I'm creating a new site with a three column design, a header, and a footer. When I copied and pasted the code into my page, it worked great in IE6, IE7 and Firefox.So I then entered code for a header and a footer, and it again worked great in all three browsers. But when I tested it out by entering a bunch of <br />, the footer didn't stay at the bottom of the page.If anyone can look at the code below, and let me know what I'm doing wr
  23. My problem is that my application properly pulls an ASP.NET file on my machine using Visual Web Developer 2005, but it doesn't pull it properly when a copy of the application was uploaded to our test server. On my machine, I listed the entire path for the ASP.NET doc to be pulled (c:\Documents and Settings\MYUSERNAME\My Documents\Visual Studio 2005\Projects\DIRECTORY\SUBDIRECTORY\PAGE.aspx). On the test server, I'm attempting to pull the ASP.NET doc with a UNC share (\\SERVERNAME\DIRECTORY\SUBDIRECTORY\PAGE.aspx).I'm using the FileInfo Class to do this, and I've included the two versions of co
  24. It worked great! Thanks for the quick response.
  25. I'm trying to use the replace method to replace all instances of "a" and "b" characters within a string, but I'm running into a problem. I have accomplished this in my VB version without a problem, but the JavaScript version is only replacing the first instance of the character in the string. I've included all of the referenced code below. If anyone could please let me know what I'm doing wrong, that would be great. Thanks for any and all help.Problem: JS version replaces only the first instance of a character, while the VB version replaces all instances of characters.Example value: bababaVB v
  • Create New...