Search results for query: *

ok, so throw in a script to make the page auto-refresh ala here: http://www.javascriptkit.com/script/script2/autofresh.shtml ...come to think of it... a messagebox is probably a blocking event, right? would the underlying page be able to refresh before the messagebox was closed? i don't think...

er, maybe remove the .tostring fucntions when later using isdbnull. whupps.

SqlCommand1.Parameters("@name").Value and SqlCommand1.Parameters("@password") are not variables you get as a part of the response from SQL, you're testing on something that hasn't to do with the success or failure of the query. you need to do something with the results of the query, whether...

here's how i use RegisterStartupScript to do popups. RegisterStartupScript's significance is only making sure the alert doesn't appear twice. there's design concerns you'll become aware of while trying popups, such as the back button will make the messages pop up again, but this should get you...

i've been working on a solution to secure the delivery of pdfs to client browsers. we're introducing an public-website element, so i've decided to use a webservice on the internal application webserver to pass a pdf as a byte array to a public webserver outside the LAN, where it can be forwarded...

sql2000. must.. preview.. posts..

if this is indeed an error in sql2002 and there is presumably no correct means of creating and distroying the table, maybe you can change your logistics so that the table always exists, and throw some logistics on it such that you set it to some detectable state that you can use to represent...

yes, actually, but it's something of a hack, as ANY solution would have to be due to the rediculous absence of .getcurrentpagenumber() in the webform crystalreportviewer object. note though, the function exists in the windows forms crystalreportviewer object. Here is the entire function I use...

nobody? i wouldn't imagine i'm the only one who wants to accomplish this... -g

wrapped the loanamt denominator in a cdbl() function and it worked. what the heck ever. thppppt. -g

spread is a calculated value in the query (decimal to 3 places), loan amt is money. when i said won't compile, i referred to the fact that i can't save the formula field without it prompting when i try to save, "there is a syntax error with the formula", then point me to the...

argh, this makes no sense, the following code won't run: if Sum ({procSoldLoansConfByInvRpt;1.Loan Amt})>0 then sum({procSoldLoansConfByInvRpt;1.Spread}) / Sum ({procSoldLoansConfByInvRpt;1.Loan Amt}) else 0 i get an error Sum ({procSoldLoansConfByInvRpt;1.Loan Amt}) is not a number so sum(a)...

Working in Crystal for .net03: I'm having a hard time getting the current page displayed by the ASP.net CrystalReportViewer. I got the total page count via CStr(reportDocument.FormatEngine.GetLastPageNumber(crViewer.RequestContext())) but I can't figure out how to get the CURRENT page...

I'm working on some forms for a sqlserver asp.net webforms application. These forms will deal with only one db record's information at a time. It appears that only simple controls (combobox etc) and the all-powerful datagrid control have binding and committal functionality. Therefore I see my...

sage advice, you're absolutely right. -g

Well, I found my problem. Values I presumed were already of an appropriate scope were not. Such as "adOpenStatic". Turns out vbscript was just creating them and defaulting to zero. So now I have some statements above the prior posted code like "adOpenStatic = 3", and all is...

Hunh. Worked. I wish i had the spare time to spend figuring out the difference between our code. thanks much. -g

...integrated sec .Open End With 'fill an array with a query dim arr() objrs.CursorType = adOpenStatic objRS.Open "Select top 20 * from loan_info", objConn, adOpenStatic dim iii iii = 999 'If objRS.Supports(adBookmark) = True Then ' iii = objrs.RecordCount 'end...

I'm attempting to format an automatically output excel file before the user receives it. I've succeeded in freezing the panes as I need to, but I'm having some troubles setting the background color of the title row. I can see the code I already have does indeed set the bg color, but then it is...

ordinarily, yes. i happened to have been using access in a more server-side role, dumb as that is, to generate website-downloadable reports in PDF. On the multi-processor server, the subtasks of outputting to postscript and then converting to pdf were overlapping, converting the same ps to pdf...