Jump to content

Siddhesh

Members
  • Posts

    49
  • Joined

  • Last visited

Posts posted by Siddhesh

  1. hi i am trying to validate html form with asp function , so the problem is how i will know which field is empty ,, this is the i wrote

    Is this the thing u required??<%dim name name = request.form("name")if name = "" then response.redirect = ("error.asp?name_null")ElseDim conn Dim rs Set Conn = Server.CreateObject("ADODB.Connection")conn.Provider="Microsoft.Jet.OLEDB.4.0"conn.Open(Server.Mappath("/webdata/atc.mdb"))set rs = Server.CreateObject("ADODB.recordset") RS.open "reg",Conn,2,2rs.AddNewrs.Fields("Name") = Request.Form("name")rs.Updaters.CloseSet rs = NothingSet Conn = Nothingresponse.redirct="confirm.asp"end if %>
  2. UPDATE Student    SET  Student_Name= Replace(Initcap(Student_Name),'S','K') WHERE  Initcap(UNIQUE_NAME) LIKE 'S%'

    Your aim of answer is Perfect, But the querry is giving me error as"'Initcap' is not a recognized function name."Can U help me?
  3. you can do that with a server side language. Select the names starting with s then do string manipulation and then update the records again.

    Thanx, that could be a solution.But I don't want to make any site, but only data-cleaning.Can I do it?Any other solution? I m Using SQL 2000
  4. Hi,I have a table Student With Column Student NameI want to do is thatThe Names Starting with 'S' , should start with 'K'e.g Students names areSid, Subbu, Sigma, suki..Then should be convert toKid, Kubbu, Kigma, Kuki....Thanx,Waiting...

  5. is there a way to refer to an element's ID to the point of making that element perform certain actions as detailed in a function?  For example, say I have a bullet list with an ID="listone" and a class="liststyleoff" I want to make it so when that list item is hovered over, the class is changed to "liststyleon" and when the mouse leaves the list item, the class returns to "liststyleoff".  thanks

    U can call function on OnMouseOver event of that element.and U can refer an element by its id as getElementById("listone").class = "liststyleon" / "liststyleoff";
  6. ok thanks,but how will i use this code. I mean ,where i will put this code.In my page has a link (link name is print page) and if user click to this link ,the page will be print this page.

    in The OnClick event of the link, or create a button, and onClick of that button u can call this function.
  7. im making a button and need to add text on it<input type="button" name="submit">and i was also wondering how to make it unclickable once you "submit"

    try This
    <HTML>    <HEAD>        <script>            function Fn_Click()            {                document.forms(0).Submit.disabled = true;            }        </Script>    </HEAD>    <BODY>        <Form>            <Input Type="Button" Name="Submit" Value="Submit" OnClick="Fn_Click();">        </Form>    </BODY></HTML>

  8. I have a text area set up in my page with a javascript array in the code... What i wanna do is for example enter some numbers in my text area like so :50 as [0]60 as [1]70 as [3]etc...

    I m not giving u the perfect solution but you can try doing something like....For The Textarea on keypress event call a function.If The Key pressed is ENTER then add that element into a javascript aray.last element u can get by searching last and 2nd last Enter..This is the logic according to me.there may be better way.
  9. In order to list all employees in Norway and USA I'm using this query:------------------------------------------------SELECT E_Name FROM Employees_NorwayUNION ALLSELECT E_Name FROM Employees_USA------------------------------------------------I get this resultName ----------------------Hansen, Ola Svendson, Tove Svendson, Stephen Pettersen, Kari Turner, Sally Kent, Clark Svendson, Stephen Scott, Stephen Thanks!!

    Try thisSelect *From (SELECT E_Name FROM Employees_Norway UNION ALL SELECT E_Name FROM Employees_USA) Table_AliasOrder By E_Name
  10. Is this the thing you want??

    <html>	<head>		<script type="text/javascript">			function disp_prompt()			{				var name=prompt("Please enter your name","")				var Age=prompt("Please enter your Age","")				if (name!=null && name!="")				{					if (Age != null && Age != "")					{						document.write("Hello " + name + "! Your age is "+ Age);					}									}			}		</script>	</head>	<body>		<form>			<input type="button" onclick="disp_prompt()" value="Display a prompt box">		</form>	</body></html>

  11. I have 2 tables: "ROBOTS" and "REFERRALS"Each table has a column called "IP"I want to run a query that removes all of the "IP" addresses in REFERRALS that are in the "IP" list in ROBOTS.What I have tried so far is:
    SELECT REFERRALS.IPFROM REFERRALSWHERE REFERRALS.IP<>ROBOTS.IP;

    I am very new to SQL so I'm hoping this is an easy thing to do?

    This may help uSelect IP from ReferralWhere IP Not In(Select IP from Robots)
  12. I'm looking to find out if anyone knows how to restrict the number of options a user can choose within a multiple option form field.  Let's say you have a form field that has 11 options available to choose, but you want to limit the user choices to 3 of the 11 that are available.  Is this possible and, if so, can anyone shed some light as to how it can be done?thank you.

    Can you repeat the question in more simple wayWhat type of option you r talking aboutCheckBoxes,Radio buttons,Multiple selection Dropdowns,or List?By the way the check can be done using javascript in your code
  13. here is a sample of my code:the problem is that if text is entered eveything is fine. however, when a number is entered, the validation takes place BUT once the validation has taken place, it executes the next statement (in bold). however, i would like it keep re-checking for numbers and THEN once the validation is satisfied ie text with no numbers, only then should it move on to the next statement (in bold)

    if (firstname != "") {   if (firstname.match(/\d/) != null)   {       alert("you have entered a number");       return false;   }}else {    alert("Please enter your First Name");   return false;}if (lastname.length == 0) {  alert("Please enter your Second Name");  frmShuffle.lastName.focus();  return false;}

    Is this the solution??

  14. 1 last thing... should this work:
    function changeContent() { 	var section = document.navMenu.view.value;	If (section == "alpha") {	side.innerHTML="testing!";                // OR document.getElementById("side").innerHTML = "testing!";	}}

    cos it aint... lol .. says there's an error..

    Hey coll down just check the if conditionChange If to ifmake I small in the if conditionits javascript remember nothing starts with a big letter
  15. still not getting my yay tho :S

    r u using only this code or other event to call this function?Because ur function should gt invoked by some eventOkif u want to see the result do the following
    <script type="text/javascript">	var test = "alpha";	if(test=="alpha") 	{      document.write("YAY!");	}</script>

    Note that "I" of if is small and not Big;Or Put a button in the html page and onclick event of that button call the function

    <script type="text/javascript">function test() {	var test = "alpha";	if(test=="alpha") 	{      document.write("YAY!");	}}</script>

    If u don't want to introduce html try the first code

  16. But this doesnt work... any help? wb help much appreicated!

    <script type="text/javascript">function changeContent() {		var section = document.navMenu.view.value;	side.innerHTML="testing!";                // OR document.getElementById("side").innerHTML = "testing!";}</script>

    <form name="navMenu"> <select name="view">   <option value="alpha">Alphabetically</option>   <option value="category">By Category</option>   <option value="common">Most Common</option>   <option value="search">By Search</option> </select>  <input type="button" value="Go" onClick="changeContent();" /></form><div id="side"> blah blah</div>

    This thing is working

  17. well i been having a lot of javascript problems since i started learning.. and they come about when i start using if statements. for example i made this. i have no clue whats wrong here but it wont work :S
    <script type="text/javascript">function test() {var test = alpha; If (test == "alpha") {     document.write("YAY!"); }}</script>

    very simple.. yet it wont work :S

    Just change the linevar test = alpha;By var test = "alpha";Because in the first case variable test is assign the value of variable alpha which is any random value.bye
  18. I have a website which we'll call 'Admin' where I can go in as an admin and create records that then display on another website which we'll call 'Groups'.  I would like to order my records on the 'Group site' to display the last record I updated as the first record on the page.  Is there a SQL statement that I can add in my 'Group' page instead of my Order by group_name or do I have to change it for the 'Admin' site for it to work?

    You can use SQL statement on ur group page as " Order By Update_Date Desc "
  19. where would i put this function and the browser doesn't seem to recognise this { symbol. sorry to be a pain.Here value is right wordCODEfunction Fn_Drd_Change(Combo, Text){      eval("document.forms(0)."+ Text +".value = document.forms(0)."+ Combo +".value");}

    U might have recognise that this is javascript function .So u have to write it in the script tagLike---
    <Html>           <Head>                      <script>                              function Fn_Drd_Change(Combo, Text)                               {.....write the function here......}                      </Script>           </Head>             <%   Put Your ASP function/Code here              %>           <Body><Form>                        Put your dropdowns here           </Form></Body></Html>

    I think this will serve ur purposeMy explanation skill is not so good.

  20. shouldn't the "value" be "price". or is this an added variable name?

    So sorry U r rightIve change the code. Change the function as
    Sub Fillcombo (TableName, name, price)SQL= "SELECT " & name & " , "& price&" FROM " & TableNamers.Open SQL, conn If Not rs.EOF Then    Do While Not rs.EOF         %> <Option value=<%= rs("price")%>><%= rs("name")%></Option>        <%        rs.MoveNext    LoopEnd Ifrs.CloseEnd Sub

    Then in ur form use the following

    <P><Select Name="Drd1" OnChange=" Fn_Drd_Change('Drd1','Txt1')"><% Call  Fillcombo("BAKERYandCAKES", "name","price") %></Select><INPUT Name="Txt1" Value=""></P>..

    Please use different name for all dropdowns and text boxesfunction in javascriptHere value is right word

    function Fn_Drd_Change(Combo, Text){        eval("document.forms(0)."+ Text +".value = document.forms(0)."+ Combo +".value");}

    I didn't try it but will work

  21. sql="select * from cars where car_id='" & Request("car") & "'; " and where fuel_type ='" & Request("car") & "'; " the above coding does not work...it comes with an end of statement error after the Request("car") & "'; partCan anyone help me..MANY THANKS.AND THE WHERE CLAUSES ARE SELECTED FROM A PICKLIST

    First check ur Sql StatementThe simple code query isSelect * from Table_Name where Field1=' Value1' and Field2=' Value2 'In ASP we can writesql="select * from cars where car_id=' " & Request("car") & " ' and fuel_type =' " & Request("car") & " ' " I Think this will help uBye
  22. what is sql command which can i use please help me  :)

    hi,I think this is SQL related problem and not ASPOk,U can place Specialization code along with User data i.e. which type of Specialization he is related.and according to the login u can decide the the type of specializationSorry if i'v taken ur problem in wrong way
×
×
  • Create New...