Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Member
46 Points
45 Posts
Feb 22, 2012 03:04 AM|LINK
<script language="javascript"> createXML("../XML/BizCard.xml"); <% DbUtil dbutil = new DbUtil(); DataSet ds; DataSet ds2; DataSet ds3; int iFirstCheck = 1; string sSetDefaultOption = ""; for (int i = 1; i<=5; i++) { Response.Write ("\n\n\nvar listB" + i.ToString() + " = new DynamicOptionList(\"Material" + i.ToString() + "\",\"Product" + i.ToString() + "\");\n"); ds = dbutil.get_dataset (@"SELECT prid, prcode, prlongdesc FROM tbrProduct WHERE (prid='1') ORDER BY prlongdesc"); foreach (DataRow dr in ds.Tables[0].Rows) { Response.Write ("listB" + i.ToString() + ".addOptions(\"" + dr["prcode"].ToString() + "\""); ds2 = dbutil.get_dataset (@"SELECT pacode, palongdesc, pwcode, pwdesc FROM tbrPaper Pa, tbrProduct Pr , tbrPaperWeight PW, tbrProduct_Paper PP WHERE Pr.prcode = '" + dr["prcode"].ToString() + "' AND PP.ppprid = Pr.prid AND PP.pppaid = Pa.Paid AND PP.pppwid = PW.pwid AND PP.status ='1' ORDER BY pwdesc, palongdesc"); foreach (DataRow dr2 in ds2.Tables[0].Rows) { Response.Write(",\"" + dr2["pwdesc"] + "gsm " + dr2["palongdesc"].ToString() + "\",\"" + dr2["pacode"].ToString() + dr2["pwcode"].ToString() + "\""); if (iFirstCheck == 1) { sSetDefaultOption += "listB" + i.ToString() + ".setDefaultOption(\"" + dr["prcode"].ToString() + "\",\"" + dr2["pacode"].ToString() + dr2["pwcode"].ToString() + "\")\n"; iFirstCheck = 0; } } Response.Write (");\n"); iFirstCheck = 1; } Response.Write(sSetDefaultOption); Response.Write ("\n\n\nvar listC" + i.ToString() + " = new DynamicOptionList(\"Volume" + i.ToString() + "\",\"Product" + i.ToString() + "\",\"Material" + i.ToString() + "\");\n"); ds = dbutil.get_dataset (@"SELECT prid, prcode, prlongdesc FROM tbrProduct WHERE (prid='1') ORDER BY prlongdesc"); foreach (DataRow dr in ds.Tables[0].Rows) { ds2 = dbutil.get_dataset (@"SELECT pacode, palongdesc, pwcode FROM tbrPaper Pa, tbrProduct Pr, tbrPaperWeight Pw ,tbrProduct_Paper PP WHERE Pr.prcode = '" + dr["prcode"].ToString() + "' AND PP.ppprid = Pr.prid AND PP.pppaid = Pa.Paid AND PP.pppwid = Pw.pwid ORDER BY pwdesc, palongdesc"); foreach (DataRow dr2 in ds2.Tables[0].Rows) { Response.Write ("listC" + i.ToString() + ".addOptions(\"" + dr["prcode"].ToString() + "|" + dr2["pacode"].ToString() + dr2["pwcode"].ToString() + "\""); ds3 = dbutil.get_dataset(@"SELECT DISTINCT pppvolume FROM tbrProduct_Paper_Price PPP, tbrProduct_Paper PP, tbrProduct Pr, tbrPaper Pa, tbrpaperweight PW WHERE PPP.ppid = PP.ppid AND PP.pppwid = PW.pwid AND PP.ppprid = Pr.prid AND PP.pppaid = Pa.paid AND PR.prcode = '" + dr["prcode"].ToString() + "' AND PA.pacode = '" + dr2["pacode"].ToString() + "' AND PW.pwcode ='" + dr2["pwcode"].ToString() + "'"); foreach (DataRow dr3 in ds3.Tables[0].Rows) { Response.Write(",\"" + dr3["pppvolume"].ToString() + "\",\"" + dr3["pppvolume"].ToString() + "\""); } Response.Write (");\n"); } } } Response.Write("var ppptype = \"" + Request.Cookies["cpricetype"].Value + "\";"); %>
thanks for your reply. here is the part which cannot work in chrome.
dicman
Member
46 Points
45 Posts
Re: javascript / createXML cannot work in googlew chrome "Object #<Document> has no method 'load'...
Feb 22, 2012 03:04 AM|LINK
<script language="javascript"> createXML("../XML/BizCard.xml"); <% DbUtil dbutil = new DbUtil(); DataSet ds; DataSet ds2; DataSet ds3; int iFirstCheck = 1; string sSetDefaultOption = ""; for (int i = 1; i<=5; i++) { Response.Write ("\n\n\nvar listB" + i.ToString() + " = new DynamicOptionList(\"Material" + i.ToString() + "\",\"Product" + i.ToString() + "\");\n"); ds = dbutil.get_dataset (@"SELECT prid, prcode, prlongdesc FROM tbrProduct WHERE (prid='1') ORDER BY prlongdesc"); foreach (DataRow dr in ds.Tables[0].Rows) { Response.Write ("listB" + i.ToString() + ".addOptions(\"" + dr["prcode"].ToString() + "\""); ds2 = dbutil.get_dataset (@"SELECT pacode, palongdesc, pwcode, pwdesc FROM tbrPaper Pa, tbrProduct Pr , tbrPaperWeight PW, tbrProduct_Paper PP WHERE Pr.prcode = '" + dr["prcode"].ToString() + "' AND PP.ppprid = Pr.prid AND PP.pppaid = Pa.Paid AND PP.pppwid = PW.pwid AND PP.status ='1' ORDER BY pwdesc, palongdesc"); foreach (DataRow dr2 in ds2.Tables[0].Rows) { Response.Write(",\"" + dr2["pwdesc"] + "gsm " + dr2["palongdesc"].ToString() + "\",\"" + dr2["pacode"].ToString() + dr2["pwcode"].ToString() + "\""); if (iFirstCheck == 1) { sSetDefaultOption += "listB" + i.ToString() + ".setDefaultOption(\"" + dr["prcode"].ToString() + "\",\"" + dr2["pacode"].ToString() + dr2["pwcode"].ToString() + "\")\n"; iFirstCheck = 0; } } Response.Write (");\n"); iFirstCheck = 1; } Response.Write(sSetDefaultOption); Response.Write ("\n\n\nvar listC" + i.ToString() + " = new DynamicOptionList(\"Volume" + i.ToString() + "\",\"Product" + i.ToString() + "\",\"Material" + i.ToString() + "\");\n"); ds = dbutil.get_dataset (@"SELECT prid, prcode, prlongdesc FROM tbrProduct WHERE (prid='1') ORDER BY prlongdesc"); foreach (DataRow dr in ds.Tables[0].Rows) { ds2 = dbutil.get_dataset (@"SELECT pacode, palongdesc, pwcode FROM tbrPaper Pa, tbrProduct Pr, tbrPaperWeight Pw ,tbrProduct_Paper PP WHERE Pr.prcode = '" + dr["prcode"].ToString() + "' AND PP.ppprid = Pr.prid AND PP.pppaid = Pa.Paid AND PP.pppwid = Pw.pwid ORDER BY pwdesc, palongdesc"); foreach (DataRow dr2 in ds2.Tables[0].Rows) { Response.Write ("listC" + i.ToString() + ".addOptions(\"" + dr["prcode"].ToString() + "|" + dr2["pacode"].ToString() + dr2["pwcode"].ToString() + "\""); ds3 = dbutil.get_dataset(@"SELECT DISTINCT pppvolume FROM tbrProduct_Paper_Price PPP, tbrProduct_Paper PP, tbrProduct Pr, tbrPaper Pa, tbrpaperweight PW WHERE PPP.ppid = PP.ppid AND PP.pppwid = PW.pwid AND PP.ppprid = Pr.prid AND PP.pppaid = Pa.paid AND PR.prcode = '" + dr["prcode"].ToString() + "' AND PA.pacode = '" + dr2["pacode"].ToString() + "' AND PW.pwcode ='" + dr2["pwcode"].ToString() + "'"); foreach (DataRow dr3 in ds3.Tables[0].Rows) { Response.Write(",\"" + dr3["pppvolume"].ToString() + "\",\"" + dr3["pppvolume"].ToString() + "\""); } Response.Write (");\n"); } } } Response.Write("var ppptype = \"" + Request.Cookies["cpricetype"].Value + "\";"); %>thanks for your reply. here is the part which cannot work in chrome.