Search results for query: *

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...

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...

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 |...

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?

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...

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?

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...

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...

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" />...

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))) +...

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...

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...

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...

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 =...

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...

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...

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...

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...

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...

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)...