Search results for query: *

I posted a while back about my sql query producing empy results. I ended up going in and changing all the TEXT field to VARCHAR field, and it was working, until I came up on this error today... runtime 1004 error Application-defined or object-defined error This was the value from teh...

I can run this query in sql server's analyzer and it runs just fine, but when the query runs in excel half the fields are blank.. not NULL, just an empty string. SELECT c.candidateName AS exp1, instat.status AS exp2, instat.comment AS exp3, s.state AS exp4, n.note AS exp5, avail.description AS...

I'm trying to put together a console application that will 1) Delete the first image in the word doc and replace it w/another one. 2) Find a text string, and replace it with other text. I had help from other members of this site to get the first part of this done, but the only problem w/it is...

I need to be able to change an image in about 30 Word an Excel documents. Whats the best way to do this w/out having to change it in each file individually? Would I need to use XML, or would a macro be better? Thanks, Greg

Does anyone have any information on how to change an image in numerous Word and Excel documents w/a batch process instead of individually changing the image in every document? Thanks, Greg

switching from java to php, and have a scope question. If I have a couple of classes that look like this: <?php class Person{ //Some code that access the database } ?> <?php class User{ //Some code that access the database } ?> and I need to use them both in the same page, I'd use the...

I am using javascript to open a new window, and the url that I'm sending always comes thru to the new page w/the ampersands stripped out. Here is the code that opens the new page. Dim s1 As String = "batch/batchPdf.aspx?type=candGar&GroupId=" & GroupId & "&ClientId=" & ClientId & "&CandId=" &...

I have a Userform for Excel that opens first and tests the database connection. If the connection can be established, I want to close that userform and open a new userform. So far, all I can do is hide the first form. Is there a way to close it? UserForm1.Hide UserForm2.Show Thanks!

Is there a quick way to test if this connection is open... like a try/catch block, or maybe the .Open function returns a result. I couldnt find anything online about it. Thanks in advance! Set objConnection = CreateObject("ADODB.Connection") objConnection.Open "Driver={SQL...

I cant get any of the changes I make to my asp pages to show up. I used to be an admin for our Tomcat servers, and whenever this would happen, I would have to clear out the cached pages to get it to work again. I think this is what is happening here, but I dont know anything about IIS. Where...

I have an object that stores some search data that the user will need to have around through the duration of the session. quick example: Public Class SearchList Private sqlString1 As String = "" Private sqlString2 As String = "" Private sqlString3 As String = "" //some get and set...

How do I bind an object to a session, and then retrieve it again? If this were Java, I could use... session.setAttribute("ObjName",Object); -and- session.getAttribute("ObjName"); I'm using vb.net to code this app. Thanks, Greg

How do I bind an object to a session, and then retrieve it again? If this were Java, I could use... session.setAttribute("ObjName",Object); -and- session.getAttribute("ObjName"); I'm using vb.net to code this app. Thanks, Greg

I have a function that checks for parameters in the query string, and from there determines which page to open up in a certain frame. The only problem is that if I try to hit the page without having a query string, I get a null pointer exception. I've tried several different methods for checking...

How can I save a word doc out as an html file w/out all the style elements Word automatically embeds? I found a post from a guy w/the same problem, but the very next thread was from him saying he found the plugin... so no help there. Any help would be greatly appreciated. THanks, Greg

Here is the code I have so far that basically makes a div element visible on a mouse over. STYLE SHEET======================================= div#links {font: 16px Verdana, sans-serif; } div#links a:hover {color: black; background: #AAA;} div#links a span {display: none;} div#links a:hover...

How would I go about applying a style to an element tag. This is how I'm displaying links to the page. <xsl:element name="a"> <xsl:attribute name="href">../templates/<xsl:value-of select="$templates//templates/template/n3/link"/></xsl:attribute> <xsl:value-of...

I'm trying to set up my asp.net application(vb) on a server running xp pro and iis5. Right now, I cant even get a simple aspx page to execute that I know works on my win. server 2003 pc. Heres the code... <%@Page Language="VB"%> <html> <body> <% Response.Write(DateTime.Now.ToString()) %>...

I'm using Oxygen as the xml generator, and so far I've had no trouble using an xsl stylesheet and an xml file to create an html file, but what I would like to do is use data from multiple xml files together with one xsl to create an html file... ex) company.xml + personel.xml + style.xsl =...

I've been asked to provide some kind of xml solution for mainting content in a web site. So far, I cant find any examples other than iterating thru records and displaying it in a table... I'm not even sure xml is a good idea. Heres a quick example of what I need to do. Suppose I have these...