vastu
-
Posts
9 -
Joined
-
Last visited
vastu's Achievements
Newbie (1/7)
0
Reputation
-
Hello friendsI have a database containing voters information. It contains about 120 tables according to Polling station, having names of voter. Iam using listbox to list all the Polling stations. The problem is I want to retrive results individually from all the tables making query on the basis of name of voter using a single query screen and result screen.Provide me with the code if u can
-
hello friends i require ur help for embedding the flash file on to my web page.i m using flash5 at present.code i m using is also included <td > <object width="550" height="25"><param name="movie" value="Movie1.swf"><embed src="c:\inetpub/wwwroot/csit/Images/Movie1.swf" ></object> </embed></object></td>
-
-
hello friends ,i want to know whether i can use button in my front page and set connection to the data base and check whether the connection is set and if set then link is set to the next page else an error mesg is displayed . Urgent help is required as i have to submit my project by 2nd april. i tried thex followingcode but was not successfull <INPUT type=button value=RLAUrban name=RLAUrban onclick=" <!--#include file = "dconn_rla.asp" -->" style="FONT-WEIGHT: bold; FONT-SIZE: larger; WIDTH: 243px; HEIGHT: 36px" size=50 action="<%if objConn=="true" then<a href="http://127.0.0.1/muneet/l_QuerymainP.asp"></a>else<a href="http://127.0.0.1/muneet/puneet.asp"></a>end if%>> [ objConn is a connection variable]
-
[ what i wana do is when i click on the urban/rural the respective file containing connection should be called and if the connection is successful the link should go to the next query page else error message should be displayed. there r two differnt dedicated servers containing data about rural and urban.
-
[
-
-
hello friends i want to call a connection to a database by clicking a link on a frontpage(RLA Urban, RLA Rural) and if the connection is sucessful then it should go to the next query page else it should display a error mesg. there r two such links in the front page. Iam giving the code bellow iam using . Please Help <%@ Language="VBScript" %><% Response.Buffer = True On Error Resume Next %><%dim URBANif URBAN = "True" then <!--#include file = "dconn_rla.asp" --> else <!--#include file = "dconn_rlaR.asp" --> END IF%> <HTML><HEAD><META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0"></HEAD><BODY background=http://127.0.0.1\csit\images\wd06.gif scroll=yes> <IMG src="http://127.0.0.1\csit\images\logohp.jpg"><TABLE style="WIDTH: 152px; HEIGHT: 252px" cellSpacing=1 cellPadding=1 width=152 align=left border=0> <tr><td> <P> <a href="http://127.0.0.1/csit/cm_profile.asp"><IMG style="WIDTH: 82px; HEIGHT: 135px" src="http://127.0.0.1/csit/images/cm-hp.gif" border=0 ></a></P></td></tr> <tr> <td> <P> <a href ="http://127.0.0.1\csit\Engmenu.asp"><IMG style="WIDTH: 52px; HEIGHT: 78px" height=78 src="c:\inetpub\wwwroot\csit\images\buttn.gif" width=62 border=0></a></P></td></tr><tr> <td> <strong> <font size=6 color=yellow>Menu</font></strong></td></tr><tr> <td> <a href ="http://127.0.0.1/csit/main.asp"><IMG style="WIDTH: 52px; HEIGHT: 78px" height=78 src="c:\inetpub\wwwroot\csit\images\buttn.gif" width=62 border=0></a></td></tr><tr > <td align=left> <strong><font size=6 color=yellow>Home</strong></font> </td></tr></TR></TABLE><center><table><tr> <td><font size=6 color=red><strong>Select The Appropriate Category</font> </td></tr><TR><td><p> </p> </td></TR><TR><td><p> </p> </td></TR> <table align=center style="WIDTH: 302px; HEIGHT: 50px" id=TABLE1> <p> </p> <TBODY> <TR><a href="http://127.0.0.1/muneet/puneet.asp"> <td bgcolor=burlywood align=middle><font size=5 color=red><strong>Procedure and Rules For Getting a Licence</strong></font></td></a></TR><TR><td></td></TR><TR><td> <p> </p> </td></TR> <TR><td><p> </p> </td></TR><TR><td><p> </p> </td></TR><TR> <a href="http://127.0.0.1/muneet/l_QuerymainP.asp"><td bgcolor=burlywood align=middle > <font size=5 color=red><strong>RLA Rural </strong></font></td></a></TR></table></center></BODY></HTML> 2) <%Dim Urbanset Urban = Server.CreateObject("ADODB.connection")Urban.ConnectionString = "Driver={SQL Server};Server=e-govrural;Database=sarthi;Uid=ts_sarthi;Pwd=ts_sarthi;"Urban.Open%><%'--------------------------------------------------------------------' Microsoft ADO'' Copyright (c) 1996-1998 Microsoft Corporation.'''' ADO constants include file for VBScript''--------------------------------------------------------------------'---- CursorTypeEnum Values ----Const adOpenForwardOnly = 0Const adOpenKeyset = 1Const adOpenDynamic = 2Const adOpenStatic = 3'---- CursorOptionEnum Values ----Const adHoldRecords = &H00000100Const adMovePrevious = &H00000200Const adAddNew = &H01000400Const adDelete = &H01000800Const adUpdate = &H01008000Const adBookmark = &H00002000Const adApproxPosition = &H00004000Const adUpdateBatch = &H00010000Const adResync = &H00020000Const adNotify = &H00040000Const adFind = &H00080000Const adSeek = &H00400000Const adIndex = &H00800000'---- LockTypeEnum Values ----Const adLockReadOnly = 1Const adLockPessimistic = 2Const adLockOptimistic = 3Const adLockBatchOptimistic = 4'---- ExecuteOptionEnum Values ----Const adAsyncExecute = &H00000010Const adAsyncFetch = &H00000020Const adAsyncFetchNonBlocking = &H00000040Const adExecuteNoRecords = &H00000080Const adExecuteStream = &H00000400'---- ConnectOptionEnum Values ----Const adAsyncConnect = &H00000010'---- ObjectStateEnum Values ----Const adStateClosed = &H00000000Const adStateOpen = &H00000001Const adStateConnecting = &H00000002Const adStateExecuting = &H00000004Const adStateFetching = &H00000008'---- CursorLocationEnum Values ----Const adUseServer = 2Const adUseClient = 3'---- DataTypeEnum Values ----Const adEmpty = 0Const adTinyInt = 16Const adSmallInt = 2Const adInteger = 3Const adBigInt = 20Const adUnsignedTinyInt = 17Const adUnsignedSmallInt = 18Const adUnsignedInt = 19Const adUnsignedBigInt = 21Const adSingle = 4Const adDouble = 5Const adCurrency = 6Const adDecimal = 14Const adNumeric = 131Const adBoolean = 11Const adError = 10Const adUserDefined = 132Const adVariant = 12Const adIDispatch = 9Const adIUnknown = 13Const adGUID = 72Const adDate = 7Const adDBDate = 133Const adDBTime = 134Const adDBTimeStamp = 135Const adBSTR = 8Const adChar = 129Const adVarChar = 200Const adLongVarChar = 201Const adWChar = 130Const adVarWChar = 202Const adLongVarWChar = 203Const adBinary = 128Const adVarBinary = 204Const adLongVarBinary = 205Const adChapter = 136Const adFileTime = 64Const adPropVariant = 138Const adVarNumeric = 139Const adArray = &H2000'---- FieldAttributeEnum Values ----Const adFldMayDefer = &H00000002Const adFldUpdatable = &H00000004Const adFldUnknownUpdatable = &H00000008Const adFldFixed = &H00000010Const adFldIsNullable = &H00000020Const adFldMayBeNull = &H00000040Const adFldLong = &H00000080Const adFldRowID = &H00000100Const adFldRowVersion = &H00000200Const adFldCacheDeferred = &H00001000Const adFldIsChapter = &H00002000Const adFldNegativeScale = &H00004000Const adFldKeyColumn = &H00008000Const adFldIsRowURL = &H00010000Const adFldIsDefaultStream = &H00020000Const adFldIsCollection = &H00040000'---- EditModeEnum Values ----Const adEditNone = &H0000Const adEditInProgress = &H0001Const adEditAdd = &H0002Const adEditDelete = &H0004'---- RecordStatusEnum Values ----Const adRecOK = &H0000000Const adRecNew = &H0000001Const adRecModified = &H0000002Const adRecDeleted = &H0000004Const adRecUnmodified = &H0000008Const adRecInvalid = &H0000010Const adRecMultipleChanges = &H0000040Const adRecPendingChanges = &H0000080Const adRecCanceled = &H0000100Const adRecCantRelease = &H0000400Const adRecConcurrencyViolation = &H0000800Const adRecIntegrityViolation = &H0001000Const adRecMaxChangesExceeded = &H0002000Const adRecObjectOpen = &H0004000Const adRecOutOfMemory = &H0008000Const adRecPermissionDenied = &H0010000Const adRecSchemaViolation = &H0020000Const adRecDBDeleted = &H0040000'---- GetRowsOptionEnum Values ----Const adGetRowsRest = -1'---- PositionEnum Values ----Const adPosUnknown = -1Const adPosBOF = -2Const adPosEOF = -3'---- BookmarkEnum Values ----Const adBookmarkCurrent = 0Const adBookmarkFirst = 1Const adBookmarkLast = 2'---- MarshalOptionsEnum Values ----Const adMarshalAll = 0Const adMarshalModifiedOnly = 1'---- AffectEnum Values ----Const adAffectCurrent = 1Const adAffectGroup = 2Const adAffectAllChapters = 4'---- ResyncEnum Values ----Const adResyncUnderlyingValues = 1Const adResyncAllValues = 2'---- CompareEnum Values ----Const adCompareLessThan = 0Const adCompareEqual = 1Const adCompareGreaterThan = 2Const adCompareNotEqual = 3Const adCompareNotComparable = 4'---- FilterGroupEnum Values ----Const adFilterNone = 0Const adFilterPendingRecords = 1Const adFilterAffectedRecords = 2Const adFilterFetchedRecords = 3Const adFilterConflictingRecords = 5'---- SearchDirectionEnum Values ----Const adSearchForward = 1Const adSearchBackward = -1'---- PersistFormatEnum Values ----Const adPersistADTG = 0Const adPersistXML = 1'---- StringFormatEnum Values ----Const adClipString = 2'---- ConnectPromptEnum Values ----Const adPromptAlways = 1Const adPromptComplete = 2Const adPromptCompleteRequired = 3Const adPromptNever = 4'---- ConnectModeEnum Values ----Const adModeUnknown = 0Const adModeRead = 1Const adModeWrite = 2Const adModeReadWrite = 3Const adModeShareDenyRead = 4Const adModeShareDenyWrite = 8Const adModeShareExclusive = &HcConst adModeShareDenyNone = &H10Const adModeRecursive = &H400000'---- RecordCreateOptionsEnum Values ----Const adCreateCollection = &H00002000Const adCreateStructDoc = &H80000000Const adCreateNonCollection = &H00000000Const adOpenIfExists = &H02000000Const adCreateOverwrite = &H04000000Const adFailIfNotExists = -1'---- RecordOpenOptionsEnum Values ----Const adOpenRecordUnspecified = -1Const adOpenOutput = &H00800000Const adOpenAsync = &H00001000Const adDelayFetchStream = &H00004000Const adDelayFetchFields = &H00008000Const adOpenExecuteCommand = &H00010000'---- IsolationLevelEnum Values ----Const adXactUnspecified = &HffffffffConst adXactChaos = &H00000010Const adXactReadUncommitted = &H00000100Const adXactBrowse = &H00000100Const adXactCursorStability = &H00001000Const adXactReadCommitted = &H00001000Const adXactRepeatableRead = &H00010000Const adXactSerializable = &H00100000Const adXactIsolated = &H00100000'---- XactAttributeEnum Values ----Const adXactCommitRetaining = &H00020000Const adXactAbortRetaining = &H00040000'---- PropertyAttributesEnum Values ----Const adPropNotSupported = &H0000Const adPropRequired = &H0001Const adPropOptional = &H0002Const adPropRead = &H0200Const adPropWrite = &H0400'---- ErrorValueEnum Values ----Const adErrProviderFailed = &Hbb8Const adErrInvalidArgument = &Hbb9Const adErrOpeningFile = &HbbaConst adErrReadFile = &HbbbConst adErrWriteFile = &HbbcConst adErrNoCurrentRecord = &HbcdConst adErrIllegalOperation = &Hc93Const adErrCantChangeProvider = &Hc94Const adErrInTransaction = &HcaeConst adErrFeatureNotAvailable = &Hcb3Const adErrItemNotFound = &Hcc1Const adErrObjectInCollection = &Hd27Const adErrObjectNotSet = &Hd5cConst adErrDataConversion = &Hd5dConst adErrObjectClosed = &He78Const adErrObjectOpen = &He79Const adErrProviderNotFound = &He7aConst adErrBoundToCommand = &He7bConst adErrInvalidParamInfo = &He7cConst adErrInvalidConnection = &He7dConst adErrNotReentrant = &He7eConst adErrStillExecuting = &He7fConst adErrOperationCancelled = &He80Const adErrStillConnecting = &He81Const adErrInvalidTransaction = &He82Const adErrUnsafeOperation = &He84Const adwrnSecurityDialog = &He85Const adwrnSecurityDialogHeader = &He86Const adErrIntegrityViolation = &He87Const adErrPermissionDenied = &He88Const adErrDataOverflow = &He89Const adErrSchemaViolation = &He8aConst adErrSignMismatch = &He8bConst adErrCantConvertvalue = &He8cConst adErrCantCreate = &He8dConst adErrColumnNotOnThisRow = &He8eConst adErrURLIntegrViolSetColumns = &He8fConst adErrURLDoesNotExist = &He8fConst adErrTreePermissionDenied = &He90Const adErrInvalidURL = &He91Const adErrResourceLocked = &He92Const adErrResourceExists = &He93Const adErrCannotComplete = &He94Const adErrVolumeNotFound = &He95Const adErrOutOfSpace = &He96Const adErrResourceOutOfScope = &He97Const adErrUnavailable = &He98Const adErrURLNamedRowDoesNotExist = &He99Const adErrDelResOutOfScope = &He9aConst adErrPropInvalidColumn = &He9bConst adErrPropInvalidOption = &He9cConst adErrPropInvalidValue = &He9dConst adErrPropConflicting = &He9eConst adErrPropNotAllSettable = &He9fConst adErrPropNotSet = &Hea0Const adErrPropNotSettable = &Hea1Const adErrPropNotSupported = &Hea2Const adErrCatalogNotSet = &Hea3Const adErrCantChangeConnection = &Hea4Const adErrFieldsUpdateFailed = &Hea5Const adErrDenyNotSupported = &Hea6Const adErrDenyTypeNotSupported = &Hea7Const adErrProviderNotSpecified = &Hea9'---- ParameterAttributesEnum Values ----Const adParamSigned = &H0010Const adParamNullable = &H0040Const adParamLong = &H0080'---- ParameterDirectionEnum Values ----Const adParamUnknown = &H0000Const adParamInput = &H0001Const adParamOutput = &H0002Const adParamInputOutput = &H0003Const adParamReturnValue = &H0004'---- CommandTypeEnum Values ----Const adCmdUnknown = &H0008Const adCmdText = &H0001Const adCmdTable = &H0002Const adCmdStoredProc = &H0004Const adCmdFile = &H0100Const adCmdTableDirect = &H0200'---- EventStatusEnum Values ----Const adStatusOK = &H0000001Const adStatusErrorsOccurred = &H0000002Const adStatusCantDeny = &H0000003Const adStatusCancel = &H0000004Const adStatusUnwantedEvent = &H0000005'---- EventReasonEnum Values ----Const adRsnAddNew = 1Const adRsnDelete = 2Const adRsnUpdate = 3Const adRsnUndoUpdate = 4Const adRsnUndoAddNew = 5Const adRsnUndoDelete = 6Const adRsnRequery = 7Const adRsnResynch = 8Const adRsnClose = 9Const adRsnMove = 10Const adRsnFirstChange = 11Const adRsnMoveFirst = 12Const adRsnMoveNext = 13Const adRsnMovePrevious = 14Const adRsnMoveLast = 15'---- SchemaEnum Values ----Const adSchemaProviderSpecific = -1Const adSchemaAsserts = 0Const adSchemaCatalogs = 1Const adSchemaCharacterSets = 2Const adSchemaCollations = 3Const adSchemaColumns = 4Const adSchemaCheckConstraints = 5Const adSchemaConstraintColumnUsage = 6Const adSchemaConstraintTableUsage = 7Const adSchemaKeyColumnUsage = 8Const adSchemaReferentialConstraints = 9Const adSchemaTableConstraints = 10Const adSchemaColumnsDomainUsage = 11Const adSchemaIndexes = 12Const adSchemaColumnPrivileges = 13Const adSchemaTablePrivileges = 14Const adSchemaUsagePrivileges = 15Const adSchemaProcedures = 16Const adSchemaSchemata = 17Const adSchemaSQLLanguages = 18Const adSchemaStatistics = 19Const adSchemaTables = 20Const adSchemaTranslations = 21Const adSchemaProviderTypes = 22Const adSchemaViews = 23Const adSchemaViewColumnUsage = 24Const adSchemaViewTableUsage = 25Const adSchemaProcedureParameters = 26Const adSchemaForeignKeys = 27Const adSchemaPrimaryKeys = 28Const adSchemaProcedureColumns = 29Const adSchemaDBInfoKeywords = 30Const adSchemaDBInfoLiterals = 31Const adSchemaCubes = 32Const adSchemaDimensions = 33Const adSchemaHierarchies = 34Const adSchemaLevels = 35Const adSchemaMeasures = 36Const adSchemaProperties = 37Const adSchemaMembers = 38Const adSchemaTrustees = 39Const adSchemaFunctions = 40Const adSchemaActions = 41Const adSchemaCommands = 42Const adSchemaSets = 43'---- FieldStatusEnum Values ----Const adFieldOK = 0Const adFieldCantConvertValue = 2Const adFieldIsNull = 3Const adFieldTruncated = 4Const adFieldSignMismatch = 5Const adFieldDataOverflow = 6Const adFieldCantCreate = 7Const adFieldUnavailable = 8Const adFieldPermissionDenied = 9Const adFieldIntegrityViolation = 10Const adFieldSchemaViolation = 11Const adFieldBadStatus = 12Const adFieldDefault = 13Const adFieldIgnore = 15Const adFieldDoesNotExist = 16Const adFieldInvalidURL = 17Const adFieldResourceLocked = 18Const adFieldResourceExists = 19Const adFieldCannotComplete = 20Const adFieldVolumeNotFound = 21Const adFieldOutOfSpace = 22Const adFieldCannotDeleteSource = 23Const adFieldReadOnly = 24Const adFieldResourceOutOfScope = 25Const adFieldAlreadyExists = 26Const adFieldPendingInsert = &H10000Const adFieldPendingDelete = &H20000Const adFieldPendingChange = &H40000Const adFieldPendingUnknown = &H80000Const adFieldPendingUnknownDelete = &H100000'---- SeekEnum Values ----Const adSeekFirstEQ = &H1Const adSeekLastEQ = &H2Const adSeekAfterEQ = &H4Const adSeekAfter = &H8Const adSeekBeforeEQ = &H10Const adSeekBefore = &H20'---- ADCPROP_UPDATECRITERIA_ENUM Values ----Const adCriteriaKey = 0Const adCriteriaAllCols = 1Const adCriteriaUpdCols = 2Const adCriteriaTimeStamp = 3'---- ADCPROP_ASYNCTHREADPRIORITY_ENUM Values ----Const adPriorityLowest = 1Const adPriorityBelowNormal = 2Const adPriorityNormal = 3Const adPriorityAboveNormal = 4Const adPriorityHighest = 5'---- ADCPROP_AUTORECALC_ENUM Values ----Const adRecalcUpFront = 0Const adRecalcAlways = 1'---- ADCPROP_UPDATERESYNC_ENUM Values ----'---- ADCPROP_UPDATERESYNC_ENUM Values ----'---- MoveRecordOptionsEnum Values ----Const adMoveUnspecified = -1Const adMoveOverWrite = 1Const adMoveDontUpdateLinks = 2Const adMoveAllowEmulation = 4'---- CopyRecordOptionsEnum Values ----Const adCopyUnspecified = -1Const adCopyOverWrite = 1Const adCopyAllowEmulation = 4Const adCopyNonRecursive = 2'---- StreamTypeEnum Values ----Const adTypeBinary = 1Const adTypeText = 2'---- LineSeparatorEnum Values ----Const adLF = 10Const adCR = 13Const adCRLF = -1'---- StreamOpenOptionsEnum Values ----Const adOpenStreamUnspecified = -1Const adOpenStreamAsync = 1Const adOpenStreamFromRecord = 4'---- StreamWriteEnum Values ----Const adWriteChar = 0Const adWriteLine = 1'---- SaveOptionsEnum Values ----Const adSaveCreateNotExist = 1Const adSaveCreateOverWrite = 2'---- FieldEnum Values ----Const adDefaultStream = -1Const adRecordURL = -2'---- StreamReadEnum Values ----Const adReadAll = -1Const adReadLine = -2'---- RecordTypeEnum Values ----Const adSimpleRecord = 0Const adCollectionRecord = 1Const adStructDoc = 2%>