Jump to content

safetyweek

Members
  • Content Count

    32
  • Joined

  • Last visited

Community Reputation

0 Neutral

About safetyweek

  • Rank
    Newbie
  • Birthday 10/16/1971

Contact Methods

  • Website URL
    http://
  • ICQ
    0
  1. Hi there. I have this error in the windows server 2003 and this error cancel the sharings folders.Can you help me? Thanks in advance. Event Type: InformationEvent Source: Application PopupEvent Category: NoneEvent ID: 26Date: 21/09/2011Time: 17.08.55User: N/AComputer: E036Description:Application popup: svchost.exe - Application Error : The instruction at "0x0135f4b6" referenced memory at "0x0135f4b6". The memory could not be "written". Click on OK to terminate the programClick on CANCEL to debug the program For more information, see Help and Support Center at http://go.microsoft.com/fwlink/
  2. Thks, I try your suggestion and use Join in the two tables, but I have this output: DSPq DSP asx nos ins sca inl ese supertotXI T 72 0 0 72 39 498 498XM L 2 0 0 2 2 2.459 2.459XO C 52 0 0 70 5 3.204 3.204XS S 76 0 0 145 44 392 392Tot Tot 202 0 0 289 90 6.553 6.553 And not this (correct): DSPq DSP asx nos ins sca inl ese supertotXI T 72 0 0 72 39 498 2.638XM L 2 0 0 2 2 2.459 5.646XO C 52 0 0 70 5 3.204 7.894XS S 76 0 0 145 44 392 2.456Tot Tot 202 0 0 289 90 6.553 18.634 The sql qu
  3. Thks, I understand your suggestion but the problem is the output is generate with this code ASP: <!-- #include virtual="/include/conn_mysql.asp"--><% sql = " SELECT "..." //The query union of my #1 post Set rs = Server.CreateObject("ADODB.Recordset") rs.Open sql, cn if not rs.eof then Response.write "<br><div align=center>" Response.write "<center>" Response.write "<TABLE BORDER=1 CELLPADDING=0 CELLSPACING=0 style=""border: 1px Solid #6699CC;""><tr><td>" Response.write "<TABLE BORDER=1 CELLPADDING=2 CELLSPACING=
  4. Ok, but I don't have change in the code:<html><head><meta http-equiv="Content-Type" content="text/html; charset=windows-1252"><title>Output</title></head><body><div align=center><TABLE BORDER=1 CELLPADDING=0 CELLSPACING=0 style="border: 1px Solid #6699CC;"><tr><td><TABLE BORDER=1 CELLPADDING=2 CELLSPACING=2 style="font-size=11px;font-family:tahoma;" width="100%" BGCOLOR=WHITE><tr bgcolor=#dcdcdc><td align=center><b>DSP</b></td><td align=center><b>tot</b></td><td alig
  5. I don't not... this is the output/format generate with ASP, what is wrong? :<div align=center><center><TABLE BORDER=1 CELLPADDING=0 CELLSPACING=0 style="border: 1px Solid #6699CC;"><tr><td><TABLE BORDER=1 CELLPADDING=2 CELLSPACING=2 style="font-size=11px;font-family:tahoma;" width="100%" BGCOLOR=WHITE><tr bgcolor=#dcdcdc><td align=center><b>DSP</b></td><td align=center><b>tot</b></td><td align=center><b>asx</b></td><tr bgcolor=#F6F6F6><td align=center>T</td><td
  6. Yes, the problem is formatting issue, but the output is the response of MySQL and the response with server side language (ASP).
  7. thanks for your reply.the problem is the output, the values of asx are rights.I need this output:DSPq | DSP | tot | asxXI | T | 2.638 | 72XM | L | 5.646 | 2XO | C | 7.894 | 70XS | S | 2.456 | 145Tot | Tot | 18.634 | 289 Not this: DSPq | DSP | tot | asxXI | T | 2.638 |XM | L | 5.646 |XO | C | 7.894 |XS | S | 2.456 |Tot | Tot | 18.634 | 72 2 70 145 289
  8. safetyweek

    Query Union All

    Hi there, I need your help.I need union the queries for this output: DSPq DSP asx nos ins sca inl ese tot_1XI T 72 0 0 72 39 498 2.638XM L 2 0 0 2 2 2.459 5.646XO C 52 0 0 70 5 3.204 7.894XS S 76 0 0 145 44 392 2.456Tot Tot 202 0 0 289 90 6.553 18.634 Try this Query Union, but I have this output: DSPq | DSP | tot | asxXI | T | 2.638 |XM | L | 5.646 |XO | C | 7.894 |XS | S | 2.456 |Tot | Tot | 18.634 | 72 2 70 145 289 Can you help me?Thanks in advance. SELECT COALESCE(DSP,
  9. Hi there, I need your appreciated help.I have this tables in MySQL /*Navicat MySQL Data TransferSource Server : _MySQL_MSource Server Version : 50045Source Host : 10.7.4.3:3306Source Database : testTarget Server Type : MYSQLTarget Server Version : 50045File Encoding : 65001Date: 2011-04-01 11:53:06*/SET FOREIGN_KEY_CHECKS=0;-- ------------------------------ Table structure for `_mytabledef`-- ----------------------------DROP TABLE IF EXISTS `_mytabledef`;CREATE TABLE `_mytabledef` ( `xID` int(11) NOT NULL auto_increment, `_CE` varchar(255) default NULL, `Name` varchar(255) defau
  10. Yes Sir, this script now working... :)Thanks for ur appreciated help.
  11. Last version of the function `CheckmyForm()` (working!): function CheckmyForm() {for ( var n = 0; n < myform.elements.length; n++ ) { var field = myform.elements[n]; if (field.value.length <= 0) { window.alert('Check all fields!'); field.focus(); field.select(); return; } } if (!myform.TextareaS1.value.match("^[a-zA-Z0-9\.;,:'? ]{1,100}$")) { window.alert("Error in textarea!"); myform.TextareaS1.focus(); myform.TextareaS1.select(); return; } else { alert("OK."); } }
  12. Thanks, I understand.... function CheckmyForm() { if ( myform.DatesT1.value.length <= 0 ) { alert("KO 1."); myform.DatesT1.focus(); } if ( !myform.TextareaS1.value.match("^[a-zA-Z0-9\.;, ]{1,100}$") ) { alert("KO 2."); myform.TextareaS1.focus(); } else { alert("ok."); } }
  13. Thanks Sir.I try this RegExp but not working... function CheckmyForm() { var re1 = new RegExp("^[a-zA-Z0-9\.;, ]{2,100}$"); if ( myform.DatesT1.value.length > 0 && myform.TextareaS1.value.length > 0 ) { alert("ok."); } else { if (myform.TextareaS1.value.match(re1)) { alert(Error!'); myform.TextareaS1.focus(); } alert("ko."); myform.DatesT1.focus(); } }
  14. Hi there.I need ur appreciated help.This is the function CheckmyForm.I need check that you enter only letters, numbers and special characters ",", "." and ";" in the TextareaS1 field.Can u help me? function CheckmyForm() { if ( myform.DatesT1.value.length > 0 && myform.TextareaS1.value.length > 0 ) { alert("OK!."); } else { alert("KO!."); myform.DatesT1.focus(); } }
  15. Hi there.I need insert the values of this form (printed in the asp Label) in the database MySQL.Can u help me? <%@ Page Language="C#" %><%@ Import Namespace="System.Data" %><%@ Import Namespace="System.Data.Odbc" %><%@ Import Namespace="System.Configuration" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><script runat="server">public void Page_Load (Object sender, EventArgs e){ OdbcConnection myConnectionString = new OdbcConnection(ConfigurationManager.ConnectionStrings ["ConnMySQL
×
×
  • Create New...