Hello,
I have an asp page that has a function that connects to an Access database.
I am using Javascript. Is there any way to reference the field name in the
database through a variable in a sql statement?
For example, in my function I have:
var dayofWeek = "Friday";
var sSQL = "";
sSQL += "SELECT C.ClientID ";
sSQL += "FROM Client AS C ";
sSQL += "INNER JOIN Formats as F ";
sSQL += "ON C.ClientID = F.ClientID) ";
sSQL += "INNER JOIN Processes as P ";
sSQL += "ON F.FormatID = P.FormatID) ";
sSQL += "INNER JOIN Frequency as FY ";
sSQL += "ON P.ProcessID = FY.ProcessID) ";
sSQL += "WHERE (FY. + 'dayofWeek' = YES) ";
I have also tried the following:
var i = "Friday;
dayofWeek = "FY." + i + "= YES ";
and then, passing it in the last sSQL: sSQL += "WHERE (dayofWeek);
How can I achieve this? Please help!
Thanks.
Consuelo :-)
7  2134 
Forget for a moment that you're constructing a query, and just look it what
you're doing for what it is. You're just building a string, right? So, if
you wanted to do something just like "Today is [day of week]" how would you
do that?
<%
var dayofWeek = "Friday";
var sentence = "Today is " + dayofWeek + ".";
Response.write(sentence);
%>
So, with your SQL string, you'd just do:
<%
var dayofWeek = "Friday";
var sSQL = "";
sSQL += "SELECT C.ClientID ";
sSQL += "FROM Client AS C ";
sSQL += "INNER JOIN Formats as F ";
sSQL += "ON C.ClientID = F.ClientID) ";
sSQL += "INNER JOIN Processes as P ";
sSQL += "ON F.FormatID = P.FormatID) ";
sSQL += "INNER JOIN Frequency as FY ";
sSQL += "ON P.ProcessID = FY.ProcessID) ";
sSQL += "WHERE (FY." + dayofWeek + " = YES)";
Response.write(sSQL);
%>
Ray at home
"Consuelo Guenther" <Co**************@discussions.microsoft.com> wrote in
message news:B1**********************************@microsof t.com... Hello,
I have an asp page that has a function that connects to an Access
database.
I am using Javascript. Is there any way to reference the field name in the
database through a variable in a sql statement?
For example, in my function I have:
var dayofWeek = "Friday";
var sSQL = "";
sSQL += "SELECT C.ClientID ";
sSQL += "FROM Client AS C ";
sSQL += "INNER JOIN Formats as F ";
sSQL += "ON C.ClientID = F.ClientID) ";
sSQL += "INNER JOIN Processes as P ";
sSQL += "ON F.FormatID = P.FormatID) ";
sSQL += "INNER JOIN Frequency as FY ";
sSQL += "ON P.ProcessID = FY.ProcessID) ";
sSQL += "WHERE (FY. + 'dayofWeek' = YES) ";
I have also tried the following:
var i = "Friday;
dayofWeek = "FY." + i + "= YES ";
and then, passing it in the last sSQL: sSQL += "WHERE (dayofWeek);
How can I achieve this? Please help!
Thanks.
Consuelo :-)
Hi Ray,
Thanks for the tip, but I am still getting an error on this:
The SELECT statement includes a reserved word or an argument name that is
mispelled or missing, or the punctuation is incorrect."
Any thoughts?
Thanks again...:-)
"Ray Costanzo [MVP]" wrote: Forget for a moment that you're constructing a query, and just look it what
you're doing for what it is. You're just building a string, right? So, if
you wanted to do something just like "Today is [day of week]" how would you
do that?
<%
var dayofWeek = "Friday";
var sentence = "Today is " + dayofWeek + ".";
Response.write(sentence);
%>
So, with your SQL string, you'd just do:
<%
var dayofWeek = "Friday";
var sSQL = "";
sSQL += "SELECT C.ClientID ";
sSQL += "FROM Client AS C ";
sSQL += "INNER JOIN Formats as F ";
sSQL += "ON C.ClientID = F.ClientID) ";
sSQL += "INNER JOIN Processes as P ";
sSQL += "ON F.FormatID = P.FormatID) ";
sSQL += "INNER JOIN Frequency as FY ";
sSQL += "ON P.ProcessID = FY.ProcessID) ";
sSQL += "WHERE (FY." + dayofWeek + " = YES)";
Response.write(sSQL);
%>
Ray at home
"Consuelo Guenther" <Co**************@discussions.microsoft.com> wrote in
message news:B1**********************************@microsof t.com... Hello,
I have an asp page that has a function that connects to an Access
database.
I am using Javascript. Is there any way to reference the field name in the
database through a variable in a sql statement?
For example, in my function I have:
var dayofWeek = "Friday";
var sSQL = "";
sSQL += "SELECT C.ClientID ";
sSQL += "FROM Client AS C ";
sSQL += "INNER JOIN Formats as F ";
sSQL += "ON C.ClientID = F.ClientID) ";
sSQL += "INNER JOIN Processes as P ";
sSQL += "ON F.FormatID = P.FormatID) ";
sSQL += "INNER JOIN Frequency as FY ";
sSQL += "ON P.ProcessID = FY.ProcessID) ";
sSQL += "WHERE (FY. + 'dayofWeek' = YES) ";
I have also tried the following:
var i = "Friday;
dayofWeek = "FY." + i + "= YES ";
and then, passing it in the last sSQL: sSQL += "WHERE (dayofWeek);
How can I achieve this? Please help!
Thanks.
Consuelo :-)
Response.write(sSQL);
Response.end;
What does that give you? It's kinda hard to debug a query without knowing
what it is.
Ray at home
"Consuelo Guenther" <Co**************@discussions.microsoft.com> wrote in
message news:A1**********************************@microsof t.com... Hi Ray,
Thanks for the tip, but I am still getting an error on this:
The SELECT statement includes a reserved word or an argument name that is
mispelled or missing, or the punctuation is incorrect."
Any thoughts?
Thanks again...:-)
"Ray Costanzo [MVP]" wrote:
Forget for a moment that you're constructing a query, and just look it
what
you're doing for what it is. You're just building a string, right? So,
if
you wanted to do something just like "Today is [day of week]" how would
you
do that?
<%
var dayofWeek = "Friday";
var sentence = "Today is " + dayofWeek + ".";
Response.write(sentence);
%>
So, with your SQL string, you'd just do:
<%
var dayofWeek = "Friday";
var sSQL = "";
sSQL += "SELECT C.ClientID ";
sSQL += "FROM Client AS C ";
sSQL += "INNER JOIN Formats as F ";
sSQL += "ON C.ClientID = F.ClientID) ";
sSQL += "INNER JOIN Processes as P ";
sSQL += "ON F.FormatID = P.FormatID) ";
sSQL += "INNER JOIN Frequency as FY ";
sSQL += "ON P.ProcessID = FY.ProcessID) ";
sSQL += "WHERE (FY." + dayofWeek + " = YES)";
Response.write(sSQL);
%>
Ray at home
"Consuelo Guenther" <Co**************@discussions.microsoft.com> wrote in
message news:B1**********************************@microsof t.com... > Hello,
> I have an asp page that has a function that connects to an Access
> database.
> I am using Javascript. Is there any way to reference the field name in
> the
> database through a variable in a sql statement?
>
> For example, in my function I have:
>
> var dayofWeek = "Friday";
> var sSQL = "";
>
> sSQL += "SELECT C.ClientID ";
> sSQL += "FROM Client AS C ";
> sSQL += "INNER JOIN Formats as F ";
> sSQL += "ON C.ClientID = F.ClientID) ";
> sSQL += "INNER JOIN Processes as P ";
> sSQL += "ON F.FormatID = P.FormatID) ";
> sSQL += "INNER JOIN Frequency as FY ";
> sSQL += "ON P.ProcessID = FY.ProcessID) ";
> sSQL += "WHERE (FY. + 'dayofWeek' = YES) ";
>
> I have also tried the following:
> var i = "Friday;
> dayofWeek = "FY." + i + "= YES ";
> and then, passing it in the last sSQL: sSQL += "WHERE (dayofWeek);
>
> How can I achieve this? Please help!
> Thanks.
> Consuelo :-)
>
>
>
>
>
>
>
>
Basically I have a table which contains the following fields:
FrequencyID, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, and
Saturday. All fields are Yes/No, except for the FrequencyID. I need to select
all clients that have processes on a weekdate, depending on what day of the
week is today. So, today, my query would select all clients that have the
Sunday field set to yes. That is why I need to have the variable dayofWeek
determine what field in my database I need to match to.
Thanks again. :-)
"Ray Costanzo [MVP]" wrote: Response.write(sSQL);
Response.end;
What does that give you? It's kinda hard to debug a query without knowing
what it is.
Ray at home
"Consuelo Guenther" <Co**************@discussions.microsoft.com> wrote in
message news:A1**********************************@microsof t.com... Hi Ray,
Thanks for the tip, but I am still getting an error on this:
The SELECT statement includes a reserved word or an argument name that is
mispelled or missing, or the punctuation is incorrect."
Any thoughts?
Thanks again...:-)
"Ray Costanzo [MVP]" wrote:
Forget for a moment that you're constructing a query, and just look it
what
you're doing for what it is. You're just building a string, right? So,
if
you wanted to do something just like "Today is [day of week]" how would
you
do that?
<%
var dayofWeek = "Friday";
var sentence = "Today is " + dayofWeek + ".";
Response.write(sentence);
%>
So, with your SQL string, you'd just do:
<%
var dayofWeek = "Friday";
var sSQL = "";
sSQL += "SELECT C.ClientID ";
sSQL += "FROM Client AS C ";
sSQL += "INNER JOIN Formats as F ";
sSQL += "ON C.ClientID = F.ClientID) ";
sSQL += "INNER JOIN Processes as P ";
sSQL += "ON F.FormatID = P.FormatID) ";
sSQL += "INNER JOIN Frequency as FY ";
sSQL += "ON P.ProcessID = FY.ProcessID) ";
sSQL += "WHERE (FY." + dayofWeek + " = YES)";
Response.write(sSQL);
%>
Ray at home
"Consuelo Guenther" <Co**************@discussions.microsoft.com> wrote in
message news:B1**********************************@microsof t.com...
> Hello,
> I have an asp page that has a function that connects to an Access
> database.
> I am using Javascript. Is there any way to reference the field name in
> the
> database through a variable in a sql statement?
>
> For example, in my function I have:
>
> var dayofWeek = "Friday";
> var sSQL = "";
>
> sSQL += "SELECT C.ClientID ";
> sSQL += "FROM Client AS C ";
> sSQL += "INNER JOIN Formats as F ";
> sSQL += "ON C.ClientID = F.ClientID) ";
> sSQL += "INNER JOIN Processes as P ";
> sSQL += "ON F.FormatID = P.FormatID) ";
> sSQL += "INNER JOIN Frequency as FY ";
> sSQL += "ON P.ProcessID = FY.ProcessID) ";
> sSQL += "WHERE (FY. + 'dayofWeek' = YES) ";
>
> I have also tried the following:
> var i = "Friday;
> dayofWeek = "FY." + i + "= YES ";
> and then, passing it in the last sSQL: sSQL += "WHERE (dayofWeek);
>
> How can I achieve this? Please help!
> Thanks.
> Consuelo :-)
>
>
>
>
>
>
>
>
Response.write(sSQL);
Response.end;
What does that give you? It's kinda hard to debug a query without knowing
what it is.
Ray at home
"Consuelo Guenther" <Co**************@discussions.microsoft.com> wrote in
message news:43**********************************@microsof t.com... Basically I have a table which contains the following fields:
FrequencyID, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, and
Saturday. All fields are Yes/No, except for the FrequencyID. I need to
select
all clients that have processes on a weekdate, depending on what day of
the
week is today. So, today, my query would select all clients that have the
Sunday field set to yes. That is why I need to have the variable dayofWeek
determine what field in my database I need to match to.
Thanks again. :-)
"Ray Costanzo [MVP]" wrote:
Response.write(sSQL);
Response.end;
What does that give you? It's kinda hard to debug a query without
knowing
what it is.
Ray at home
"Consuelo Guenther" <Co**************@discussions.microsoft.com> wrote in
message news:A1**********************************@microsof t.com... > Hi Ray,
> Thanks for the tip, but I am still getting an error on this:
> The SELECT statement includes a reserved word or an argument name that
> is
> mispelled or missing, or the punctuation is incorrect."
>
> Any thoughts?
> Thanks again...:-)
>
>
> "Ray Costanzo [MVP]" wrote:
>
>> Forget for a moment that you're constructing a query, and just look it
>> what
>> you're doing for what it is. You're just building a string, right?
>> So,
>> if
>> you wanted to do something just like "Today is [day of week]" how
>> would
>> you
>> do that?
>>
>> <%
>> var dayofWeek = "Friday";
>> var sentence = "Today is " + dayofWeek + ".";
>> Response.write(sentence);
>> %>
>>
>> So, with your SQL string, you'd just do:
>>
>> <%
>> var dayofWeek = "Friday";
>> var sSQL = "";
>>
>> sSQL += "SELECT C.ClientID ";
>> sSQL += "FROM Client AS C ";
>> sSQL += "INNER JOIN Formats as F ";
>> sSQL += "ON C.ClientID = F.ClientID) ";
>> sSQL += "INNER JOIN Processes as P ";
>> sSQL += "ON F.FormatID = P.FormatID) ";
>> sSQL += "INNER JOIN Frequency as FY ";
>> sSQL += "ON P.ProcessID = FY.ProcessID) ";
>> sSQL += "WHERE (FY." + dayofWeek + " = YES)";
>> Response.write(sSQL);
>> %>
>>
>> Ray at home
>>
>>
>> "Consuelo Guenther" <Co**************@discussions.microsoft.com> wrote
>> in
>> message news:B1**********************************@microsof t.com...
>> > Hello,
>> > I have an asp page that has a function that connects to an Access
>> > database.
>> > I am using Javascript. Is there any way to reference the field name
>> > in
>> > the
>> > database through a variable in a sql statement?
>> >
>> > For example, in my function I have:
>> >
>> > var dayofWeek = "Friday";
>> > var sSQL = "";
>> >
>> > sSQL += "SELECT C.ClientID ";
>> > sSQL += "FROM Client AS C ";
>> > sSQL += "INNER JOIN Formats as F ";
>> > sSQL += "ON C.ClientID = F.ClientID) ";
>> > sSQL += "INNER JOIN Processes as P ";
>> > sSQL += "ON F.FormatID = P.FormatID) ";
>> > sSQL += "INNER JOIN Frequency as FY ";
>> > sSQL += "ON P.ProcessID = FY.ProcessID) ";
>> > sSQL += "WHERE (FY. + 'dayofWeek' = YES) ";
>> >
>> > I have also tried the following:
>> > var i = "Friday;
>> > dayofWeek = "FY." + i + "= YES ";
>> > and then, passing it in the last sSQL: sSQL += "WHERE (dayofWeek);
>> >
>> > How can I achieve this? Please help!
>> > Thanks.
>> > Consuelo :-)
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>>
>>
>>
Hey Ray,
I figured the issue out. Thanks for your help. I was doing something wrong,
but now I have another question which is the second part of this issue you
have been helping me with.
I am able to return the sSQL string appropriately now. The SQL statement
should return an array of clients which have frequency of Sunday. How do I
call the function in another asp page to return the clients selected? I have
tried the following:
var iClients = oConn.execute(clientsbyDate());
var iClients = new Array (oConn.execute(clientsbyDate()));
clientsbyDate is the function I have that will return the sSQL statement. I
got errors in both cases when I tried to do Response.Write(iClients);
Thanks again for your help!!! :-)
"Ray Costanzo [MVP]" wrote: Response.write(sSQL);
Response.end;
What does that give you? It's kinda hard to debug a query without knowing
what it is.
Ray at home
"Consuelo Guenther" <Co**************@discussions.microsoft.com> wrote in
message news:43**********************************@microsof t.com... Basically I have a table which contains the following fields:
FrequencyID, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, and
Saturday. All fields are Yes/No, except for the FrequencyID. I need to
select
all clients that have processes on a weekdate, depending on what day of
the
week is today. So, today, my query would select all clients that have the
Sunday field set to yes. That is why I need to have the variable dayofWeek
determine what field in my database I need to match to.
Thanks again. :-)
"Ray Costanzo [MVP]" wrote:
Response.write(sSQL);
Response.end;
What does that give you? It's kinda hard to debug a query without
knowing
what it is.
Ray at home
"Consuelo Guenther" <Co**************@discussions.microsoft.com> wrote in
message news:A1**********************************@microsof t.com...
> Hi Ray,
> Thanks for the tip, but I am still getting an error on this:
> The SELECT statement includes a reserved word or an argument name that
> is
> mispelled or missing, or the punctuation is incorrect."
>
> Any thoughts?
> Thanks again...:-)
>
>
> "Ray Costanzo [MVP]" wrote:
>
>> Forget for a moment that you're constructing a query, and just look it
>> what
>> you're doing for what it is. You're just building a string, right?
>> So,
>> if
>> you wanted to do something just like "Today is [day of week]" how
>> would
>> you
>> do that?
>>
>> <%
>> var dayofWeek = "Friday";
>> var sentence = "Today is " + dayofWeek + ".";
>> Response.write(sentence);
>> %>
>>
>> So, with your SQL string, you'd just do:
>>
>> <%
>> var dayofWeek = "Friday";
>> var sSQL = "";
>>
>> sSQL += "SELECT C.ClientID ";
>> sSQL += "FROM Client AS C ";
>> sSQL += "INNER JOIN Formats as F ";
>> sSQL += "ON C.ClientID = F.ClientID) ";
>> sSQL += "INNER JOIN Processes as P ";
>> sSQL += "ON F.FormatID = P.FormatID) ";
>> sSQL += "INNER JOIN Frequency as FY ";
>> sSQL += "ON P.ProcessID = FY.ProcessID) ";
>> sSQL += "WHERE (FY." + dayofWeek + " = YES)";
>> Response.write(sSQL);
>> %>
>>
>> Ray at home
>>
>>
>> "Consuelo Guenther" <Co**************@discussions.microsoft.com> wrote
>> in
>> message news:B1**********************************@microsof t.com...
>> > Hello,
>> > I have an asp page that has a function that connects to an Access
>> > database.
>> > I am using Javascript. Is there any way to reference the field name
>> > in
>> > the
>> > database through a variable in a sql statement?
>> >
>> > For example, in my function I have:
>> >
>> > var dayofWeek = "Friday";
>> > var sSQL = "";
>> >
>> > sSQL += "SELECT C.ClientID ";
>> > sSQL += "FROM Client AS C ";
>> > sSQL += "INNER JOIN Formats as F ";
>> > sSQL += "ON C.ClientID = F.ClientID) ";
>> > sSQL += "INNER JOIN Processes as P ";
>> > sSQL += "ON F.FormatID = P.FormatID) ";
>> > sSQL += "INNER JOIN Frequency as FY ";
>> > sSQL += "ON P.ProcessID = FY.ProcessID) ";
>> > sSQL += "WHERE (FY. + 'dayofWeek' = YES) ";
>> >
>> > I have also tried the following:
>> > var i = "Friday;
>> > dayofWeek = "FY." + i + "= YES ";
>> > and then, passing it in the last sSQL: sSQL += "WHERE (dayofWeek);
>> >
>> > How can I achieve this? Please help!
>> > Thanks.
>> > Consuelo :-)
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>>
>>
>>
Hey Ray,
Thanks for your help. I figured out the second part and ended up using the
JScript method GetRow.
Have a great one! :-)
"Consuelo Guenther" wrote: Hey Ray,
I figured the issue out. Thanks for your help. I was doing something wrong,
but now I have another question which is the second part of this issue you
have been helping me with.
I am able to return the sSQL string appropriately now. The SQL statement
should return an array of clients which have frequency of Sunday. How do I
call the function in another asp page to return the clients selected? I have
tried the following:
var iClients = oConn.execute(clientsbyDate());
var iClients = new Array (oConn.execute(clientsbyDate()));
clientsbyDate is the function I have that will return the sSQL statement. I
got errors in both cases when I tried to do Response.Write(iClients);
Thanks again for your help!!! :-)
"Ray Costanzo [MVP]" wrote:
Response.write(sSQL);
Response.end;
What does that give you? It's kinda hard to debug a query without knowing
what it is.
Ray at home
"Consuelo Guenther" <Co**************@discussions.microsoft.com> wrote in
message news:43**********************************@microsof t.com... Basically I have a table which contains the following fields:
FrequencyID, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, and
Saturday. All fields are Yes/No, except for the FrequencyID. I need to
select
all clients that have processes on a weekdate, depending on what day of
the
week is today. So, today, my query would select all clients that have the
Sunday field set to yes. That is why I need to have the variable dayofWeek
determine what field in my database I need to match to.
Thanks again. :-)
"Ray Costanzo [MVP]" wrote:
> Response.write(sSQL);
> Response.end;
>
> What does that give you? It's kinda hard to debug a query without
> knowing
> what it is.
>
> Ray at home
>
>
> "Consuelo Guenther" <Co**************@discussions.microsoft.com> wrote in
> message news:A1**********************************@microsof t.com...
> > Hi Ray,
> > Thanks for the tip, but I am still getting an error on this:
> > The SELECT statement includes a reserved word or an argument name that
> > is
> > mispelled or missing, or the punctuation is incorrect."
> >
> > Any thoughts?
> > Thanks again...:-)
> >
> >
> > "Ray Costanzo [MVP]" wrote:
> >
> >> Forget for a moment that you're constructing a query, and just look it
> >> what
> >> you're doing for what it is. You're just building a string, right?
> >> So,
> >> if
> >> you wanted to do something just like "Today is [day of week]" how
> >> would
> >> you
> >> do that?
> >>
> >> <%
> >> var dayofWeek = "Friday";
> >> var sentence = "Today is " + dayofWeek + ".";
> >> Response.write(sentence);
> >> %>
> >>
> >> So, with your SQL string, you'd just do:
> >>
> >> <%
> >> var dayofWeek = "Friday";
> >> var sSQL = "";
> >>
> >> sSQL += "SELECT C.ClientID ";
> >> sSQL += "FROM Client AS C ";
> >> sSQL += "INNER JOIN Formats as F ";
> >> sSQL += "ON C.ClientID = F.ClientID) ";
> >> sSQL += "INNER JOIN Processes as P ";
> >> sSQL += "ON F.FormatID = P.FormatID) ";
> >> sSQL += "INNER JOIN Frequency as FY ";
> >> sSQL += "ON P.ProcessID = FY.ProcessID) ";
> >> sSQL += "WHERE (FY." + dayofWeek + " = YES)";
> >> Response.write(sSQL);
> >> %>
> >>
> >> Ray at home
> >>
> >>
> >> "Consuelo Guenther" <Co**************@discussions.microsoft.com> wrote
> >> in
> >> message news:B1**********************************@microsof t.com...
> >> > Hello,
> >> > I have an asp page that has a function that connects to an Access
> >> > database.
> >> > I am using Javascript. Is there any way to reference the field name
> >> > in
> >> > the
> >> > database through a variable in a sql statement?
> >> >
> >> > For example, in my function I have:
> >> >
> >> > var dayofWeek = "Friday";
> >> > var sSQL = "";
> >> >
> >> > sSQL += "SELECT C.ClientID ";
> >> > sSQL += "FROM Client AS C ";
> >> > sSQL += "INNER JOIN Formats as F ";
> >> > sSQL += "ON C.ClientID = F.ClientID) ";
> >> > sSQL += "INNER JOIN Processes as P ";
> >> > sSQL += "ON F.FormatID = P.FormatID) ";
> >> > sSQL += "INNER JOIN Frequency as FY ";
> >> > sSQL += "ON P.ProcessID = FY.ProcessID) ";
> >> > sSQL += "WHERE (FY. + 'dayofWeek' = YES) ";
> >> >
> >> > I have also tried the following:
> >> > var i = "Friday;
> >> > dayofWeek = "FY." + i + "= YES ";
> >> > and then, passing it in the last sSQL: sSQL += "WHERE (dayofWeek);
> >> >
> >> > How can I achieve this? Please help!
> >> > Thanks.
> >> > Consuelo :-)
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >>
> >>
> >>
>
>
>
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Jack |
last post by:
Hi, I have a checkbox the value which goes to a database via a asp page that
builds the sql string.
In the front end asp page, the checkbox code is written as follows:
<i><input...
|
by: Pato Secruza |
last post by:
How can I print the database structure, including non default
variables like Requiered, FieldSize, and most important DESCRIPTION. I
want a table like this:
...
|
by: Pam Ammond |
last post by:
I need the code to update the database when Save is clicked and a text field
has changed. This should be very easy since I used Microsoft's wizards for
the OleDBAdapter and OleDBConnection, and...
|
by: QT |
last post by:
Dear sirs,
I want to create panel or label field for each database records. I am using
following codes for each database row to create panel field.
'Panel
'
i = 1
|
by: MP |
last post by:
Greets,
context: vb6/ado/.mdb/jet 4.0 (no access)/sql
beginning learner, first database, planning stages
(I think the underlying question here is whether to normalize or not to
normalize this...
|
by: Ian Davies |
last post by:
Hello
Needing help with a suitable solution.
I have extracted records into a table under three columns 'category',
'comment' and share (the category column also holds the index no of the
record...
|
by: Jerim79 |
last post by:
I am no PHP programmer. At my current job I made it known that I was no
PHP programmer during the interview. Still they have given me a script
to write with the understanding that it will take me a...
|
by: Merlin1857 |
last post by:
How to search multiple fields using ASP
A major issue for me when I first started writing in VB Script was constructing the ability to search a table using multiple field input from a form and...
|
by: dragiton |
last post by:
SA Upload SQL Database variable types (image upload and storage)
I am having trouble with the SA Upload utility. The following code used to work correctly. However, I lost my database and had to...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
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...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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,...
|
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,...
|
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...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
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,...
| |
