Type: Posts; User: Bill Wilkinson
Search took 1.26 seconds.
What you *SAID* was:
SELECT Cust_ID, SUM(Amount) AS Total
WHERE Cust_Type = 'KDF'
GROUP BY Cust_ID
ORDER BY Cust_ID
I quote you "....if CUST_Type = KDF then Sum Amount...
No code, no help. You will need to show us the code that is doing this.
Well, good luck. I do feel it's a mess that could be MUCH simplified. Certainly no reason to use ReturnURL unless you allow people to login from multiple .aspx pages.
In other words, you seem to want to show them a message *BEFORE* sending them to hiddenfile.aspx.
You can *NOT* do that with Response.Redirect. You can only use Response.Redirect...
I assume you mean you want to display that message for a few seconds and then auto-direct them to the new site?
It's all right here:
Dim manager = New UserManager()
Dim user As ApplicationUser = manager.Find(username.Text, password.Text)
UserManager is a library class that handles all the SQL...
Yes, one (or more) of your fields really is "too short" to hold the data you are trying to insert.
You will have to inspect the table's schema (list of fields and field types and field sizes) to...
Yes, and about 90% of it is verified. Oh, the stuff older than 1600 or so is suspect, but even the 1600s are pretty accurate. Helps to have a common ancestry with Richard Nixon, for example. ...
Is it possible that the href is now incorrect? That is, your new page is not in the same folder as the old page? If so, one easy answer is to use the *FULL URL* of the CSS file in the href. Yes,...
Thanks very much! I've been wanting to put my tree onto my own site for some time now.
Here's my grandson's tree on RootsWeb:...
I have to ask you: Where did you get the GEDCOM database from??
That is, where did you find a program that will convert a ".ged" to a ".mdb"???
Yes, the problem with UN-checked checkboxes is that *NOTHING* is sent from the browser to the server for them!
So indeed you might have an array of 5 comments, but if only 2 checkboxes where...
If you are *REALLY* worried about efficiency then I say again: Do *NOT* use a LOOP! Learn to use regular expressions. They are *AT LEAST* an order of magnitude (10 times, that is) more efficient....
Ready to kick yourself?
connstr2 ="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("/db/GEDCOM.mdb") & ";"
Set GEDCOM = conn.Execute(selSQLtxt)
Finally, probably the fastest and shortest code would be a variation on the RegExp version:
' at the top of your page someplace:
Set isAlpha = New RegExp : isAlpha.Pattern = "^[a-zA-Z]+$"
Even if you think you need to use a loop, for some reason, you can do it more efficiently:
Function isAlpha( str )
Dim i, ch
str = UCase(str)
For i = 1 To Len(str)
ch = Mid(...
I would surely HOPE that you could improve on code from September 7, 1999!
But your code DOES NOT WORK!!! Did you even bother to test it???
if testValue > 64 AND teestValue < 91 then...
You ready to kick yourself?
Look at the "Requested URL": http://localhost:50662/Account/Login
WHERE does it say "Login.aspx" there? Unless you have your web.config file set to redirect...
Searching in files is tedious at best.
You really have no choice but to open each file, read in all its contents, search through all the text in the entire file, somehow write out/highlight lines...
If you use code such as
Set location to database
location = Server.MapPath("../data/someAccessFile.mdb")
' DSN-less connection string
connStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data...
I got it!!! One trick was to use MultiLine. The other was to use $1 (as shown) in the replacement.
str = "this line ends in a period." & vbNewLine _
& "this line has no period but 3...
var str =...
I don't understand this, at all. First you say
But then you are using your code to do
If strFormat = "HTML" Then
strHTMLStart = "<html><head><style type=""text/css"">body...
There'a a much easier way to do that, you know.
mytime = "18:03:15"
prettyTime = FormatDateTime( CDate(mytime), vbLongTime )