473,399 Members | 3,832 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,399 software developers and data experts.

GetString equivalent

Is there an equivalent. I am using the ODP adapter
String = recordset.GetString(StringFormat, NumRows, ColumnDelimiter,
RowDelimiter, NullExpr)

Dim sScript As New System.Text.StringBuilder
rpttype = selTable.SelectedItem.Text 'Report Type as it
appears in TRACKS (ex: DTTS, OCEAN_CARGO, RAIL)
Dim conn As OracleConnection = New
OracleConnection(Context.Application("connectionSt ring"))
Dim cmd1 As OracleCommand = New OracleCommand("SELECT
ID,RPTNAME,OPTIONS,DESCRIPTION,MAPID FROM TRACK.V_RPTTRACK WHERE
RPTTYPE = '" & rpttype & "'", conn)
conn.Open()
Dim dr As OracleDataReader = cmd1.ExecuteReader()
Dim aaa As Integer = 0
Do While dr.Read
aaa = aaa + 1
' Dim sScript As String
sScript.Append("<script language=""JavaScript"">")

sScript.Append("function LoadRoutines()")
sScript.Append("{")
sScript.Append("GetParameters(100);")
sScript.Append("}")

sScript.Append("function GetParameters(maxTime)")
sScript.Append("{")
sScript.Append("var timerID;")
sScript.Append("Try")
sScript.Append("{")
sScript.Append("parent.frames(""control"").ReportH older.value
= '" & dr.GetString(2, , "":"", ""|"") & ""'"")
sScript.Append("Parent.frames(""control"").CreateO ptArr()")
sScript.Append("var(Str() =
Parent.frames(""control"").ReportHolder.value)")
sScript.Append("var(arr = Str.split(""|""))")
sScript.Append("Parent.frames(""control"").ClearSe lectCntrl(""selReport"")")
sScript.Append("Parent.frames(""control"").LoadSel ectCntrl(""selReport"",
arr)")
sScript.Append("
//parent.frames(""control"").rptDescrip.innerText =
parent.frames(""control"").CreateDescArr(parent.fr ames(""control"").selReport.selectedIndex)
")
sScript.Append("}")
sScript.Append("catch (everything)")
sScript.Append("{")
sScript.Append("If (Number(maxTime) > 0) Then")
sScript.Append("{")

sScript.Append("timerID =
window.setTimeout('GetParameters('+ (Number(maxTime)-1) +')', 100); ")
sScript.Append("}")
sScript.Append("}")
sScript.Append("}")

sScript.Append("</script>")
Loop
RegisterStartupScript("ForceDefaultToScript",
sScript.ToString)
Jul 19 '05 #1
0 1780

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Seán Meehan | last post by:
Hi, Hope somebody can help because i've looked everywhere else fo ran answer. I'm connecting to an Access table with 100+ rows of data of approx 20 columns wide. I'm using getstring to "Quickly"...
2
by: Paul K | last post by:
I've run into a problem using this method that I have been able to work around, but I think that there is a more elegant way. I create an array of 256 bytes and use the SHBrowseForFolders API...
3
by: GTi | last post by:
I have a SQL database and some fields may be null. This will trow an exeption: string s=new string; s=String.Format("{0}",myReader.GetString(1)); s=String.Format("{0}",myReader.GetString(2));...
1
by: scott_hutter | last post by:
Given the following: string x = System.Text.Encoding.Default.GetString(buffer); x = x.Replace("\r\n", "\r"); If the buffer contains 13 and 10 (2 bytes), can someone please tell me why the...
1
by: DaveF | last post by:
Is there an equivalent String = recordset.GetString(StringFormat, NumRows, ColumnDelimiter, RowDelimiter, NullExpr) -- David
4
by: cok | last post by:
Hi, All I have a question about Encoding.ASCII.GetString. I want convert a byte array to a string, I use Encoding.ASCII.GetString(byteArray) (byteArray is something like ) but the retult...
3
by: Frank Milverckowitz | last post by:
Hi, Newbie question about SqlDataReader column value access... In java jdbc code to get a value from a table column we can pass the column name (instead of an int index or offset): String...
1
by: mikfrost | last post by:
I'm trying to read the exif info in a JPG image file. Reading the ImageDescription field (270) that contains "abcæåø" only reads the first 3 characters "abc". The field was written with ACDSee...
0
by: helixpoint | last post by:
Is there an equivalent. I am using the ODP adapter String = recordset.GetString(StringFormat, NumRows, ColumnDelimiter, RowDelimiter, NullExpr) Dim sScript As New System.Text.StringBuilder...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.