Search:

Now to take this further...How could I (on an ASP page) ask that for each control of type CheckBox, that its Font be turned to Bold if .Checked = true?

I can get to a point to where it checks...

Thanks...I'll give that a shot...but should it be
Select @SqlString = or
SET @SqlString = ?

This probably has a really simple solution...

I have one stored procedure that can be used for either of two tables. Depending on the parameter passed in (A or B), I would like the SP to look at...

I'm embarking on a one-man project and am looking to cut down my development time. I'm looking at a 3-5 month timeframe for overall development here and out of the 7 people on my team I'm the only...

I'm dumping the contents of a DataSet into a grid. The user then has the option to dump the grid's contents to a CSV file. Right now I've hard-coded the column names into the writing of the CSV file,...

The main form in my project currenly contains a menu item labeled "TEST":


Me.ctxMnuMainNewTest.Text = "TEST"

This simply opens up our test form, which is great while in development. Now,...

Bruce, dude...thanks!

-Mike

I'm sorry, I'm being a bit misleading I guess.

The query will actually be running outside of Query Analyzer, so even if I make that setting it might be a short-term fix. What I'm looking for is a...

I don't have it right now...but it's like any other query in Query Analyzer, where the output includes the columns...there must be a way to suppress that.

I tried:


SELECT EmployeeID ' ' FROM...

All I need to do is write the results of a SQL query to a text file (mission accomplished).

Problem is, the column names are going with the contents, and I don't want that.

How can I prevent...

How do you do this in SQL 2000?

Thanks,
Mike

Yeah, I failed to read that...

I have been looking at this proc for too long, and cannot figure out the final problem I'm having.

The below code creates the SQL Query. It then wraps that in...

Wow.

I was just going to disagree and tell you it's not writing to the server, but it is...and it works. I love accidental success.

Thanks!

Unfortunately that didn't get the file to write. It still, in Query Analyzer, shows a result of "NULL" with no file being written, but if I take the same query and manually plug it into a command...

...minus the EXEC part being commented out. Even if it's not it doesn't work.

Thanks,
Mike

I'm just trying to test this functionality. When I plug the command line code into a command prompt, it writes the file. If I run from Query Analyzer, it doesn't...it's the exact same command, am I...

I want to run a stored proc using xp_cmdshell so that search results will be dumped to a file and uploaded.

I have set up a user with EXEC rights on xp_cmdshell, but the set always comes up...

I stripped a form out of an Access Database that is responsible for extracting from a SQL Database then FTP'ing that data to another server. It gives me an error on the Inet component that

I...

I'm using the following query:


SELECT pd.InceptionDate, pd.ExpiryDate, cd.LimitAmt, cd.Deductible1Value, tt.PKTransType, tt.TransTypeLDesc FROM PolicyDetails pd, CoverageData cd,...

How does this translate into VB.net? Any ideas? It's the one line that's not compatible in our app. The Left function is considered an integer...If you could just let me know what this does (dump...

Is it possible to run a console application that will need to write messages based on the status of other solution(s) that it is responsible for launching? I just want the console to display...

The errors I'm getting are on the lines with a *.

I can't figure out what the problem is, I have very similar syntax in other projects, even dealing with the same classes with no problem. I have...

No, it's part of our project and I need to use that in order to get back the data I need.

Thanks for the assistance though.:D

~Mike

That's the problem...I'm not sending a SQL Statement saying



To be honest I'm not even sure how the search manager is getting its dataset back to me. I just send it the dates for which I want...

Ok, look out below...

Public Function CreateFileFromDataSet(ByVal filename As String) As File
Dim fw As StreamWriter
Dim File As File
Dim ReadString As New...

I'm populating a DataSet by creating a SearchRequest object with today's date in a function of type DataSet. Is there a way that I can select exactly which data I want to pull out of the DataSet?...

Legal in that it's not giving me errors, yes, but in terms of our project architecture, we shall see.

Thanks again.

ws.si.search.User is a reference to the User object in the ws.si.search web service. ConsoleApplication1 is my app, and I'm trying to create the user object from that end, and passing it along...

So how would I resolve something like that?

I'm trying to do essentially the same thing as other solution-to-solution projects, and I even have the same references and everything..

Thanks,...

I've got 3 errors in my app level that say something like:



The first line of code responsible for two of the errors is:
Dataset = m_wsJobManager.PolicySearch(GetUser(m_User),...

I'm trying to debug an application that contains references to two other solutions that exist on two different tiers. For the most part the application itself runs fine, but I am having trouble...

Also...I am taking 'success' ByVal...should it be ByRef instead? I'm also finding that if I get to the web service and manually change 'success' to True, it becomes false when I get to the app...

No,

If it's False, it stays False.

I think my problem is the fact that I initially define it at the app level, then carry it down two tiers, then back up to the top. I think that when I bring...

I have a 3-tiered FTP application going. I need to pass a success boolean from the app to the web service, to the back-end layer that does all the work. If the FTP is successful, I need the success...

I didn't even have the correct user set up in SQL Server...that was my problem...

~Mike

Now my application is just giving me a WebException and is timing out. Yuck.

If that fixes it I will be super frustrated with myself! I'll let ya know Monday.

Thanks!

I have a connection string that is allowing me to return a data set from a SQL Server. Here is my connection string:



That user is correctly set up on the server, yet when I run the...

ChrisSte,

What is the syntax of the string you're using? I need to do what you're doing, but in .NET...

Thanks,
Mike

Server-based timer meaning the Task Scheduler?

~Mike