You might be better off on the ADO/SQL Server forum.
I would guess that your problem is that you are attempting to read the value of the output parameter before you have closed the resultset that has been returned (or else you haven't got "set nocount on" specified in your stored procedure).
I want to populate datagrid with static string object. I have populated datagrid dynamically by getting data from database, but in my application i want to populate it with data given in my string object,not getting data from data base.
I would create a dataset. Add a DataTable to it. Add whatever columns to the datatable.
Insert your static stuff into the datarows. Point the Datatable.DefaultView as the datasource for your datagrid. Hope that helps.
I have an java applet which required the JRE 1.5 to run, now i need to program in such way that, is user is running on lower version. the plugin for jre should be installed without downloding the JRE or JDK...
var Phone = document.textMessage.celPhone
if(Phone.value == null || Phone.value == "")
this checks for the textboxt not to be empty
if(emptyValidation(textMessage, "The field is empty")== false)
checks for this text box not to be emtpy neither
// If these past conditions don't execute, then it wil go into
// this next function
window.open("sent.php", "sent_window", "location = no, status = no, width=200,height=200, menubar = no");
that would be the code for my popup.
on the sent.php page, code would be:
$CELPHONE = $_POST['celPhone'];
nothing seems to work on that popup page, but like i mentioned before, if keep it on the same page, (action = "sent.php") then, it works, but i need it to work on that popup.
The only thing I can think of off the top of my head is to set the target="_blank" attribute on the form to open it in a new window (BUT i'm not sure if this is a valid attribute of a form element? I suspect not, you'd have to check)
This is an ASP question, I hope this is the correct forum as I could not see an ASP only one.
I am working with dates in URLEndcode and have a date formatted 28/02/2007. When I URLEncode this on any of my in-house test servers no matter what locale (US / UK) LCID 2057(UK) / 1033(US) / 2048(opsys def) I have the / translated as a %2F Perfect.
On my hosted MS server (in Germany, defauly LCID = 1031). I get %2E.
This translates my date to 28.02.2007. The German way of handling dates.
I have Session.LCID = 2057 on each page but it makes no difference. it always encodes to %2E.
I have no control panel access to the server, is there anyway in my code I can effect the way Session.URLEndcode functions?
This has nothing at all to do with UrlEncode. It only has to do with how you convert the date into a string. UrlEncode doesn't change depending on the culture, it always encodes the string the same way.
UrlEncode doesn't encode a date, it only encodes strings. If you are trying to encode a date, it will implicitly be formatted into a string before it's sent to the UrlEncode method.
This is the output from the webpage. Also when I place my mouse over the link on the site IE show this as what going to be processed.
dToday = CDate(intThisMonth & "/" & intPrintDay & "/" & intThisYear)
I have this gives the 28/02/2007 I have also hard coded this for a test. Same Result...
I have the identical code runnnin on my local SQL Server and it gives the correct Value %2F (That's UK locale) I even try changing my LCID on my local machine, and I cannot break it..... Changing LCID on the hosted server just changes the format of the date, but not the encoded value.
The only difference is that this is a hosted server in Germany.... I've emailed the ISP but they generally don't get involved in coding issues, however I think this is something wrong, as / should always convert to %2F.