Search results for query: *

What is the data type of the order by fields? This can play a significant role in determining order. I.e. if the data type is varchar, 10000000 comes before 5, 200, 4000. But if the data type is int, the order would be 5,200,4000,10000000.

Yeh I already have that. The problem is that I don't want to select anything. It would be like the textbox with the checkbox beside it, enabling it or disabling. I guess I could Union Select null as field1, but I would have thought that 2005 RS would not make dropdown params required. Thanks...

http://msdn2.microsoft.com/en-us/ms154537.aspx

You need to convert the date to a varchar, give it an alias, and group on the alias. Get rid of the timestamp field. You will NEVER be able to get what you want because of that field. You can't sum it, so you have to group by and group by with timestamp never works.

SQL 2005 RS I have 5 dropdown parameters, of which only one is required. All 5 are populated by a dataset. I have checked allow nulls and blanks for the 4 that are not required. The SP that I wrote is written in dynamic sql, so it tests for null values for all params, and only includes...

You need to provide the credentials in the SQL 2000 data source when deploying.

You could write the logic into your sql statement instead of handling it on the front end. Just use a case statement. select case when field1 is null then "do this" else "do this" end field1alias, field2 from table

I would guess you had some javascript or other coding errors inside one of your head tags. The page stops compiling and never gets to the </HEAD> tag. -Chad

Hey guys, thanks for responding. Tek-Tips was down for me for a while so I did some more research and found this. http://www.superdotnet.com/Article.aspx?ArticleID=85 It works awesome. Thanks again!

No, I mean delete the content of the XML file, and reqrite everything again.

Rtomes, XML is a requirement. I would much rather use a db. Ca8msm, There will be only one person accessing it at a time. Can anyone answer my question about having to blow away the entire XML file and recreating it everytime there is a modification? Thanks

I am looking for a good tutorial on reading, writing and modifying XML in C#. This is the approach I think I should use. Read the XML file and put it in a dataset. Manipulate the dataset as needed, and write it back out to the XML file. I guess I am suppose to blow away the entire XML...

I forced namedpipes and it recognized it immediately after. Thanks for the help.

We have set up SQL 2000 to use Windows Authentication. There is one person who gets Login Failed for user Null when they try to connect, whether it be Query Analyzer or setting up an ODBC connection. There are 19 of us that have no problems. However, there was one difference. He had mapped...

Thanks for the reply. I do not want to store customer's credit cards. I would rather have a proven application to do the work, because when it comes to people's money things can get messy. Anyone else have any ideas?

I have a client that has a membership only website. The user would pay for either monthly or yearly subscription and this would be recurring. I am open to all gateways (paypal, auth.net, verisign etc). This site will have 1000+ users. I also want the solution to integrate into the current...

I think you have one of two options. Create another procedure for this instance or modify the old code to use the new procedure. To do what you want, you have to pass in the column name (that you want to sort by)to the stored procedure that you want to sort by. The problem is that you can't...

what is the exact error?

Use session variables. Session("blah") = whatever 'variable you want to store On the pages that don't take request.querystring... Dim string1 as string string1 = Session("blah")

You have to give permissions to ASPNet user and IUSR. Also, you have to go into DCOM config and give permissions there to ASPNet.