Web Development

23-Apr-07 1:52

Hi Guys,

I have this weird results from my parameters.

I am trying to update one of the table and the thing that i noticed was, one of the parameter doesn't give the exact value, I think. Because it doesn't update the data that I selected thru dropdownlist.

Below is my SQL Statement on how to update the table:

UPDATE tblTitle_Category SET Cat_ID = @Cat_ID WHERE (PlayID = @PlayID) AND (Cat_ID = @Cat_ID2)

Parameters:

All the parameter values came from different textboxes, and the textboxes as I displayed it on my page, all of them has a value @PlayID = 5, @Cat_ID = 34, @Cat_ID2 = 35.

Problem:

It doesn't update at all. The value of @Cat_ID which is 34 does not saved.

But when I tried typing the number "34" (hard coded), then it will update.

What do you think is the problem and how can I correct it. My code is perfectly coded. Is this a bug?

Thanks in advance Guys

hifiger2004

Re: BUG IN PARAMETER OF ASP.NET 2.0 ? [modified]

RichardGrimmer23-Apr-07 5:50

RichardGrimmer

23-Apr-07 5:50

hifiger2004 wrote:
My code is perfectly coded

I bet it isn't Smile | :)

Can you post the DB Access code - looks like it's there that yer problem lies...

"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox

hifiger200423-Apr-07 6:48

23-Apr-07 6:48

Hi Richard,

Sounds like you're already know if what the problem is Smile | :)

Ok it's goes like this...
-------------------------------------------------------
First I have a table named tblTitle_Category and has only two fields - "PlayID" and "CatID".
And then I have also another table named tblCategories which contains only two fields - "CatID" and "Description".

tblTitle_Category:
PlayID CatID
1 1
1 2
2 3
2 4
3 5
3 6

tblCategories:
CatID Description
1 Liquid
2 Solid
3 Stone
4 Wood
5 Steel
6 Place

So, we have now a tblTitle_Category table and tblCategories table. And inorder to link them both, of course we need to join them using the Left Outer Join SQL Statement.

ASP.Net 2.0 Web Controls used:

1 - GridView, used for non editable records, only viewing purposes.
2 - DetailsView, used for inserting, editing and deleting of records.

GridView's SQLDatasource Statement:
Select tc.PlayID, tc.CatID, c.Description * From tblTitle_Category tc
Left Outer Join tblCategories c on tc.CatID = c.CatID

DetailsView's SQLDatasource Statement:

Select:
Select tc.PlayID, c.Description * From tblTitle_Category tc
Left Outer Join tblCategories c on tc.CatID = c.CatID

Insert:
Insert Into dbo.tblTitle_Category
(PlayID, CatID)
Values
(@PlayID, @CatID)

Edit:
Update dbo.tblTitle_Category
Set CatID = @CatID
Where PlayID = @PlayID and CatID = @CatID2

In my DetailsView I have a template for DropDownList for tblCategory.Description.

I have 3 parameters for editing existing record by just changing the tblCategory.Description thru the DropDownList.

Parameters:

@PlayID = From Other GridView source (I checked the value thru msgbox and the value is correct)
@CatID = TextBox1.Text (The value of TextBox1.Text is the CatID based on the DropdownList
selection that I passed).
Code below:

Protected Sub DropDownList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As
System.EventArgs)
TextBox1.Text = CType(sender, DropDownList).SelectedValue
End Sub

@CatID2 = TextBox2.Text (The value of TextBox2.Text is CatID based from the GridView's CatID)

And, that's all. It's very simple, isn't it? Smile | :)

But I really don't know if why the category can't be saved when I select another category from the DropDownList.

I am hoping that you can simulate this one, and I think you will get the same problem Smile | :)

By the way I am using MSSQL2005. Anyway, Access DB will do.

Thanks in advance.

-- modified at 12:59 Monday 23rd April, 2007

hifiger2004

marky77723-Apr-07 23:24

marky777

23-Apr-07 23:24

What are the data types(and lengths) of the fileds in those tables?

hifiger200423-Apr-07 23:29

23-Apr-07 23:29

All ID fields are integer "int". PlayID and CatID fields were declared as int.

hifiger2004

marky77723-Apr-07 23:37

marky777

23-Apr-07 23:37

Just to be sure, why don't you parse the ID's to the update as int's first before doing the update?

I'm not sure if this is your problem, but it wouldn't hurt to do it Smile | :)

hifiger200424-Apr-07 2:04

Developing a new Site with FrontPage

24-Apr-07 2:04

I parse all ID's, and I even tried converting the parameter value passed into integer just to be sure, but still the problem is there Smile | :)

hifiger2004

matjame22-Apr-07 23:03

matjame

22-Apr-07 23:03

Im starting a new site using FrontPage and Im still clueless when coming to a few things like, getting expandable menus on buttons, and marqueing text(moving text).

Please help, where you can Roll eyes | :rolleyes:

kagiso

Re: Developing a new Site with FrontPage

Michael Hendrickx22-Apr-07 23:29

Michael Hendrickx

22-Apr-07 23:29

My best answer, but it won't help you much, is to stay away from Frontpage, as it is limited and will make you frustrated.

The moving text, is called a marquee, and holds the <marquee> tags. Maybe worst case scenario, you can have the part that you want to be moving, and put it in marquee tags.

Expandable menu's on buttons.. can be done with CSS. Do you want something like a folded out menu?

www.code.ae

Re: Developing a new Site with FrontPage

JimmyRopes27-Apr-07 19:10

display data from database base on user input

27-Apr-07 19:10

matjame wrote:
Im starting a new site using FrontPage

As Michael Hendrickx said FrontPage is not a good editor. It will put things in the code to ensure that the page will not render on anything but IE. GoLive is not much better as you will also have cross browser compatibility problems, just not the same problems as FrontPage.

Getting HTML to render properly on a wide variety of browsers is like trying to herd cats. They all have their own agenda and it is not the same as any other.

I would recommend using an HTML editor, like HTML-Kit and learning how to hand code HTML. It really isn't that difficult once you get past the basics and HTML-Kit has templates to get you started with the basic framework. HTML-Kit is a free download.

Separate the layout from the presentation using CSS and you will be able to make site wide changes in one place as opposed to going through every page looking for formatting parameters.

Go to W3C HTML Tutorial[^] if you would like to get started learning HTML.

HTML looks daunting at first but it is easy once you get used to it. Then you can move on to javascript and a server side scripting language to make dynamic pages. There are a lot of examples on the web so it is easy to get examples of working code.

Simply Elegant Designs JimmyRopes Designs
Think inside the box! ProActive Secure Systems

I'm on-line therefore I am.
JimmyRopes

dheema22-Apr-07 22:58

dheema

22-Apr-07 22:58

please ,anyone who can help me as soon as possible,i need the code,asp code,to take input from user and display this specific user information from my database, Confused | :confused:

Reg web dialer

NasimKaziS22-Apr-07 21:20

NasimKaziS

22-Apr-07 21:20

I require a software component to be added to an existing .net application(web based). The coponent or the software should posses the following features:

1. It should provide PC to Phone integration either on VOIP technology or TAPI or both.
2. It should provide automated phone dialing from phone number lists.
3. Transfer calls to other users internally.
4. Record conversations and provide automated call reports and statistics.
5. Every phone number in the system should be automatically clickable and the call details must be logged to that user.
6. The phone call must be recorded and stored as a sound file.

Can anyone help me to find any freewares or commercial products available in the market which can provide me the above features.

Thanks in Advance

----------------------------------
where there is a will there is a way

javascript to input masked date __/__/____

DineshSharmain22-Apr-07 20:49

DineshSharmain

22-Apr-07 20:49

how can i make an input mask on textbox for a date mm/dd/yyyy. example input 16/07/1975. initially it should be displayed like __/__/____ and if i enter a digit then underscore should be replaced by that digit rest should remain same.

any help would appreciate..
thanks..

Dinesh Sharma

Re: javascript to input masked date __/__/____

coolestCoder22-Apr-07 20:58

coolestCoder

22-Apr-07 20:58

I dont know much about javascript, but you can use the MaskedEdit extender from AJAX toolkit. Its much easier. I know you will have to use the OnKeyPress type of event to do this. Also the OnBlur event. But I am not sure how to do this in javascript. If possible try using the AJAX control I suggested. Hope I helped you in some manner ?

"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder

coolestCoder

changing a radio button programmatically

JimmyRopes21-Apr-07 12:11

Re: changing a radio button programmatically

21-Apr-07 12:11

Is there a way to change change the button that is checked in a radio button group programmatically?

I have a group of buttons that control the presentation of a web page. That is if a button is clicked a form expands to offer more options. Originally that part of the form is hidden and it is only visible if the yes button in a yes/no group is clicked. Originally the no button is checked by default.

I set a state variable for future reference and hide the buttons from view. Everything works fine transitioning from view to view unless the refersh browser control is pressed for a reset of the form.

On Opera original state of the form is visible, as it should be, and the no button is checked, as it should be. This is consistant with the original form the first time it is loaded.

On FF the yes radio button is clicked but the form is not expanded which is inconsistant. To make matters worse I need to first click the no button to get the yes button to respond again. Even though it is checked it is not active until the other button is clicked.

On IE both buttons are unchecked and the form is in original state. Not quite consistant with the original state of the page but at least a click on the yes button expands the form.

If I can re-check the no button before I hide the buttons things would work consistantly on FF and Opera.

If I could uncheck both buttons I could use that on the original page and at least things would be consistant on all three browsers.

My question is how do I click a radio button programatically in javascript? Or failing that how do I uncheck a checked button (the yes button) programmatically in javascript?

Simply Elegant Designs JimmyRopes Designs
Think inside the box! ProActive Secure Systems

I'm on-line therefore I am.
JimmyRopes

Fred_Smith22-Apr-07 0:29

Fred_Smith

22-Apr-07 0:29

For example:

<input type="radio" name="group1" id="radButton1">
<br />
<input type="radio" name="group1" id="radButton2">
<br />

<script language="javascript">

</script>

cheers
F

Re: changing a radio button programmatically

JimmyRopes22-Apr-07 2:24

22-Apr-07 2:24

Thanks - That is what I need to do. Big Grin | :-D

Simply Elegant Designs JimmyRopes Designs
Think inside the box! ProActive Secure Systems

I'm on-line therefore I am.
JimmyRopes

email probelm in php

kumar bharat bhusanam21-Apr-07 5:51

kumar bharat bhusanam

21-Apr-07 5:51

hi I am not getting email in russian language.The email content is partly comming from database and partly entered by the user. It is a html mail. I am getting correct email in english. But when I am changing email language to russian the output of mail content look like-------------

hi ÐÐºÐ°Ð´ÐµÐ¼Ð¸Ñ Ð¤ÐµÐ´ÐµÑ€Ð°Ð»ÑŒÐ½Ð¾Ð³Ð¾ Ð°Ð³ÐµÐ½Ñ‚ÑÑ‚Ð²Ð° ÐŸÑ€Ð°Ð²Ð¸Ñ‚ÐµÐ»ÑŒÑÑ‚Ð²ÐµÐ½Ð½Ð¾Ð¹ ÑÐ²ÑÐ·Ð¸ Ð¸ Ð¸Ð½Ñ„Ð¾Ñ€Ð¼Ð°Ñ†Ð¸Ð¸ Ð¿Ñ€Ð¸ Ð¿Ñ€ÐµÐ·Ð¸Ð´ÐµÐ½Ñ‚Ðµ Ð Ð¾ÑÑÐ¸Ð¹ÑÐºÐ¾Ð¹ Ð¤ÐµÐ´ÐµÑ€Ð°Ñ†Ð¸Ð¸

--------- This is not in russian language
Plz. help me!!!

Bharat Bhusanam

Re: email probelm in php

JimmyRopes21-Apr-07 12:22