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!

Search results for query: *

  1. travisbrown

    SCOPE_IDENTITY not erring, but not working either.

    Trying to figure out what I'm doing wrong here. About half way down I'm trying to get the SCOPE_IDENTITY() from the last insert. No error, but won't run any line referencing the SCOPE_IDENTITY var. This is simply a one-off process, so don't look at as an eventual sproc. DECLARE...
  2. travisbrown

    Counting and Limiting Words in Word 2007 Form Fields

    Is there a way to limit the number of words in an input text field in Word 2007? I was handed a document with spaces for multiple text areas that they want word-limited with various limits and a countdown of words left (195/200, 454/750, etc.) I found a couple of samples, but can't seem to get...
  3. travisbrown

    Dynamic Pivot/Crosstab with string values

    I'm working with two existing and populated tables in SS2005 and trying to pivot one of them up into a join. The first table is a master table of contest entrants. The second table is an index of keys and values related to the contest entries. So for example: TBL_CONTESTS 123 | Joe | Blow |...
  4. travisbrown

    Updating Excel data with DSN-less connection.

    Used to be that I could find instructions on how to set up Excel to update on open from a SQL Server table using a DSNless connection. Now I can't seem to find instructions anywhere. Can anyone guide me through this?
  5. travisbrown

    Aliases in Joined Updates.

    Anyone have an idea why I'm getting Incorrect syntax near 'o' on the following query for SQL2005? Doesn't seem to actually be an aliasing problem; I get a similar error if I just use the table names. UPDATE dbo.sub_orders o INNER JOIN dbo.TBL_REGION r ON r.region_name = o.billing_province SET...
  6. travisbrown

    Autofilter with combo box in Excel

    I have a workbook with a data table on one sheet, and a chart on another. I can filter the data using autofilter on the datasheet, but want to use a combo box on the chart sheet to control the chart display. Any directions on how to do this?
  7. travisbrown

    Linking tables with DSN-less connection

    I'm trying to create an Access db that has linked tables so I can send to client as a front end for a SQL 2005 db. I'm running into a little problem. 1. I was trying to create an AutoExec module that would load when the db was started. I'm a little unfamiliar with Access. I thought I did it...
  8. travisbrown

    Extracting specific code from an AJAX request.

    So I'm in this situation where I need to call in a chunk of code from another page. Not the whole page, just a table inside a div with an id="SelectedContent". I have no problem pulling in the entire page content using an AJAX request. Question is, what is the best method for parsing out just...
  9. travisbrown

    Request.Form() Returning Odd UTF Value.

    Okay. This dunbfoinds me. A form submits a textfield with a value of "Potluck Café & Catering" The processing page returns somethign completely unexpected <form action="" method="post"> <fieldset> <input name="job_employer" type="text" /> <input type="submit" value="submit" />...
  10. travisbrown

    Formatting initial caps

    I quickly needed to clean up some data before reporting - making city names proper case, etc. This is how I did it, but is there a better way just for future reference? I guess with 2005 and greater you could use REGEX. REPLACE(LEFT(city,1),LEFT(city,1),UPPER(LEFT(city,1))) +...
  11. travisbrown

    A Little Crosstab Query Trouble

    I'm trying to figure out this cross tab for SQL2000. I think I'm on the right track, but a little stumped. Every time I do these, I seem to completely forget how I did them last time. Three Tables 1. tbl_reg - table of all event registrations 2. tbl_reg_int - table of selected interests by...
  12. travisbrown

    Denormalizing records into a string.

    I'm a bit perplexed how to do this. Usually I'd write a recursive function in ASP, but I need this as part of the data results. I have a categories table. category_id (pk) category_name category_parent parent_category is so categories can be subjugated to other categories. 1 CAT-A 0...
  13. travisbrown

    Getting results of remotely executed code into variable

    I've run up against a brick wall for this in ASP 3.0, so maybe there's something I can do in VB.NET. I'm doing an XSL transformation by calling in local XSL and XML using a serverside XMLHTTP request, storing the results of each into a variable, then transforming. The requested pages need to...
  14. travisbrown

    Pass results of server.execute into variable

    Is there a way to pass the results of a server.execute call into a variable or object? I was using a serverside xmlhttp call, but I need to keep both the host page and the remote page in the same session. In concept, something like this: <% a = server.execute("xml.asp") b =...
  15. travisbrown

    Recursive Looping through an Array.

    I'm trying to nest some lists using a recursive function. My usual method of getting data from a db is using GetRows() and looping through using FOR/NEXT. Using this method with recursive function, I think I'd be overwriting the iteration variable values (x) as soon as I hit the second loop...
  16. travisbrown

    Little help with simple regex pattern.

    Learning as I go.... What's the regex pattern to find all instances of something like this: test1224269150994="271" <td test1224269150994="271"> <tr test1224269150994="271" test1224269150994="281"> I'm trying test.*> but it selects the last > in the document, not the next instance after the...
  17. travisbrown

    Stripping attributes from HTML - regex

    I'm working with this app and need to post the contents of js-generated HTML for serverside processing. The js functions add a bunch of attributes for some dynamic sorting and style. Obviously I don't want to strip all attributes since there are some persistent attributes for images, etc. I...
  18. travisbrown

    Session values available for all scripts except @ domain root??

    So I created a session as part of a login process, and the session is available to areas of the site except the root. Anyone explain what is going on? For example, I sign in at http://123.123.1.123:8070/signin/index.asp A script at /signin/process.login.asp sets SESSION("test") = TRUE...
  19. travisbrown

    IIS file caching

    We are getting this incredibly frustrating issue with IIS serving what seem to be cached files on our development machine. Say we make a change to a javascript file, or delete the file entirely, the server keeps serving up the original file. Seemingly the only way to rectify the issue is stop...
  20. travisbrown

    XMLHTTP and Persistent Sessions

    Does anyone have a understandable method of setting a remote XMLHTTP request to use the same session as the requesting script? I've been reading about setting the request header, but not too sure about where to go with it. On the remote page, what's the next step? FUNCTION XMLHTTP(url,params)...

Part and Inventory Search

Back
Top