Another smaller issue! (slinki)

Message by slinki on 7/3/2008 6:14:05 PM EST
Hi

I am trying to get the values from selected checkboxes and convert them into a string similar to this format (word 1, word 2, word 3, word 4, word 5...) and to put this new string into an empty text box but I am having difficulties when coming across (%) symbols imitating whitespaces in my string. For some reason, when collecting values from checkboxes, I always seem to have these (%) problems.

My function, below, is working but it only removes the first (%) symbol in the string. As I will show here (word 1, word%2, word%3, word%4, word%5...). There is obviously something wrong with the For loop, but don't know how to fix Javascript too good!

[code language="javascript"]
function GetNamesAndPaste()
{
var name_str = "";
var new_name_str = "";
for (var i=0; i < document.searcher.people_boxes.length; i++)
{
if (document.searcher.people_boxes[i].checked)
{
name_str = name_str + document.searcher.people_boxes[i].value + ", ";
new_name_str = name_str.replace(/%/, " ")
document.searcher.people.value = new_name_str;
}
}
}
[/code]

Is there anyone out there that could possibly alter my script slightly, so it removes all %'s from the string.

Also, I am being left with 2 annoying trailing characters - a comma and a space (, ) - I need a function/script that will grab the last 2 characters of the string, check to see if the characters are the annoying comma and space and remove them if they are.

Any help is appreciated...

Sounds like you just need... (bill wilkinson)

Message by bill wilkinson on 7/3/2008 4:09:47 PM EST
...to start by learning the basics of ASP, period.

You might want to get a good book on ASP (or give up on obsolete old ASP and sensibly move to ASP.NET, of course!).

Failing that, you might look here:
http://www.LearnAsp.com/Learn
look especially at the FORM "lessons" and the DATABASE "lessons". (They aren't really lessons, more just examples, but they are the best I've found for ASP. The tutorials available for ASP.NET are many many many times better than this.)

Yeah, good point... (bill wilkinson)

Message by bill wilkinson on 7/3/2008 4:06:02 PM EST
Worth trying first, to see if it works, but otherwise...

Oh, crud...wish this forum allowed edit... (bill wilkinson)

Message by bill wilkinson on 7/3/2008 4:04:33 PM EST
Sorry...fixing that last query:

SQL = "SELECT * FROM Tracker " _
& " WHERE CDATE(SysDate) BETWEEN #" & SummaryStart & "# AND #" & SummaryEnd & "# " _
& " ORDER BY SiteList, TaskType, Task"

LOL! Thanks, Andrew! (bill wilkinson)

Message by bill wilkinson on 7/3/2008 4:02:38 PM EST
I think. I'm not sure that I need more work. <grin/>

Okay, let's take an example.

Say you do, indeed, use
WHERE SysDate between '4/29/2008' AND '5/7/2008'

Now consieder the date of '4/5/2008'

When you do STRING comparisons--which is what is happening since you screwed up bigtime by making those fields be TEXT fields instead of DATE/TIME fields--the comparisons are done *character by character*. And the FIRST place where the two characters are different determines the "sense" of the comparison.

So let's first compare
'4/5/2008'
'5/7/2008'
We start with the first characters: '4' versus '5'. WHAMMO. Immediately we see that they are not the same. The '4' is less than the '5', so the "sense" of the overall comparison is
'4/5/2008' < '5/7/2008'

Now let's compare
'4/29/2008'
'4/5/2008'
Again, character by character:
'4' and '4' are the same. continue.
'/' and '/' are the same. continue.
'2' and '5' are different! '2' is less than '5', so the *sense* of the overall comparison is
'4/29/2008' < '4/5/2008'

And so, *OF COURSE* we get a TRUE value for the expression
WHERE SysDate between '4/29/2008' AND '5/7/2008'
which has become
WHERE '4/5/2008' between '4/29/2008' AND '5/7/2008'

The obvious answer to this is to stop misusing your database and convert all those text values to DATE/TIME. In Access, that's trivial. Open up the table in DESIGN TABLE view. Change the field type to DATE/TIME. Close the design. Say OK. You are done.

Now, if there is some silly-ass reason you can't do that (e.g., you are working with a read-only database that somebody else mis-designed), there actually *IS* a solution:

SQL = "SELECT * FROM Tracker " _
& " WHERE CDATE(SysDate) between #(SysDate)" & SummaryStart & "#(SysDate) AND #(SysDate)" & SummaryEnd & "#(SysDate) " _
& " ORDER BY SiteList, TaskType, Task"

It's not as efficient. Because now even if SYSDATE is indexed, the query engine will go read every record. But it works. CDATE() is a function in both VBScript and Access that converts a string to a date/time value.

If you can't modify the pages... (bill wilkinson)

Message by bill wilkinson on 7/3/2008 3:46:04 PM EST
...you are stuck. Period.

And I will say again and again and again: You do *NOT* need to close the recordsets. If you have a memory leak, I would make a reasonably large sized bet with you that it is *NOT* related to recordsets. It's almost surely related to some OTHER component.

This assumes that you are using IIS 3 or above and ADO version 2.1 or above. And that you are using OLE or ODBC providers created by Microsoft.

you are making bad assumption (bill wilkinson)

Message by bill wilkinson on 7/3/2008 3:43:02 PM EST
Read this:
http://msdn.microsoft.com/en-us/library/aa258277(SQL.80).aspx

THERE IS NO POSSIBLE WAY that SQL Server can *NOT* store a date and time that is accurate to the nearest 3 milliseconds.

Period.

BUT...

But you don't HAVE to use the "raw" GetDate() value.

If all you care about is the *DATE* (and *NOT* the time) then just convert the value from GETDATE() to a date-only value. Thus:
CONVERT( DATETIME, CONVERT( VARCHAR(10), getDate(), 112 ), 112 )

And then, in your VBS code, *INSTEAD* of using NOW() you should use DATE() to get a date-only value.

Incidentally, you *CAN* do a "bulk update" on the current values in your DB, easily:
UPDATE tbl_lcCases SET dateContacted = CONVERT( DATETIME, CONVERT( VARCHAR(10), dateContacted, 112 ), 112 )

Presto. All those date+time values will become date-only values.

You can also do dateDue at same time:
UPDATE tbl_lcCases
SET dateContacted = CONVERT( DATETIME, CONVERT( VARCHAR(10), dateContacted, 112 ), 112 ),
dateDue = CONVERT( DATETIME, CONVERT( VARCHAR(10), dateDue, 112 ), 112 )

P.s.: You don't need to do
CDATE( NOW() )
or
CDATE( DATE() )
they are already *guaranteed* to be date/time values.

P.p.s.: YOu could do
DateValue( Request("dateDue") )
to ensure that you are using a date-only value here, as well.

RE: SQL Dates with decimals? (shadowvixen)

Message by shadowvixen on 7/3/2008 3:29:07 PM EST
Will I hose my dates stored in datetime if i convert to smalldatetime with the data still in the table or should i export, change and reimport? Thanks!!!

Well, I would say that the problem is... (bill wilkinson)

Message by bill wilkinson on 7/3/2008 3:26:52 PM EST
...that Either BOF or EOF is True.

Actually, EOF is true, guaranteed. Since directly after creating a recordset, BOF can be true if and only if EOF is also true. Ergo, no matter what EOF is true.

So why do you doubt the veracity of the message?

Patently and obviously, your SQL query is returning exactly zero records. Ergo, EOF is true.

Now...

WHERE IS YOUR DEBUG????

Specifically, where is your
Response.Write "DEBUG SQL: " & strSQL & "<HR>"
or equivalent???

And then, *AFTER* you see what Response.Write shows you, go try the *exact same query* in your DB tools and see what you get.

RE: Classic ASP to ASP.NET Getting Started (AndrewSQLDBA)

Message by AndrewSQLDBA on 7/3/2008 3:15:18 PM EST
.NET has session variables. What is your code behind language? You can also do that in OOP

Andrew SQLDBA

Either BOF or EOF is True... (robert475)

Message by robert475 on 7/3/2008 3:13:08 PM EST
Hi everyone

I seem to have a slight problem with this query:

SELECT repno,monearly,monam,monpm,moneve,tueearly,tueam,tuepm,tueeve,
wedearly,wedam,wedpm,wedeve,thuearly,thuam,thupm,thueve,
friearly,friam,fripm,frieve,sat1am,sat1pm,sat2am,sat2pm,sat3am,
sat3pm,sat4am,sat4pm,sunam,sunpm
FROM permanent_shift_changes where repno = '"&Session("reps")&"'

If i was to run this query in query analyzer it returns records, but when i aplly it to my asp page it returns the following error:

Error Type:
ADODB.Field (0x80020009)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

Now the bizarre thing is that if i change the from clause - permanent_shift_changes to a similar table to (same table design but different records) the page will run.

I think i have made the mistake in my coding along the lines, could someone help point out where i am going wrong please?

Thanks very much.

Code:

SQLQuery = "SELECT repno,monearly,monam,monpm,moneve,tueearly,tueam,tuepm,tueeve,wedearly,wedam,wedpm,wedeve,thuearly,thuam,thupm,thueve,friearly,friam,fripm,frieve,sat1am,sat1pm,sat2am,sat2pm,sat3am,sat3pm,sat4am,sat4pm,sunam,sunpm FROM permanent_shift_changes where repno = '"&Session("reps")&"'"

set psc = db.execute(SQLQuery)
%>

<td bordercolor="#000000"><%= psc("monearly") %></td>
<td bordercolor="#000000"><%= psc("monam") %></td>
<td bordercolor="#000000"><%= psc("monpm") %></td>
<td bordercolor="#000000"><%= psc("moneve") %></td>
<td bordercolor="#000000"><%= psc("tueearly") %></td>
<td bordercolor="#000000"><%= psc("tueam") %></td>
<td bordercolor="#000000"><%= psc("tuepm") %></td>
<td bordercolor="#000000"><%= psc("tueeve") %></td>
<td bordercolor="#000000"><%= psc("wedearly") %></td>
<td bordercolor="#000000"><%= psc("wedam") %></td>
<td bordercolor="#000000"><%= psc("wedpm") %></td>
<td bordercolor="#000000"><%= psc("wedeve") %></td>
<td bordercolor="#000000"><%= psc("thuearly") %></td>
<td bordercolor="#000000"><%= psc("thuam") %></td>
<td bordercolor="#000000"><%= psc("thupm") %></td>
<td bordercolor="#000000"><%= psc("thueve") %></td>
<td bordercolor="#000000"><%= psc("friearly") %></td>
<td bordercolor="#000000"><%= psc("friam") %></td>
<td bordercolor="#000000"><%= psc("fripm") %></td>
<td bordercolor="#000000"><%= psc("frieve") %></td>
<td bordercolor="#000000"><%= psc("sat1am") %></td>
<td bordercolor="#000000"><%= psc("sat1pm") %></td>
<td bordercolor="#000000"><%= psc("sat2am") %></td>
<td bordercolor="#000000"><%= psc("sat2pm") %></td>
<td bordercolor="#000000"><%= psc("sat3am") %></td>
<td bordercolor="#000000"><%= psc("sat3pm") %></td>
<td bordercolor="#000000"><%= psc("sat4am") %></td>
<td bordercolor="#000000"><%= psc("sat4pm") %></td>
<td bordercolor="#000000"><%= psc("sunam") %></td>
<td bordercolor="#000000"><%= psc("sunpm") %></td>
</tr>
<%
reps.movenext
Loop
reps.close
db.Close
%>
</table>
</body>
</html>

RE: SQL Dates with decimals? (AndrewSQLDBA)

Message by AndrewSQLDBA on 7/3/2008 3:13:06 PM EST
Do you need to store dates down to the millisecond level? If not, the change the data type to smalldatetime.

The date range for SQL and the date range for VBScript are different. Also, you would want to either not show the milliseconds on your form. I would actually use a calender control, or a set of DDL's to let the user pick a date, and not allow them to type in a date. That way, they will input exactly what you want.

Andrew SQLDBA

RE: Access DB and Select Between Problems.... (AndrewSQLDBA)

Message by AndrewSQLDBA on 7/3/2008 3:08:02 PM EST
Anytime that you want to store dates in a database, use a column with a date data type. You will never get what you want by having those two columns as text.

Change the data types and use the database like it was designed to be used.

Bill Wilkinson explains it best. Bill, if you like, please tell them about proper database design and using the correct data types.

Andrew SQLDBA

RE: ASP Drop Down (snrice)

Message by snrice on 7/3/2008 2:32:25 PM EST
Thanks, for responding. It's with the connection to the drop down boxes. I'm using ASP and SQL. Here what I have and I'm not sure what to do. I need the page to connect to the SQL database and pull retieve the state.

tr>
<td align=left width="164" height="25">Install Location State:</td>
<td align=left height="25"><input type =text name="tbInstallLocationState" value="<%=Session("InstallLocationState")%>" size="2" maxlength="2"
style="width: 36px"></td>
</tr>

This worked but why?? (eramgarden)

Message by eramgarden on 7/3/2008 2:27:35 PM EST
1.If I create a hiddlen checkbox :
<asp:CheckBox runat="server" ID="CheckBox1" OnCheckedChanged="chkSameAsBilling_CheckedChanged" AutoPostBack="true" style="display:none;" />

2.remove autopostback from the original checkbox

3. and do this:
chkSameAsBilling.Attributes["onclick"] = "if(btnValidate() " + CheckBox1.ClientID + ".click();"

that works..validates and does a post back.But why??

Tried this as well but no postback (eramgarden)

Message by eramgarden on 7/3/2008 2:16:26 PM EST
Changed the checkbox to this:

[code language="VB.Net"]
<asp:CheckBox ID="chkSameAsBilling" Text="Use Billing Address" runat="server" onclick="chkSameAsBilling_CheckedChanged" Font-Size="12px" />
[/code]

and the event to this:
chkSameAsBilling.Attributes.Add("onclick", "return btnValidate();");

*** calls the javascript but doesnt do a post back.

Click event of a checkbox and Javascript (eramgarden)

Message by eramgarden on 7/3/2008 1:46:49 PM EST
i have a checkbox like this:

[code language = "VB.Net"]
<asp:CheckBox ID="chkSameAsBilling" Text="Use Billing Address" runat="server" OnCheckedChanged="chkSameAsBilling_CheckedChanged"
AutoPostBack="true" Font-Size="12px" />
[/code]

I want to call a JS function first to make sure textboxes are not blank, then call the OnCheckedChanged event of the checkbox.

I did this..this calls the JS, returns true but it doesnt do a post back. I tried several things..removed the autopostback, removed the event call from aspx page, used onclick. Any ideas:

[code language="C#"]
// chkSameAsBilling.Attributes.Add("onclick", "return btnValidate();");
chkSameAsBilling.Attributes["onclick"] = "return btnValidate();" + chkSameAsBilling.Attributes["OnCheckedChanged"];

[/code]

Don't ever touch the one... (Xanderno)

Message by Xanderno on 7/3/2008 1:36:50 PM EST
In the .Net Framework directory. That's strictly the default configuration, and should never have application specific settings in it. The only reason it should ever change is if the server administrator wants to make global policy changes. If you're dealing with a setting for a website, or an application, that should always go in the web.config file in your application/site directory.

Access DB and Select Between Problems.... (sqlhunter)

Message by sqlhunter on 7/3/2008 12:12:19 PM EST
...ok I know I am doing somthing simple wrong here, but I cant seem to reconcile it. I know you guys are smarter then me so here is an easy one for ya...

I have a page that queries an access db to get a Range of data.

Example: Select * from Table where SysDate Between SummaryStart and SummaryEnd Order by blah blah....

What happens is sometimes I get Data that is NOT between the Start and Ends...Why?

Here is the code: The field is a TEXT filed in Access, but I am storing Dates so maybe there is an issue...

Select * from Tracker where SysDate between '" & SummaryStart & "' and '" & SummaryEnd & "' Order by SiteList, TaskType, Task ASC

Some Sample Data from the Database:
SysDate Task TaskType
4/29/2008 Work my Butt Off Maintenance
4/30/2008 Work my Butt Off Maintenance
4/30/2008 Slacker Maintenance
5/7/2008 Sleeping Enhancement
5/7/2008 Crying Enhancement
5/9/2008 Nothing Maintenance
5/12/2008 Work my Butt Off Enhancement

Any thoughts on what I may be doing wrong would be appreciated. To Reiderate, I do a range say from 4/29/2008 to 5/7/2008 but I get data from eairler in the month of April and also in other months, I dont understand. Somtimes some of the dates that are returned dont even fall between the range at all,

RE: blocking form values (shadowvixen)

Message by shadowvixen on 7/3/2008 11:13:25 AM EST
Hey Ken - you could use a standard from validation script but use instr to see if the string in your field contains either of your values.

http://www.w3schools.com/Vbscript/func_instr.asp

Recent Posts on ASPMessageboard.com