Code:
sub ValidateValues() DFData = "DatadField1,DatadField2,DatadField3,DatadField4,DatadField5" DFDataArry = split(DFData,",") DFTitle = "DF1Title,DF2Title,DF3Title,DF4Title,DF5Title" DFTitleArray = split(DFTitle,",")
adz1809
Last Activity: Dec 9 '09, 11:09 AM
Joined: Dec 11 '06
Location:
-
Convert String Value into a Variable name?
The title says it all, I need to converta string into a varialbe so that I can gain another value. here is the code so far:
... -
Div Issues in FireFox
I have a page with the following code:
[HTML]<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
... -
Just to let you know, this is all sorted, this is the final code:
...Code:dim cquery OpenDatabaseOrder() cquery = "CREATE VIEW VIEW_OFW_New_Prog_Award_Detail" & vbcrlf cquery = cquery & "AS" & vbcrlf cquery = cquery & "SELECT " & vbcrlf cquery = cquery & "OFW_New_Programme_Awards.AwardID AS AwardID, " & vbcrlf
-
Just so that the code is nice and tidy and arrives in the same format, rather than one long string, it's just a personal thing, it shouldn't affect it.Leave a comment:
-
It is part of an vbscript page which requires a view to be dropped then re-created so that it is up-to-date with any changes.Leave a comment:
-
It is used a variable to hold the SQL syntax, which is then past into:
sysDatabase.exe cute(cquery)Leave a comment:
-
I have followed this syntax and it keeps failing.
this is the syntax that I have used:
CREATE VIEW VIEW_OFW_New_Pr og_Award_Detail _test
AS
SELECT
OFW_New_Program me_Awards.Award ID AS AwardID,
OFW_New_Program me_Awards.Progr ammeID AS ProgrammeID,
OFW_New_Program me_Awards.Point sValue AS PointsValue,
OFW_New_Awards. Status AS Status,
OFW_New_Awards. Category AS OFCategory,...Leave a comment:
-
Create View ?
Hi,
How do I change this statement into a create view :
SELECT dbo.OFW_New_Pro gramme_Awards.A wardID AS AwardID, dbo.OFW_New_Pro gramme_Awards.P rogrammeID AS ProgrammeID,
dbo.OFW_New_Pro gramme_Awards.P ointsValue AS PointsValue, dbo.OFW_New_Awa rds.Status AS Status, dbo.OFW_New_Awa rds.Category AS OFCategory,
dbo.OFW_New_Awa rds.Title AS Title, dbo.OFW_New_Awa rds.UnitQuantit y... -
Send XML file to a client
Hi, I have created a sub that will allow me to collect data from a sql database and save the results into an xml file as follows:
[HTML]Sub Page_Load(Sourc e as Object, E as EventArgs)
Dim strCon as string = ConfigurationSe ttings.AppSetti ngs("SystemConn ectionNew")
Dim strSQL as string = "SELECT Top 10 * FROM tbl_ACCO_EU_Con tacts"
Dim objDataSet as New DataSet()
... -
HELP!! - Passing a Form Value into a Paramater
HI,
I'm creating an update form for update a records within a db.
The update routine is working if I hard code value into it.
The problem is that the form values are not being passed into the parameters.
Here is the code:
[HTML]Sub UpdateRec(Sourc e as Object, E as EventArgs)
dim dsn As String = ConfigurationSe ttings.AppSetti ngs("SystemConn ectionNew")... -
Yep, the redirect works fine and no I didn't choose the colour, it did that all by itself.
Does the redirect have an effect on the update?...Leave a comment:
-
Updating a record - asp.net with vb.net
I'm trying to update a record using "System.Data.Sq lClient" in asp.net.
Here is my code:
[HTML]<%@ import namespace="Syst em.Data" %>
<%@ import namespace="Syst em.Data.SqlClie nt" %>
<Script Language="VB" Runat="Server">
dim objCmd As SqlCommand
dim objRdr As SqlDataReader
dim strCmd As String
... -
OLE prob - Must declare the variable '@Title'.
I'm having a problem with updating a record through a form.
Here is the error:
[HTML]Server Error in '/AccoEndUser' Application.
--------------------------------------------------------------------------------
Must declare the variable '@Title'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information... -
All sorted, here is the finished code:
[HTML]Sub BindData()
dim dsn As String = ConfigurationSe ttings.AppSetti ngs("SystemConn ection")
dim objConn as New OleDbConnection (dsn)
objCmd = New OleDbCommand("S ELECT top 10 * FROM tbl_ACCO_EU_Con tacts", objConn )
objConn.open()
objRdr = objCmd.ExecuteR eader()
...Leave a comment:
-
This is the code at the moment:
[HTML]Sub BindData()
opendatabase()
objCmd = New OleDbCommand("S ELECT top 10 * FROM tbl_ACCO_EU_Con tacts", sysConn )
objRdr = objCmd.ExecuteR eader()
dbcontacts.Data Source = objRdr
dbcontacts.Data Bind()
objRdr.Close()
End Sub[/HTML]
And I'm getting...Leave a comment:
-
Db Connection and DataGrids
Hi all,
I'm have issues with my DB connection and the use of DataGrids.
My DB connection is through my web.config file and the sub looks as follows:
[HTML]sub OpenDatabase()
sysConn = ConfigurationSe ttings.AppSetti ngs("SystemConn ection")
sysDatabase = server.createob ject("ADODB.con nection")
sysDatabase.ope n(sysConn)
end sub[/HTML]... -
CSS Dropdown Menu being over-lapped by other other screen elements
I have a CSS Dropdown Menu being over-lapped by other other screen elements. I've looked at z-index, but this seems to be having little effect.
Any ideas welcome.
cheers -
any help please? It works to a point IE, but no go at all in Firefox.
Also it is appearing underneath other page content any help in this would also be great, I tried z-indexing but no joy.Leave a comment:
-
here's the full HTML -
<body>
<div id="holder">
<div id="header">
<div id="nav">
<ul class="level1">
<li class="submenu" ><a href="../orderflow/control.aspx">O rder Control</a></li>
<ul class="level2">
<li><a...Leave a comment:
-
CSS drop-down menu not showing firefox
Here is the HTML -
<div id="nav">
<ul class="level1">
<li class="submenu" ><a href="../orderflow/control.aspx">O rder Control</a></li>
<ul class="level2">
<li><a href="#">Summar y</a></li>
</ul>
<li class="submenu" ><a...
No activity results to display
Leave a comment: