Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by karen4201

  1. karen4201

    starting a website- advice needed

    Keep in mind that a copyright and patent are DEFENSIVE legal tools. It won't prevent someone from copying the material, but you could use your copyright/patent to ask them to stop using the material in bad ways. Basically, what you're looking to do is take "ownership" of those words, so that...
  2. karen4201

    group by 30 min. intervals

    Hi, I'd like to organize my data based on a datatime field grouped by 30 minute intervals. I'm thinking about using a CASE statement that would look at the minute and if 0..30 then it would get 1, otherwise it would get 2...so 1 is the first half hour, and 2 is the second half hour. There are...
  3. karen4201

    trigger doesn't work. why?

    wow. that's it! Thanks :)
  4. karen4201

    trigger doesn't work. why?

    Here is a very modified version of the trigger. It's enough to show the logic of the trigger, but I had to modify some info so that I could post the question: CREATE TRIGGER [person_tbl_trigger] ON [dbo].[person_tbl] FOR INSERT, UPDATE, DELETE AS declare @my_id varchar(100) declare...
  5. karen4201

    trigger doesn't work. why?

    I've developed a trigger that runs for an UPDATE on table A. It simply calculates some information and updates table B when table A has an update. It works fine if the update is on only 1 item in table A. However, if table A has multiple items that are updated, then the trigger returns an...
  6. karen4201

    sql variable not working. why is this?

    Hi, Thanks for the suggestion. I apologize for not including everything in my code question....here is most of what I truly have in my db function: set @nameStr = 'aaa,bbb,ccc' set @case_str = replace(@cases,' ','') -- get rid of spaces set @case_str = '''' + replace(@case_str,',',''',''') +...
  7. karen4201

    sql variable not working. why is this?

    I have a variable that doesn't work properly, but the query works when I use a string of characters.... DECLARE @nameStr _str varchar(3500) set @nameStr = 'aaa','bbb','ccc' this works: select * from tableA where name in ('aaa','bbb','ccc') but this does NOT work: select * from tableA where...
  8. karen4201

    what sql would do this?

    Hi, I have a table with a document's history. The table's fields are: docid (int), name (varchar), version(int), status(varchar) status could be = under construction, published, expired with each editing of a document, a new record is inserted and the version number is incremented. Here is...
  9. karen4201

    xsl question...

    thanks for the tips :)
  10. karen4201

    xsl question...

    Hi, I couldn't find an XSL forum, so I thought I'd post my question here. I'm trying to create a hyperlink based on a value-of. Here is the code, which is not working: <a href='<xsl:value-of select="myURL"/>' >the link</a> How could I get this to work? Thanks in advance.
  11. karen4201

    how do I modify a string field?

    Let's say I have a table field that contains "Joe, Bob, Mike" and the names might be rearranged (like "Bob, Joe, Mike"). Is there an easy way to update ALL fields that contain "Bob" so that the field would simply have Bob removed from it? So, in essence: there is a table with a text field...
  12. karen4201

    handling the &quot;&amp;&quot; character in a string

    correction: I meant to type.... So the "copy&amp;paste" becomes "copy&paste". Now that I'm doing the adjusted string comparison, it's working!
  13. karen4201

    handling the &quot;&amp;&quot; character in a string

    Thanks for the tips. I figured out what was going on. It seems that the browser (IE 6.0) will accept "copy&amp;paste" and display it properly. However, when I do the dropdown selection, the JS does a string comparison as though the value was passed as an html string. So the...
  14. karen4201

    handling the &quot;&amp;&quot; character in a string

    Hi all, I'm trying to build 2 drop-down lists. When the first (list A) drop-down is selected and an item is picked, the JS will automatically populate the second (list B) drop-down list. I have it working for most items. However, if list A contains an item with a "&" character, such as...
  15. karen4201

    SQL Server version control?

    Yeah, I was thinking about using VSS or CVS and do versioning of the text scripts for the database objects. I'm glad to see that other people think the same things :) Thanks!
See more

Part and Inventory Search

Back
Top